mssql insert weird.
| From: | (Delbono) | 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