RE: [PHP-DB] odbc_exec error
| From: | Bastien Koert | Date: | Thu, 01 Jun 2006 19:22:05 +0000 |
| Subject: | RE: [PHP-DB] odbc_exec error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41969@lists.php.net to get a copy of this message | ||
is $conn defined?
Bastien
From: "Scott Wettstein" <stu@sandstu.com> To: php-db@lists.php.net Subject: [PHP-DB] odbc_exec error Date: Thu, 1 Jun 2006 14:19:50 -0500 I'm pretty new to PHP so I need help. I'm getting this error: Error in updating SQL PHP Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2., SQL state 07001 in SQLExecDirect in c:\Inetpub\wwwroot\shout.php on line 77 Lines 76 and 77: $sql="UPDATE shout SET UserName=$laName,Message=$laMessage WHERE Dat=$laDate"; $updating=odbc_exec($conn,$sql); where $laName, $laMessage, and $laDate are from a POST. I've checked my spelling a million times and changed the names of variables. Why is it still complaining? Please help! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php