On the error page, sometimes the debug output provides you with the SQL
statement that it attempted to execute. You could copy that and paste it
directly into a query editor for your database (if you have one).
On first blush, perhaps you need a different cfsqltype since you're
inserting into a memo field. It's been a looong time since I've used
Access.
<cfqueryparam cfsqltype="cf_sql_clob"
value="#form.Comments#">
-----Original Message-----
From: Chelsie Lawson [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 30, 2006 10:36 AM
To: CF-Talk
Subject: Re: Firefox Compatibility
Ok...I've inserted the *all in favor of cfquery* code into my test app.
haha But, I'm getting the error on line 49, which is my comments
textbox.
Here's the error:
Error Executing Database Query.
Syntax error in INSERT INTO statement.
The error occurred in
C:\CFusionMX7\wwwroot\CourseEvalsUserAuth\action.cfm: line 49
47 : <cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.Question21#">,
48 : <cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.Question22#">,
49 : <cfqueryparam cfsqltype="cf_sql_longvarchar"
value="#form.Comments#">
50 : )
51 : </cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262244
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
