Re: SELECTing to Substitute Text for Refc Codes

For posterity (ie the archives) there's a comma missing in the FROM line: FROM contact AS cn, codes AS cd1, codes AS cd2 Roddie Grant on 25/5/04 8:25 am, Greg Willits at [EMAIL PROTECTED] wrote: > Got an offline answer, so I'm all set. Gotta love SQL. > > for posterity...

Update is deleting data

Any advice will be much appreciated. Roddie Grant [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LOAD DATA INFILE..

is called 'cou_id' not 'id' (and 'cou_name' not 'country'). Roddie Grant [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How do you ORDER BY two columns as one?

tbl_child.child_datetime Roddie Grant [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: checking NULL or ''

I'm still a bit of newbie, but surely these are not the same query. The empty string is not the same thing as NULL. Roddie Grant [EMAIL PROTECTED] > I tested these 2 queries: > > select * from mytable where myfield is null; > > select * from mytable where myfield = '&

Re: Update works in Netscape, doesn't in Explorer

m, Scott Haneda at [EMAIL PROTECTED] wrote: > on 02/28/2003 1:37 AM, Roddie Grant at [EMAIL PROTECTED] wrote: > >> Working in Lasso Profession 6, OS X and My SQL 4.? >> >> I'm at the testing stage of a small survey website >> (http://www.myword.co.uk/iied/iied_i

Update works in Netscape, doesn't in Explorer

he new data. I have confirmed that the SQL is identical for both, and I am now baffled. I don't even know what to look for. This is mission-critical, so I'm open to any suggestions. Thanks Roddie Grant [EMAIL PROTECTED]