RE: [PHP] UPDATE Query works in odbc/Mysql, but fails in odbc/MS Access

mweb, MS points to a datetime issue: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246570 As far as a reference - I'm guessing somewhere on MS's site? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: mweb [mailto:mweb@inwind.it] > Sent: Thursday, December 06, 2001 7:30 AM > To: php-general@lists.php.net; mysql@lists.mysql.com > Subject: [PHP] UPDATE Query works in odbc/Mysql, but fails in odbc/MS > Access > > > Hello, > > I have one MS Access DB on the server, and an exact > (theoretically) copy of > it in MySQL on my machine, so I can test PHP pages on Linux and > install them > on an NT server (using odbc of course). > > I can insert and select just fine, thankl to all your help. The > problem is > that this UPDATE query: > UPDATE rec SET Aut = 1 WHERE Un = 20000927230327; > > works perfectly on PHP/ODBC/MySQL on Linux, while on PHP/ODBC/ACCESS/ > it gives this error: > > Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type > mismatch in criteria expression., SQL state 22005 in SQLExecDirect in > C:\domini\m.net\update_db.php on line 54 > No cursor > > Initially I though well, maybe I'm trying to write a string into > a number, or > something like that, but I can SELECT from that same table using the same > format, so what is the trick? Different UPDATE syntax between MySQL and > ACCESS? If so, where is an online ACCESS syntax reference? > > TIA, > mweb > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >