[PHP-DEV] Bug #10484 Updated: Problem with insert in ODBC
ID: 10484
Updated by: cynic
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Bogus
Bug Type: ODBC related
PHP Version: 4.0.4pl1
Assigned To:
Comments:
Previous Comments:
---
[2001-04-25 11:32:16] [EMAIL PROTECTED]
$BD = odbc_connect ('BdTest', SQL_CUR_USE_DRIVER);
should be read like $BD = odbc_connect ('BdTest', '', '', SQL_CUR_USE_DRIVER);
but still not working..
---
[2001-04-25 10:36:32] [EMAIL PROTECTED]
you're correct insert statement is fine, needed more wake up time on that.
your odbc_connect is wrong. you need to provide 3 or 4 parameters, not just two. as
per the description found at:
http://www.php.net/manual/en/function.odbc-connect.php
---
[2001-04-25 10:17:50] [EMAIL PROTECTED]
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
---
[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??
---
The remainder of the comments for this report are too long. To view the rest of the
comments, please view the bug report online.
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10484&edit=2
--
PHP Development Mailing List
[PHP-DEV] Bug #10484 Updated: Problem with insert in ODBC
ID: 10484
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: ODBC related
PHP Version: 4.0.4pl1
Assigned To:
Comments:
you're correct insert statement is fine, needed more wake up time on that.
your odbc_connect is wrong. you need to provide 3 or 4 parameters, not just two. as
per the description found at:
http://www.php.net/manual/en/function.odbc-connect.php
Previous Comments:
---
[2001-04-25 10:17:50] [EMAIL PROTECTED]
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
---
[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??
---
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10484&edit=2
--
PHP Development Mailing List
[PHP-DEV] Bug #10484 Updated: Problem with insert in ODBC
ID: 10484
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: ODBC related
PHP Version: 4.0.4pl1
Assigned To:
Comments:
unless I'm missing something your INSERT statement is not correct.
Previous Comments:
---
[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??
---
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10484&edit=2
--
PHP Development Mailing List
