I'm using an access one right now (i know, i know) my datatype is a memofield.
that was just a typo. :) >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 >C:\CFusionMX7\wwwroot\CourseEvalsUserAuth\action.cfm: >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#">, >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:262242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
