How to UPDATE and ODBC Table?

[freebsd_dude]

Hello all,

Here is my code you ask for:

$query = "UPDATE TblEvaluation SET [RecordNumber] = '$RecordNumber', [Numbercalls] = '$Numbercalls', [1] = '$yes1', [2] = '$yes2', [3] = '$yes3',
[4]= '$yes4', [5] = '$yes5', [6] = '$yes6', [7] = '$yes7', [1a] = '$yes1a', [2a] = '$yes2a', [3a] = '$yes3a',
[4a] = '$yes4a', [5a] = '$yes5a', [6a] = '$yes6a', [7a] = '$yes7a', [QuantScore] = '$QuantScore',
[QualScore] = '$QualScore', [comments] = '$comments', [evalby] = '$evalby',
[readyfortypist] = '$readyfortypist1' WHERE RecordNumber = '$RecordNumber'";

Line 38 >$result = odbc_exec($id, $query);

I get the following error:

PHP Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., in line 38

[nnichols]

PHP Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., in line 38

This is probably because you have -

WHERE RecordNumber = '$RecordNumber'";

This tries to compare an integer (RecordNumber) with a string ($RecordNumber). If you remove the 'single quotes' from $RecordNumber it should work fine.

When you quote an integer the db sees it as a string and should reject it.

Hope this helps 😉

[freebsd_dude]

Thank you for your help this worked great 🙂