Re: MSSQL INSERT query problem
| From: | John Holmes | Date: | Fri, 06 Aug 2004 02:11:54 +0000 |
| Subject: | Re: MSSQL INSERT query problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35608@lists.php.net to get a copy of this message | ||
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 errorNot 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