Access Insert Query

Anon

I am having an error with the following code

<?php
if(!($link =odbc_pconnect("bugtracking","llemon","llemon"))){
print("error connecting to Database");
exit();
}
$b=$glick[1];
if ($hidden=="add"){
$dated=date(mdy);
$SQL_Exec_String = "Insert Into Problems (Reportedby,Date,Subject,Details,ResolvedBy,Resolution) Values ('$b','$dated','$T3','$S1','$T4','$S2')";

$cur= odbc_exec( $link, $SQL_Exec_String );
odbc_close( $link);

}

//$results = odbc_do($link,"Insert Into Problems ([Reported by],Date,Subject,Details,[Resolved By], Resolution) Values ('$b','$dated','$T3','$S1','$T4','$S2')");
//
//}

else{
$dated=date(mdy);
$results = odbc_do($link,"UPDATE Problems SET Date='$dated', Subject='$T3', Details='$S1', Resolution ='$S2' Where (ID=$test)");
header("Location: http://glickco.com/rewrite%20support/bugs.php3");
?>

the problem is with the insert query to a access database... I have many select queries working correctly, but keep getting the following error for the query...

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in C:\InetPub\wwwroot/rewrite support/update.php3 on line 11

Anon

how do...

why not print out your assembled sql query so you can see what's wrong with it? (hmm... i think i just said this to someone else, oh yes, i did... oh well)

ie.

$DEBUG = 1;

... some code ...

$query = "Insert Into Problems
(Reportedby,Date,Subject,Details,ResolvedBy,Resolution) Values
('$b','$dated','$T3','$S1','$T4','$S2')";

if ($DEBUG) print $query;
$SQL_Exec_String($query);

This might help you, as I've found I usually go around in circles for days until I realise the blind faith i had in my query string production was a little flawed (like i forgot to initialise a variable to something etc..).

if the SQL query looks ok, try running it direct in access (by using the SQL view of a query), this might produce nicer error messages....

if this doesn't clear anything up, let us know...

dom
🙂

Anon

After looking at many things found my problem to be that my field name was date....something I had not spent much time worrying about as I got the data from someone else..... The fix was to encapsulate the field name in query as such [Date].
I could have also just changed the field name in the database, but since I had other queries working correctly already decided this was the better approach.

Thanks for the idea
Lee

Some days I feel like all I do is it the back button....