Will,
Your date needs to be an ODBC Date.
Use CreateODBCDate() on your Date form field and CreateODBCTime() on your
Time form Field.
Regards
Stephen
----- Original Message -----
From: "Will Swain" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 21, 2002 11:29 AM
Subject: query problem
> 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 Swain
> Tecnical Director
> Hot Horse Ltd
>
> e: [EMAIL PROTECTED]
> t: 01273 675375
>
> This email is intended for the recipient only and contains confidential
> information, some or all of which may be legally privileged. If you are
not
> the intended recipient, you must not use, save, disclose, distribute,
copy,
> print or rely on this email or any information contained within it. Please
> notify the sender by return and delete it from your computer. Thank you.
>
>
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
