RE: odbc_exec error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



is $conn defined?

Bastien


From: "Scott Wettstein" <stu@xxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject:  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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux