[PHP] error on update

[Peter Lavender]

Hi everyone,

I'm connecting to a SQL SVR 2000 database and get an error that I haven't
been able to resolve.

The following code generates an error Incorrect syntax near 'longer'; SQL
state 3700 in SQLExecDirect

I read some where that it might be due to a reserved word in column names,
but this isn't the case.

Here is the code:

          print("QID: $qID<br>Question to be updated to: $updateQuest");
            $updateQuest = cleanUpText($updateQuest);

            $query = "update tbl_question ";
            $query .= "set question = '$updateQuest' ";
            $query .= "where questID = '$qID';";

            print("<br><b>Query</b>= $query<br>");

            print("Cleaned up: $updateQuest<br>");
            $result = odbc_exec($conn, $updateQuest);
            unset($updateQuest);

I can copy and paste the resultant SQL and execute it fine in the query
analyser.




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]