I'm getting an error when i try and information to my access databse from my form. I'm knew to Coldfusion and SQL but i have searched high and low for the cause of my syntax error but no matter what i try i cant get it to work, so any help would be greatly appreciated.
Basically the last four were checkboxes and i just want it to insert yes or no into the related record.
Here are the datatypes in access:
Price = Currency
Address = Memo
Status_ID = Number
Suburb_ID = Number
Bathrooms = Number
Bedrooms = Number
Comments = Memo
Pool = Text
Fireplace = Text
Garage = Text
Laundry = text
And here is the error
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
You left a an extra comma in the insert statement.
Also, the query is too vunerable to hacking. Whenever using inline SQL you MUST use CFQUERYPARAM. An example on one of yours would be:
<CFQUERYPARAM CFSQLTYPE="CF_SQL_INTEGER" MAXLENGTH="8" VALUE="#form.Price#">,