What datatype is your Comments field? What database are you using? Also, I noticed that your code has a little indiscrepancy. The error message you supply is saying that the cfsqltype is longvarchar and your code paste says it is type varchar. Not sure if that is a typo, or if it would technically matter in this case, but thought I'd point it out.
> -----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> > > Here's my code from my form page: > <cftextarea name="Comments" width="500" cols="100"></cftextarea> > > > > and here's the *new*query statement.... > <cfquery name="AddEval" datasource="studentsurvey"> > INSERT INTO Results > (StudentID,INDEXNO,FACULTY_ID,DateModified,TimeModified,Gender,Cla > ssification,GPA,Reason4Course,NumOfStudents,Question1,Question2,Question3,Q > uestion4,Question5,Question6,Question7,Question8,Question9,Question10,Questi o > n11,Question12,Question13,Question14,Question15,Question16,Question17,Questi > on18,Question19,Question20,Question21,Question22,Comments > VALUES > ( > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.StudentID#">, > <cfqueryparam cfsqltype="cf_sql_longvarchar" value="#form.INDEXNO#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.FACULTY_ID#">, > <cfqueryparam cfsqltype="cf_sql_date" value="#form.DateModified#">, > <cfqueryparam cfsqltype="cf_sql_time" value="#form.TimeModified#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Gender#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Classification#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.GPA#">, > <cfqueryparam cfsqltype="cf_sql_varchar" > value="#form.Reason4Course#">, > <cfqueryparam cfsqltype="cf_sql_varchar" > value="#form.NumOfStudents#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question1#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question2#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question3#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question4#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question5#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question6#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question7#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question8#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question9#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question10#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question11#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question12#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question13#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question14#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question15#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question16#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question17#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question18#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question19#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question20#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question21#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Question22#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.Comments#"> > ) > </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:262239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4