Re: [PHP-DB] MSSQL INSERT query problem

[John Holmes]

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