you're quite welcome, sir. i've been doing this for decades, and i still overlook the simple things.
i recommend that you develop a database naming convention, since it appears that your organization does not enforce one. mine helps overcome my poor memory, so i appear more capable than i really am. when i don't forget it. :) a well-thought naming convention allows a database to be moved between servers and systems with minimal hassle. > 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/ > -- 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