mssql insert weird.

From: Date: Mon, 10 Dec 2001 15:25:36 +0000
Subject: mssql insert weird.
Groups: php.windows 
Request: Send a blank email to php-windows+get-10827@lists.php.net to get a copy of this message
Hello, I have this simple query: insert into table1 ( fname) values ('test1') I use odbc_exec() all goes fine. Insert is performed. I use mssql_query(); Query returns 1, but no insert is done!!! same, db, same table, same user. Why!!? mssql_query("select * from table1") works odbc_exec("insert into table1 ( fname) values ('test1')") works so it is not a problem of permission nor a problem of mssql_specific function problem I don't get any error, yet the QUERY IS PERFORMED because I have $res = mssql_query($q,$id); echo "Last query was: [ <B>" . $q . "</B> ]<br>"; echo "Last message was: [ <B>" . mssql_get_last_message() . "</B> ]<BR>"; if ($res) { echo "OK<br>"; } else { echo "NO!"; } "OK" is printed out! Please help this man.. Thank you, Nicola Nicola Delbono info.key5@key5.com Key5 di Delbono Nicola V. G.M. Rossi, 12 25038 Rovato (Bs) Tel 39 030 7242266 Fax 39 030 7242266

« previous php.windows (#10827) next »