ID: 10484
User Update by: [EMAIL PROTECTED]
Old-Status: Feedback
Status: Open
Bug Type: ODBC related
Description: Problem with insert in ODBC
Yes it is correct!
As there only are two fields in my table and that I try to fill them all, I can work
it this way
I could have use "INSERT INTO test (field1, field2) VALUES ('a', 'b')"
"INSERT INTO test VALUES ('a', 'b')" work the same way
Previous Comments:
---------------------------------------------------------------------------
[2001-04-25 10:08:26] [EMAIL PROTECTED]
unless I'm missing something your INSERT statement is not correct.
---------------------------------------------------------------------------
[2001-04-25 00:27:18] [EMAIL PROTECTED]
$BD = odbc_connect ('BdTest', SQL_CUR_USE_DRIVER);
$SQL = "insert into test values ('a', 'b')";
$TabUser = odbc_exec($BD, $SQL);
this don't work...nothing had been added in the table test
$BD = odbc_connect ('BdTest '', SQL_CUR_USE_DRIVER);
$SQL = "select * from Utilisateur where Nom_utilisateur = '$Nom' and Mot_de_passe =
'$Pass'";
$TabUser = odbc_exec($BD, $SQL);
This work fine!
How should i use "insert" statement in order to make it works??
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=10484
--
PHP Development 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]
