Re: MSSQL INSERT query problem

[John Holmes <holmes072000@xxxxxxxxxxx>]

Chris wrote:
> Here is the code I use:
[snip]
> $sql =& $db->prepare("INSERT INTO ExitSurveyAnswers (session_id,
> Question_id, answer) VALUES ?,?,?");
[snip]
> When I execute it I keep recieving and error message stating:
> DB Error: syntax error

Not a MSSQL expert, but shouldn't the ?,?,? in your query have 
parenthesis around it??

 $sql =& $db->prepare("INSERT INTO ExitSurveyAnswers (session_id,
 Question_id, answer) VALUES (?,?,?)");

--

John Holmes

php|architect - The magazine for PHP professionals - http://www.phparch.com

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