Two things. First of all, <cfquery> requires a NAME= attribute.
Secondly, you should get into the habit of using <cfqueryparam>. Quick
reference can be found here:
http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/comm
on/html/wwhelp.htm?context=ColdFusion_Documentation&file=part_cfm.htm
This is for CF7. A little browsing will get you the livedocs for CF6.1,
if necessary.
In this case, you can use the NULL= attribute of <cfqueryparam> instead
of all the <cfif> statements in your query body. This will make your
code more secure, easier to read, and better performing. It may also
help uncover your syntax error.
In this case, you might have: (sorry if Outlook hoses up the
formatting...)
<cfparam name="URL.ID" default="1">
<cfif IsDefined("FORM.MM_UpdateRecord") AND FORM.MM_UpdateRecord EQ
"form1">
<cfquery datasource="humetravel_hume_travel_com">
UPDATE easyres_login SET
FIRST_NAME=<cfqueryparam value="#FORM.FIRST_NAME#"
null="#FORM.FIRST_NAME EQ ''#">,
AGENCY=<cfqueryparam value="#FORM.AGENCY#" null="#FORM.AGENCY EQ
''#">,
POSTAL_CODE=<cfqueryparam value="#FORM.POSTAL_CODE#"
null="#FORM.POSTAL_CODE EQ ''#">,
CITY_PROVINCE=<cfqueryparam value="#FORM.CITY_PROVINCE#"
null="#FORM.CITY_PROVINCE EQ ''#">,
COUNTRY=<cfqueryparam value="#FORM.COUNTRY#" null="#FORM.COUNTRY
EQ ''#">,
AREA_CODE=<cfqueryparam value="#FORM.AREA_CODE#"
null="#FORM.AREA_CODE EQ ''#">,
PHONE_NUMBER=<cfqueryparam value="#FORM.PHONE_NUMBER#"
null="#FORM.PHONE_NUMBER EQ ''#">,
FAX_NUMBER=<cfqueryparam value="#FORM.FAX_NUMBER#"
null="#FORM.FAX_NUMBER EQ ''#">,
IATA=<cfqueryparam value="#FORM.IATA#" null="#FORM.IATA EQ
''#">,
CLIA=<cfqueryparam value="#FORM.CLIA#" null="#FORM.CLIA EQ
''#">,
PROVINCIAL_REG=<cfqueryparam value="#FORM.PROVINCIAL_REG#"
null="#FORM.PROVINCIAL_REG EQ ''#">,
NUMBER_OF_EMPLOYEES=<cfqueryparam
value="#FORM.NUMBER_OF_EMPLOYEES#" null="#FORM.NUMBER_OF_EMPLOYEES EQ
''#">,
CRS_CONTRACT=<cfqueryparam value="#FORM.CRS_CONTRACT#"
null="#FORM.CRS_CONTRACT EQ ''#">,
CURRENT_CRS=<cfqueryparam value="#FORM.CURRENT_CRS#"
null="#FORM.CURRENT_CRS EQ ''#">,
DATE_RENEW_CRS=<cfqueryparam value="#FORM.DATE_RENEW_CRS#"
null="#FORM.DATE_RENEW_CRS EQ ''#">,
DATE_OF_CRS_RENEW=<cfqueryparam value="#FORM.DATE_OF_CRS_RENEW#"
null="#FORM.DATE_OF_CRS_RENEW EQ ''#">,
USERNAME=<cfqueryparam value="#FORM.USERNAME#"
null="#FORM.USERNAME EQ ''#">,
PASSWORD=<cfqueryparam value="#FORM.PASSWORD#"
null="#FORM.PASSWORD EQ ''#">,
EMAIL=<cfqueryparam value="#FORM.EMAIL#" null="#FORM.EMAIL EQ
''#">,
COMMENTS=<cfqueryparam value="#FORM.COMMENTS#"
null="#FORM.COMMENTS EQ ''#">,
VERIFY=<cfqueryparam value="#FORM.VERIFY#" null="#FORM.VERIFY EQ
''#">
WHERE agencyID=#FORM.agencyID#
</cfquery>
<cflocation url="easyres_list.cfm">
</cfif>
<cfquery name="easymodify" datasource="humetravel_hume_travel_com">
SELECT *
FROM easyres_login
WHERE agencyID = #URL.ID#
</cfquery>
Hope this helps.
Matt Osbun
Web Developer
Health Systems, International
-----Original Message-----
From: Victoria Mitchell [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 14, 2005 2:31 PM
To: CF-Newbie
Subject: Syntax error in UPDATE statement.
I hope someone can help me as I am very confused! The following code
works fine on my testing server.
when I upload the page I receive a syntax error (also below).
I'd appreciate any advice as to where I am going astray.
thanks - Victoria.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1300
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
