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,Classification,GPA,Reason4Course,NumOfStudents,Question1,Question2,Question3,Question4,Question5,Question6,Question7,Question8,Question9,Question10,Question11,Question12,Question13,Question14,Question15,Question16,Question17,Question18,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:262235
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
