Hello everybody

This time I can answer to myself. I made it work changing the SQL statement 

UPDATE rec SET Aut = 1 WHERE Un = 20000927230327; (works in MySQL)

UPDATE rec SET Aut = 1 WHERE Un in ('20000927230327'); (works in Access)

Now I'd like to know if the difference is due to the type of the "Un" column
being different between the databases,  MySQL and Access having actually 
different syntax, or any combination of the above.



On Thursday 06 December 2001 13:30, mweb wrote:
> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to