I am using a developer's version of CF7.0.2 on WinXP, and I am getting a syntax error everytime I try to run a SQL update on my Profile.cfm page. I have looked over every line of this code and cannot see where the error is? Can anyone lead me in the right direction? Here is the specific error message:
**************************
***
Error Executing Database Query.
Syntax error in UPDATE statement.
The error occurred in C:\CTE\profile.cfm: line 114
Called from C:\CTE\profile.cfm: line 8
Called from C:\CTE\profile.cfm: line 1
Called from C:\CTE\profile.cfm: line 114
Called from C:\CTE\profile.cfm: line 8
Called from C:\CTE\profile.cfm: line 1
112 : </cfif>
113 : WHERE StudentID=
114 : <cfqueryparam value=#FORM.StudentID# cfsqltype="cf_sql_numeric"
>
115 : </cfquery>
116 : <cflocation url="update_thanks.cfm">
**************************
**********
Here is the code. Lines 112 thru 116 are at the bottom.
<!--- Profile Query --->
<cfquery name="rs_profile" datasource="ctesurvey_dsn"
>
SELECT *
FROM data
WHERE Username = <cfqueryparam value="#Session.Auth.Usern
ame#" cfsqltype="cf_sql_char" maxlength="50">
</cfquery>
<!--- Update Query --->
<cfset CurrentPage=GetFileFromPat
h(GetTempl
atePath())
>
<cfif IsDefined("FORM.MM_UpdateR
ecord") AND FORM.MM_UpdateRecord EQ "form1">
<cfquery datasource="ctesurvey_dsn"
>
UPDATE data
SET First=
<cfif IsDefined("FORM.First") AND #FORM.First# NEQ "">
<cfqueryparam value="#FORM.First#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Last=
<cfif IsDefined("FORM.Last") AND #FORM.Last# NEQ "">
<cfqueryparam value="#FORM.Last#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Street=
<cfif IsDefined("FORM.Street") AND #FORM.Street# NEQ "">
<cfqueryparam value="#FORM.Street#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, City=
<cfif IsDefined("FORM.City") AND #FORM.City# NEQ "">
<cfqueryparam value="#FORM.City#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, State=
<cfif IsDefined("FORM.State") AND #FORM.State# NEQ "">
<cfqueryparam value="#FORM.State#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Zip=
<cfif IsDefined("FORM.Zip") AND #FORM.Zip# NEQ "">
<cfqueryparam value="#FORM.Zip#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Gender=
<cfif IsDefined("FORM.Gender") AND #FORM.Gender# NEQ "">
<cfqueryparam value="#FORM.Gender#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Year=
<cfif IsDefined("FORM.Year") AND #FORM.Year# NEQ "">
<cfqueryparam value="#FORM.Year#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, School=
<cfif IsDefined("FORM.School") AND #FORM.School# NEQ "">
<cfqueryparam value="#FORM.School#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Program=
<cfif IsDefined("FORM.Program") AND #FORM.Program# NEQ "">
<cfqueryparam value="#FORM.Program#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Teacher=
<cfif IsDefined("FORM.Teacher") AND #FORM.Teacher# NEQ "">
<cfqueryparam value="#FORM.Teacher#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Email=
<cfif IsDefined("FORM.Email") AND #FORM.Email# NEQ "">
<cfqueryparam value="#FORM.Email#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Phone=
<cfif IsDefined("FORM.Phone") AND #FORM.Phone# NEQ "">
<cfqueryparam value="#FORM.Phone#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, CellPhone=
<cfif IsDefined("FORM.CellPhone"
) AND #FORM.CellPhone# NEQ "">
<cfqueryparam value="#FORM.CellPhone#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Preference=
<cfif IsDefined("FORM.Preference
") AND #FORM.Preference# NEQ "">
<cfqueryparam value="#FORM.Preference#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Username=
<cfif IsDefined("FORM.Username")
AND #FORM.Username# NEQ "">
<cfqueryparam value="#FORM.Username#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
, Pcode=
<cfif IsDefined("FORM.Pcode") AND #FORM.Pcode# NEQ "">
<cfqueryparam value="#FORM.Pcode#" cfsqltype="cf_sql_varchar"
maxlength="50">
<cfelse>
''
</cfif>
WHERE StudentID=
<cfqueryparam value=#FORM.StudentID# cfsqltype="cf_sql_numeric"
>
</cfquery>
<cflocation url="update_thanks.cfm">
</cfif>
**************************
********
thanks,
Ken
Start Free Trial