Does anyone know???

miles_rich

Does anyone know why i get this error, when i try and insert the date into a access db??


Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '22 August 2002'., SQL state 37000 in SQLExecDirect in D:\wwwroot\Running Web Sites\Test.php on line 234

if you do please reply.

Tony.

Weedpacket

Um, because you're missing an operator in your query expression?

Really, you haven't given us that much to go on. Maybe you're missing some quotes around the date in the query.

the_Igel

you'd better post a few lines of code here. It's difficult to answer not seeing the code 🙂

miles_rich


$tester = Date("j F Y"); //***SETS THE DATE

$query ="insert into quotes values($counter, $corid, $cust2[1],'$tester', '$tday $tmonth $tyear', '$pick2[0]', '$phour $pmin $pampm', '$pass2[0]', '$from2[0]', '$dest2[0]', '$rett2[0]', '$retp2[0]', '$price')";

any ideas

Weedpacket

Add the line

echo $query;

And check that that's correct.

The bit you've given looks fine, but then, I have no idea what all those variables are supposed to contain, or whether they're all there and in the right order.