with a space.
Cheers,
barneyb
> -----Original Message-----
> From: Anne Girardeau [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 14, 2004 12:54 PM
> To: CF-Talk
> Subject: cfqueryparam
>
> While using cfqueryparam in an INSERT statement, I keep
> getting the following error: "Syntax error in INSERT INTO
> statement." I've checked and re-checked the code several time
> and tried removing and adding quotes but to no avail. I have
> listed the code below for your perusal. Any ideas as to what
> could be causing the problem? Any help would be appreciated.
>
> <cfquery name="insertCLEP" datasource="#request.siteDSN#">
> INSERT INTO CLEPNormal (CLEPID, DateID, Cap)
> VALUES=(<cfqueryparam
> value="#Session.Cart.CLEPCourse[ThisItem]#"
> cfsqltype="cf_sql_integer" maxlength="5">, <cfqueryparam
> value="#Session.Cart.CLEPDate[ThisItem]#"
> cfsqltype="cf_sql_integer" maxlength="5">, <cfqueryparam
> value="16" cfsqltype="cf_sql_integer" maxlength="5">)
> </cfquery>
>
> Thanks in advance,
> --Anne
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
