I have had problems with this kind of statement: date = DATE
Try date = 'DATE' or even date =curdate(); Note you can subtract date = curdate()-1; I have encountered no problems with upper/lower case in Linux and Mysql. ~Kelly W. Black -----Original Message----- From: John Ragan [mailto:jragan@;arkansas.net] Sent: Tuesday, November 05, 2002 11:22 AM 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 --------------------------------------------------------------------- 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