Freelancers Network
 
skill list top cap
Homepage
Join the Freelancer's Network
Update your details
Find a freelancer
Post a project
Find a project
Projects Archive
Post a job
Find a job
Jobs Archive
See Dan's Pages
See Andy's Pages
Link to this site
Resources
Join/Leave Forum
Forum Messages
+Additions+ Adverts
Advertising
Contact Us
Subscribe to our newsletter - enter your email address and hit return
Freelancers.net is owned and operated by Andy Stowell and Dan Winchester
skill list end cap
guru web hostcom

Find me again on Freelancers.net

Freelancers Forum Messages on Tuesday January 13th 2004

Re: FN-FORUM: Apache/GD/PHP/MySql build etc..

date posted 13th January 2004 22:36

Hugh F wrote: > Some kind soul sent a link some months back with > the place to grab all the files for a Linux server upgrade > and instructions. You're not thinking of http://www.apachetoolbox.com...

RE: FN-FORUM: connection testing

date posted 13th January 2004 21:48

No probs here Win98 IE6 Sp1 BT ADSL Alan S On 13 January 2004 21:49, Rus Foster [EMAIL REMOVED] wrote: > > Hi, > Please could people visit the following sites and tell me if anyone sees > any prob...

Re: FN-FORUM: connection testing

date posted 13th January 2004 21:23

Rus Foster wrote: > Hi, > Please could people visit the following sites and tell me if anyone sees > any problems with downloading images > > http://rdbmstoolbox.no-ip.org > http://sybase-addict.com...

FN-FORUM: connection testing

date posted 13th January 2004 21:07

Hi, Please could people visit the following sites and tell me if anyone sees any problems with downloading images http://rdbmstoolbox.no-ip.org http://sybase-addict.com http://sa.myvnc.com/about00....

RE: FN-FORUM: Anyone know someone who's getting married this year ?

date posted 13th January 2004 19:46

If you need a honeymoon sorting... =20 Andy IWD2 LLP [EMAIL REMOVED] =20 -----Original Message----- From: Charles E.Gatenby [EMAIL REMOVED] Sent: 13 January 2004 19:37 To: Andy Macnaughton-Jones Sub...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 19:33

> it's very usefull expecialy if you need to show year by year (horizontal) > and month by month (vertical) data. > > SELECT > DATE_FORMAT( date_field, "%m" ) AS month, > SUM(IF(DATE_FORMAT(da...

RE: FN-FORUM: Anyone know someone who's getting married this year ?

date posted 13th January 2004 19:21

congratulation Charles, does she know yet? Andrew...

RE: FN-FORUM: Anyone know someone who's getting married this year ?

date posted 13th January 2004 18:55

I be getting married this year! (in May) to me girl! Chaz.. > -----Original Message----- > From: Bob Gentle [EMAIL REMOVED] > Sent: 13 January 2004 16:21 > To: Charles E. Gatenby > Subject: FN-FOR...

Re: FN-FORUM: salsa

date posted 13th January 2004 18:37

[EMAIL REMOVED] wrote: > > >>does anyone recommend using salsa > > > Only if accompanied by nachos, guacamole and sour cream. :) > Anyone notice in tonight's Simpsons that Bart's "band" was call...

Re: FN-FORUM: salsa

date posted 13th January 2004 18:18

ba dum tish ! ----- Original Message ----- From: [EMAIL REMOVED] To: [EMAIL REMOVED] Sent: Tuesday, January 13, 2004 6:22 PM Subject: RE: FN-FORUM: salsa > > > > > > does anyone recommend using sa...

Re: FN-FORUM: Apache/GD/PHP/MySql build etc..

date posted 13th January 2004 18:16

> > Some kind soul sent a link some months back with > > the place to grab all the files for a Linux server upgrade > > and instructions. > > Which Linux falvour are you running ? SuSE 8.0 (2.4.10-4...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 18:04

> I hadn't seen the funky SUM( IF(i.barcode IS NULL,1,0) ) AS count thing > before so I'll be popping that in my notes ;) it's very usefull expecialy if you need to show year by year (horizontal) and...

RE: FN-FORUM: salsa

date posted 13th January 2004 17:39

> > does anyone recommend using salsa Only if accompanied by nachos, guacamole and sour cream. :) Regards Sam Morgan WIREDEYES Internet Consultancy t : 0845 644 6568 (Local Rate) f : 0871...

RE: FN-FORUM: salsa

date posted 13th January 2004 17:39

Carla I am shocked, I had you down as a tango gal ;) Andrew >...

Re: FN-FORUM: Apache/GD/PHP/MySql build etc..

date posted 13th January 2004 17:33

> Some kind soul sent a link some months back with > the place to grab all the files for a Linux server upgrade > and instructions. Which Linux falvour are you running ? -- Gregory Brzeski...

Re: FN-FORUM: salsa

date posted 13th January 2004 17:25

on 13/1/04 5:48 pm, Business A2Z at [EMAIL REMOVED] wrote: > > does anyone recommend using salsa Basics steps were OK but after a few weeks I found it quite hard....

FN-FORUM: Apache/GD/PHP/MySql build etc..

date posted 13th January 2004 17:13

Some kind soul sent a link some months back with the place to grab all the files for a Linux server upgrade and instructions. I tried it at the time but one of the builds failed so after a bit of mu...

Re: FN-FORUM: salsa

date posted 13th January 2004 17:11

> does anyone recommend using salsa yes, but only with mesquite Andy...

Re: FN-FORUM: it support contract rates

date posted 13th January 2004 17:07

You obviously don't search like I do ;-) http://www.itsupportnow.co.uk/ skip the Flash, prices. http://www.octaviais.co.uk/flexisupport/site/price/price.asp http://www.wavex.co.uk/support.htm Mind...

FN-FORUM: salsa

date posted 13th January 2004 17:07

does anyone recommend using salsa http://www.freecom.net/toppile.cfm Andrew...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 17:02

> > [EMAIL REMOVED] wrote: > > >I don't suggest you bother with Mandrake, I had been running it here > for the > >last few years and can sum up all my experiences in a single word > "broken". > >...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 17:02

On Tuesday 13 Jan 2004 5:24 pm, Liam Proven wrote: > A lightweight WM kinda blows the direct-replacement-for-Windows > requirement out of the water, though, doesn't it? It's KDE or GNOME or > nothing...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 16:57

On Tuesday 13 Jan 2004 4:58 pm, [EMAIL REMOVED] [EMAIL REMOVED] wrote: > And whatever you do, don't even think about compiling anything from sou= rce > unless you really know what your doing and are p...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 16:43

> > On Tuesday 13 Jan 2004 4:17 pm, Liam Proven wrote: > > > On such old kit, forget about any mainline modern distro such as Red > > Hat, > > Fedora, Mandrake or SuSE. > > I've got Mandrake runni...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 16:32

[EMAIL REMOVED] wrote: >I don't suggest you bother with Mandrake, I had been running it here for the >last few years and can sum up all my experiences in a single word "broken". > > I'd sum it up...

FN-FORUM: PHP (XSLT?) help needed

date posted 13th January 2004 16:23

Here is a problem reported by a client: > ... now the XSLT functions we > require don't work. I think certain additional PHP libraries are > required. > The function which > is failing is: > > XSLT...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 16:19

> > > SELECT > > SUM( IF(i.barcode IS NULL,1,0) ) AS count, > > s.* > > FROM > > item AS i, > > supplier AS s > > WHERE > > i.id_supplier = s.id_supplier > > GROUP BY > > s.id...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 16:17

Dom wrote: >> After that I seriously recommend gentoo, the install instructions >> are very > > I thought gentoo was a non-noob distro? No matter what distro you pick, you will and some point find yo...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 16:15

On Tuesday 13 Jan 2004 4:17 pm, Liam Proven wrote: > On such old kit, forget about any mainline modern distro such as Red Ha= t, > Fedora, Mandrake or SuSE. I've got Mandrake running on P2s, no prob...

RE: FN-FORUM: it support contract rates

date posted 13th January 2004 16:14

>I'd like to offer a flat "on-call" fee and then charge per time onsite = as >opposed to charging per machine as I think this would be a lot more = fair, >I'm just not really sure what the going rate...

RE: FN-FORUM: it support contract rates

date posted 13th January 2004 16:03

Thanks - I've tried googling it but don't really seem to be getting anywhere. Most websites don't seem to list prices. I'd like to offer a flat "on-call" fee and then charge per time onsite as oppos...

Re: FN-FORUM: Sending messages using multiple email accounts in outlook express.

date posted 13th January 2004 15:55

"It receives message on both accounts fine, but client has somehow managed to send messages as coming from the new email account, even though the old one is set as the default." Perhaps he has not cr...

RE: FN-FORUM: VB question

date posted 13th January 2004 15:53

see attached, place the code in a module. I never finished this I'm afraid so I don't know how wull it works, but it will get you off to the right start anyway. Ant. ---------8...

Re: FN-FORUM: it support contract rates

date posted 13th January 2004 15:51

If you search for companies with similar services you can find out their rates. Most charge per PC and per server per month. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Kath...

RE: FN-FORUM: Anyone know someone who's getting married this year ?

date posted 13th January 2004 15:49

And if they want the *BEST* honeymoon sorting out, I know just the person to organised bespoke packages.=20 Andy IWD2 LLP [EMAIL REMOVED] =20 -----Original Message----- From: Bob Gentle [EMAIL REMOV...

Re: FN-FORUM: Anyone know someone who's getting married this year ?

date posted 13th January 2004 15:46

Bob Gentle wrote: > > Email me off list if your interested. > Yup. -- Jonathan Chong Internet Developer : DigitalLook.com : [EMAIL REMOVED]...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 15:41

> Here's the output of explain for the sum()query: > 0.02 sec > and here it is for the joined query: > 0.24 sec Shite! I must admit I've never had a query run that slow in mysql, although having two...

FN-FORUM: Anyone know someone who's getting married this year ?

date posted 13th January 2004 15:40

An odd request. I'm doing a wedding related online service. If anyone knows someone that's getting married then I have a great freebie for them. The service is ready but I need test users. Email me...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 15:36

> Err, not wanting to start a flame-war here but I wondered who has > experiences with cheap lightweight alternatives to xp pro for two old > crappy machines. Must have decent office apps (ie openof...

FN-FORUM: Sending messages using multiple email accounts in outlook express.

date posted 13th January 2004 15:33

I setup an additional account in OLE for a clients new website. set pop3 to the correct setting for their email address and set smtp to use their isp which is mail.btconnect.com It receives message...

FN-FORUM: it support contract rates

date posted 13th January 2004 15:30

Hi, I've been asked by a small company to provide an IT support service. What they want is for me to be on-call during office hours and able to come in to their office next day if they have any probl...

RE: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 15:23

Hi Nick, > > > > Lycoris is meant to be Windows-user-friendly. I installed it > > on someone's machine recently but haven't had much feedback > > from them yet. > but can it integrate into windows d...

RE: FN-FORUM: Sql query help

date posted 13th January 2004 15:21

>Although it won't this list all suppliers will it? Bugger you're right. Should be easy enough to sort though. >Based on execution times with your data or from documentation somewhere based on exec...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 15:19

On Tuesday 13 Jan 2004 3:02 pm, [EMAIL REMOVED] [EMAIL REMOVED] wrote: > After that I seriously recommend gentoo, the install instructions are v= ery I thought gentoo was a non-noob distro? > I don...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 15:18

On Tuesday 13 Jan 2004 3:10 pm, Nick B wrote: > > Lycoris is meant to be Windows-user-friendly. I installed it > > on someone's machine recently but haven't had much feedback > > from them yet. > > b...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 14:55

> SELECT > SUM( IF(i.barcode IS NULL,1,0) ) AS count, > s.* > FROM > item AS i, > supplier AS s > WHERE > i.id_supplier = s.id_supplier > GROUP BY > s.id > Although it won't t...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 14:47

> Ah, even better, 10 times as efficient as the join and I know how to filetr > the results with that syntax. Corks! Based on execution times with your data or from documentation somewhere ? Andy...

RE: FN-FORUM: Sql query help

date posted 13th January 2004 14:31

SELECT SUM( IF(i.barcode IS NULL,1,0) ) AS count, s.* FROM item AS i, supplier AS s WHERE i.id_supplier = s.id_supplier GROUP BY s.id Ah, even better, 10 times as efficient as...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 14:29

Dom wrote: >>Basically 160 quid x 2 seems like a lot of money to upgrade to xp pro >>when the machines aren't worth much more than that (PII with 64MB and >>a few gig HDD) > > You're right, they're...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 14:21

Nick B wrote: > Any experiences much appreciated.. Get a knoppix cd and have a play to start with, no point moving if you not going to like what you find :) After that I seriously recommend gentoo,...

RE: FN-FORUM: grrrrr india!!!

date posted 13th January 2004 13:52

>At 3am a potential client from that part of the world phoned me at home >to talk about something or other! Needless to say, my brain is not in >top (any) gear at that time, so it was "Sorry think you...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 13:46

Nick B wrote: > > Err, not wanting to start a flame-war here but I wondered who has > experiences with cheap lightweight alternatives to xp pro for two old > crappy machines. Must have decent offic...

FN-FORUM: Re: OSCommerce Work Required

date posted 13th January 2004 13:40

Dear All, We need somebody who is proficient in editing the look and feel of OSCommerce. We will supply all design stylesetters, elements/graphic files and logo's etc etc etc. What we need someone...

Re: FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 13:20

On Tuesday 13 Jan 2004 1:30 pm, Nick B wrote: > Basically 160 quid x 2 seems like a lot of money to upgrade to xp pro > when the machines aren't worth much more than that (PII with 64MB and > a few gi...

Re: FN-FORUM: Indemnity Insurance

date posted 13th January 2004 13:16

Hi all Anyone got any pointers or experience of arranging this for the design/print side. Any recommendations of reasonably priced cover? Thanks John Peace big PURPLE box website: http://www.big...

FN-FORUM: 'best' linux distro for windows networks

date posted 13th January 2004 12:49

Err, not wanting to start a flame-war here but I wondered who has experiences with cheap lightweight alternatives to xp pro for two old crappy machines. Must have decent office apps (ie openoffice.....

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 12:25

> I actually want my connection running - running a dev server from home. > > It's not so much the IE I am worried about - it's the chat programs. He > only uses the IE to check his emails but he's a...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 12:23

> Hello need some help with this query > > I want to list the number of items against a Supplier_ID that have null > values in the barcode field > at the same time as listing the details of that suppl...

RE: FN-FORUM: Internet usage monitor

date posted 13th January 2004 12:23

what about deleting the chat software and making him log in as guest so that he can't install software -----Original Message----- From: [EMAIL REMOVED] [EMAIL REMOVED] Behalf Of Jonathan Chong Sent:...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 12:20

I actually want my connection running - running a dev server from home. It's not so much the IE I am worried about - it's the chat programs. He only uses the IE to check his emails but he's a bit "a...

RE: FN-FORUM: Internet usage monitor

date posted 13th January 2004 12:15

I researched various "spy" utilities for a client a while back, if that would help. David Nye http://dnye.co.uk Business Systems, Database & Internet Applications Design & Development. Microsoft Acce...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 12:11

How about setting your homepage to a script that emails you and then redirects to whatever your current homepage is - that way it shouldn't be too obvious. Andy...

RE: FN-FORUM: Internet usage monitor

date posted 13th January 2004 12:09

or if you don't want him to have internet access, just remove your adsl modem/cable mode/phone cable/his hands or any other necessary part of the equation -----Original Message----- From: [EMAIL REMO...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 12:09

> >Change the INNER JOIN to LEFT OUTER JOIN then ? > > That looks to be the one! > > Have a pint on me. ta ;) Sorry I wasn't following the thread properly - I thought from the initial message that y...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 12:05

stick a login password on the PC? Have done that here to prevent rampant teenagers looking at er.. sites of dubious content, and works just fine. stick a password on the screensaver as well, with a v...

RE: FN-FORUM: Internet usage monitor

date posted 13th January 2004 12:04

I agree with Kathy on this. If he needs access to Word then set him up with an account that only allows access to that program and not to IE or Messenger etc. Cheers Ali -----Original Message-----...

RE: FN-FORUM: Internet usage monitor

date posted 13th January 2004 12:03

do you have a static IP address? you can get one from http://www.dyndns.org/services/dyndns/ then setup a script to ping your now static ip address through the day. install a www.realvnc.com server...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:57

If you are using a decent OS, change the password on your account (and administrator) and leave the PC locked or not logged in. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++...

Re: FN-FORUM: Default SMTP server on XP box won't send to hotmail a/cs - why not?

date posted 13th January 2004 11:52

As well as the rdns thing, D542LL0J is not a valid host name (it isn't an fqdn) so some SMTP servers refuse connections from servers without valid names. As mentioned, that is the name in the HELO or...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:51

Carla Boulton wrote: > on 13/1/04 12:23 pm, Jonathan Chong at [EMAIL REMOVED] wrote: > > >>Carla Boulton wrote: >> > > Set your homepage on IE to come up with a message that says > All internet us...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:50

Bob Gentle wrote: > You could also get pc anywhere. That would do the trick for sure. > > Bob. > He has a MSN and Yahoo! Msg account, so he'll be signing into those and blocking me. ;) That's a...

RE: FN-FORUM: Sql query help

date posted 13th January 2004 11:49

>Change the INNER JOIN to LEFT OUTER JOIN then ? That looks to be the one! Have a pint on me. Do you know any good tutorials on the JOIN syntax? I've never been able to get my head around it. Than...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:48

On 13 Jan 2004 12:06:58 -0000, Jonathan Chong [EMAIL REMOVED] wrote: > > Does anyone know of a program I can install on my home PC and it sends > me an email or message whenever there is access to...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:48

on 13/1/04 12:23 pm, Jonathan Chong at [EMAIL REMOVED] wrote: > > Carla Boulton wrote: > >> >> What are you trying to do? See when someone uses your PC to access the net >> when you're not there?...

RE: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:47

There are a few key logger programs about that can be setup to log this and report via e-mail. The only 2 I've ever dealt with are GHOST KELOGGER FULL and EBLASTER. The latter is definitely the far su...

RE: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:44

Install msn or yahoo messenger. Set it to sign in whenever your online and then put that user in your contacts at work. If you use msn you can even set it up so that you can remotly take your home m...

Re: FN-FORUM: Form filling

date posted 13th January 2004 11:44

Tony Crockford wrote: > > On 13 Jan 2004 11:39:07 -0000, Paul J White [EMAIL REMOVED] wrote: > >> >> I seem to remember someone (Tony?) putting a link to a bit of software >> for typing into forms...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:42

Carla Boulton wrote: > > What are you trying to do? See when someone uses your PC to access the net > when you're not there? And see what they do? > My young cousin is supposed to be studying for...

RE: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:40

How about prepairing an email to send from your email app and set up the app to send and receive for whenever there is an internet connection or dial up connection. Bit shoddy though. > -----Origin...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:40

> > You could try installing closed circuit tv near the computer. > > > > Ah, but then I'd need a TV at work - or use a webcam. Damn I knew there'd be a flaw in my logic somewhere. VCR's are quite ch...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:37

on 13/1/04 12:14 pm, Jonathan Chong at [EMAIL REMOVED] wrote: > > Andy Stafford wrote: > >> The internet as a whole or just from your PC ? > > Whenever there is access from my PC. > >> You could...

Re: FN-FORUM: Default SMTP server on XP box won't send to hotmail a/cs - why not?

date posted 13th January 2004 11:34

> Assuming that D542LL0J is your server as it isn't hotmail. Yes. > Are you using DNS to send or a smarthost? Do you have any entries for > hotmail in hosts? Pass. > How many received from: lines...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:33

Andy Stafford wrote: > The internet as a whole or just from your PC ? Whenever there is access from my PC. > You could try installing closed circuit tv near the computer. > Ah, but then I'd need...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 11:33

> The query is valid but again excludes suppliers who have no null barcode > entries. Change the INNER JOIN to LEFT OUTER JOIN then ? > Thanks Anyway. I'm sure they will be better off on version 4 i...

Re: FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:30

> Does anyone know of a program I can install on my home PC and it sends > me an email or message whenever there is access to the Internet? The internet as a whole or just from your PC ? > Or a sc...

RE: FN-FORUM: Sql query help

date posted 13th January 2004 11:28

>Apologies if i've gone mad, but...(not sure about the IS NULL/='NULL' syntax) The query is valid but again excludes suppliers who have no null barcode entries. Thanks Anyway. I'm sure they will be...

RE: FN-FORUM: Form filling

date posted 13th January 2004 11:27

what was the original question to this thread? Andrew >-----Original Message----- >From: [EMAIL REMOVED] [EMAIL REMOVED] Behalf Of Tony >Crockford >Sent: 13 January 2004 12:04 >To: FN-FORUM / [EMAIL...

FN-FORUM: Internet usage monitor

date posted 13th January 2004 11:25

Does anyone know of a program I can install on my home PC and it sends me an email or message whenever there is access to the Internet? Or a script, but I prefer it to be a program that runs in the...

Re: FN-FORUM: Default SMTP server on XP box won't send to hotmail a/cs - why not?

date posted 13th January 2004 11:23

Assuming that D542LL0J is your server as it isn't hotmail. So it looks as though it's looping. Are you using DNS to send or a smarthost? Do you have any entries for hotmail in hosts? How many receiv...

Re: FN-FORUM: Form filling

date posted 13th January 2004 11:21

On 13 Jan 2004 11:39:07 -0000, Paul J White [EMAIL REMOVED] wrote: > > I seem to remember someone (Tony?) putting a link to a bit of software > for typing into forms - I presume you scan the form an...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 11:16

> > Ah well in that case you have a problem on MySql 3.23, since it doesn't do > UNION either. > > No probs, I'll upgrade. Apologies if i've gone mad, but...(not sure about the IS NULL/='NULL' syntax...

RE: FN-FORUM: VB question

date posted 13th January 2004 11:14

There is a property of the form or control that allows the form to process all events etc first and then pass it to the control, can't remember exactly what it is BUT as you've solved the problem I'...

RE: FN-FORUM: Sql query help

date posted 13th January 2004 11:11

> Ah well in that case you have a problem on MySql 3.23, since it doesn't do UNION either. No probs, I'll upgrade. Thanks all Ron...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 11:04

> Close, but I don't want to exclude suppliers that have no match for "barcode > is null" Ah well in that case you have a problem on MySql 3.23, since it doesn't do UNION either....

RE: FN-FORUM: Sql query help

date posted 13th January 2004 10:57

Nick: Close, but I don't want to exclude suppliers that have no match for "barcode is null" if that makes sense. I'll upgrade the server to MySQL 4 so I can use a scalar query if necessary, unless...

FN-FORUM: Form filling

date posted 13th January 2004 10:57

I seem to remember someone (Tony?) putting a link to a bit of software for typing into forms - I presume you scan the form and then it prints in the appropriate places, but I wasn't paying much atte...

RE: FN-FORUM: e-payment alternatives

date posted 13th January 2004 10:48

Yeah I know it does look like a brilliant service to use and have seen a few American sites using it, and wouldn't mind giving it a go myself! But would rather know if other people had any problems et...

RE: FN-FORUM: Sql query help

date posted 13th January 2004 10:43

Oh sorry, they're running MySQL v 3.23, that might have something to do with it! Thanks anyway Ron -----Original Message----- From: [EMAIL REMOVED] [EMAIL REMOVED] Behalf Of ron Sent: 13 January 200...

RE: FN-FORUM: Sql query help

date posted 13th January 2004 10:41

What's the database ron? Dominic...

Re: FN-FORUM: Sql query help

date posted 13th January 2004 10:41

SELECT supplier.x, supplier.y, supplier.z, count(product_id) FROM supplier, products WHERE products.supplier_id = supplier.supplier_id and products.barcode is null GROUP BY supplier.x, supplier.y, su...

FN-FORUM: Sql query help

date posted 13th January 2004 10:35

Hello need some help with this query I want to list the number of items against a Supplier_ID that have null values in the barcode field at the same time as listing the details of that supplier. so:...

Re: FN-FORUM: Default SMTP server on XP box won't send to hotmail a/cs - why not?

date posted 13th January 2004 10:34

> And the error you get is? Reporting-MTA: dns;D542LL0J Received-From-MTA: dns;D542LL0J Arrival-Date: Thu, 1 Jan 2004 22:29:30 +0000 Final-Recipient: [EMAIL REMOVED] Action: failed Status: 4.4.7...

Re: FN-FORUM: VB question

date posted 13th January 2004 10:32

tried that at first, seems that requires the form itself to already be in focus rather than an element on it, plus it would trigger when other forms were active in the app - managed it by using the...

Re: FN-FORUM: Default SMTP server on XP box won't send to hotmail a/cs - why not?

date posted 13th January 2004 10:29

And the error you get is? Could be the old reverse lookup problem mentioned the other day. What happens if you relay (smarthost) through ISP's SMTP server? +++++++++++++++++++++++++++++++++++++++++...

Re: FN-FORUM: Default SMTP server on XP box won't send to hotmail a/cs - why not?

date posted 13th January 2004 10:21

On 13 Jan 2004 10:43:09 -0000, Nick de Voil [EMAIL REMOVED] wrote: > > Subject line says it all > A. AOL have taken to extreme measures to prevent (unsuccessfully) spam being sent to AOL accounts....

FN-FORUM: quiss

date posted 13th January 2004 10:19

Has anyone used these people before ? Any comments if so ? http://www.quiss.co.uk/upg/ Andy...

Re: FN-FORUM: e-payment alternatives

date posted 13th January 2004 10:15

Hi Rus How long do they hold back the transaction fees before transferring them to your own account? Best Regards D Thomas http://www.thomas-design.co.uk [EMAIL REMOVED] t - 0870 162 0723 -----...

Re: FN-FORUM: PHP carts and register_global = off : Know one that works?

date posted 13th January 2004 10:11

> > I'm still searching for a nice php based cart but everyone that I have > found > > so far doesn't want to work due to "register_globals = off " and my host > > wont change it (which if fair enough...

Re: FN-FORUM: e-payment alternatives

date posted 13th January 2004 10:07

That looks pretty damn good to me, low interest fee and instant payment to your account? this sounds bloody good to me but anyone ever heard anything about them? Best Regards D Thomas http://www.th...

FN-FORUM: Default SMTP server on XP box won't send to hotmail a/cs - why not?

date posted 13th January 2004 10:01

Subject line says it all TIA Nick...

Re: FN-FORUM: Dialup ISP Reccomendations

date posted 13th January 2004 09:49

on 12/1/04 11:35 pm, Cameron Leask at [EMAIL REMOVED] wrote: > > I've been pleased with the service I've had from demon on both 56k > dialup and 64k ISDN. If you combine their packages with BT Surf...

Re: FN-FORUM: PHP, Popups and parameter passing...

date posted 13th January 2004 09:44

> Doh! > > I was passing a paramater that was the same name as one in a global file - > the global file kept resetting it when the pop-up opened! - that's why it > looked like the same page each time....

RE: FN-FORUM: SEO - Where should I submit a site?

date posted 13th January 2004 08:24

DMOZ Relevant 'on subject' directories (Google for them) Get links from other sites Thats it, the rest is a waste of time and 'Pas nessecaire' Spiders are good nowadays A bientot Mike -----Origi...

RE: FN-FORUM: Quick PHP question

date posted 13th January 2004 08:09

Hi Tony, As far I think every insert or update query never returns any thing from the database at the time of its execution....Its not selecting any thing from the database...but generating/updating...

RE: FN-FORUM: VB question

date posted 13th January 2004 00:12

Dave, Use the VB6 Private Sub Form_LostFocus You will need to check that the focus hasn't gone to another form in the app. Mark Anderson Anderson Consultants 01202 775483 07802 404838 mob Web Develo...



Messages by Day
January 31st 2004
January 30th 2004
January 29th 2004
January 28th 2004
January 27th 2004
January 26th 2004
January 25th 2004
January 24th 2004
January 23rd 2004
January 22nd 2004
January 21st 2004
January 20th 2004
January 19th 2004
January 18th 2004
January 17th 2004
January 16th 2004
January 15th 2004
January 14th 2004
January 13th 2004
January 12th 2004
January 11th 2004
January 10th 2004
January 9th 2004
January 8th 2004
January 7th 2004
January 6th 2004
January 5th 2004
January 4th 2004
January 3rd 2004
January 2nd 2004
January 1st 2004


Messages by Month
December 2004
November 2004
October 2004
September 2004
August 2004
July 2004
June 2004
May 2004
April 2004
March 2004
February 2004
January 2004


Messages by Year
2008
2007
2006
2005
2004
2003
2002
2001
2000