[PHP-WIN] mssql insert weird.

[Delbono]

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
[EMAIL PROTECTED]
Key5 di Delbono Nicola
V. G.M. Rossi, 12
25038 Rovato (Bs)
Tel 39 030 7242266
Fax 39 030 7242266


-- 
PHP Windows 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]