You're missing a ')'.
----- Original Message -----
From: "Greenberg, Lisa" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 1:30 PM
Subject: ORACLE DATE INSERT ERROR.. Help.
> I'm trying to insert a date into an Oracle table and get the following
> error. Help!!
>
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00917: missing comma.
> SQL = "INSERT INTO emirf (FIRST_NAME, REQUEST_DATE, LAST_NAME) VALUES (
> 'Lisa',to_date('26-Apr-2001','DD-MMM-YYYY','Lisa' )"
> Data Source = "ADMS"
> Here is the CF code:
> <cfquery name="requestInsert" datasource="#Application.SMInfo#">
> INSERT INTO emirf
> (FIRST_NAME, REQUEST_DATE, LAST_NAME)
> VALUES (
>
'#form.first_name#',to_date('#DateFormat(Now(),'DD-MMM-YYYY')#','DD-MMM-YYYY
> ','#form.last_name#') </cfquery>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
