Hi all,
Ok, having an annoying little problem, and I'm sure that it's something
really obvious that I should know, but I guess I have just looked at it for
too long.....
This is my query:
<cfquery name="addevent" datasource="#Request.App.dsn#">
INSERT INTO tbl_events(name, borough, full_address, event_date, event_time,
description, delete_date, authorised)
VALUES ('#Form.name#', #Form.borough#, '#Form.full_address#',
#Form.event_date#, '#Form.event_time#', '#Form.description#',
#Form.delete_date#, '#Form.authorised#')
</cfquery>
The field borough is a number type and the two date fields are date types.
This is the error:
Error Code: -3502 SQL State: 37000 Detail: [Microsoft][ODBC Microsoft Access
Driver] Syntax error in INSERT INTO statement.
SQL = "INSERT INTO tbl_events(name, borough, full_address, event_date,
event_time, description, delete_date, authorised) VALUES ('fdhdfh', 1,
'sdfhsdfh', 12/08/02, '', 'asfasf', , 'yes')"
Any ideas?
Will
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
