Hi John, Thanks for that - I am new to MySQL - but I've found out two things here;
1. Case sensitivty is an issue with Linux/Windows 2. Beware of special keywords (I called a field in my database "date" - that was also wrong -) Since I've checked the case and prefixed my field names it works fine on both platforms Thanks for your help Regards Kevin -----Original Message----- From: John Ragan [mailto:jragan@;arkansas.net] Sent: 05 November 2002 19:22 To: Mysql (E-mail); Kevin Passey Subject: Re: MySQL - Windows vs MySQL Linux you've insured that you're not simply encountering a problem with case sensitivity ? windows is not case sensitive. > Hi all, > > I have a problem - I've built some JSP which runs ok on a windows install of > MySQL, but on a Linux install of MySQL only the update part works. > > Here is what it does - > > SELECT date, clicks FROM bsafeLinks WHERE date = DATE > > INSERT INTO bsafeLinks (date,clicks) VALUES (CURDATE(),'0') > > UPDATE bsafeLinks SET clicks = clicks + 1 WHERE date = CURDATE() > > The insert is conditioned on the select returning no data. > > As I said it works on windows but not on Linux. > > Can anybody point me at anything obvious that I have missed. > > Thanks in advance. > > Kevin Passey > -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
