Syntax error in UPDATE statement.

Victoria Mitchell Thu, 14 Jul 2005 12:33:21 -0700

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.
 
 
<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=
  <cfif IsDefined("FORM.FIRST_NAME") AND #FORM.FIRST_NAME# NEQ "">
    '#FORM.FIRST_NAME#'
      <cfelse>
      NULL
  </cfif>
  , LAST_NAME=
  <cfif IsDefined("FORM.LAST_NAME") AND #FORM.LAST_NAME# NEQ "">
    '#FORM.LAST_NAME#'
      <cfelse>
      NULL
  </cfif>
  , AGENCY=
  <cfif IsDefined("FORM.AGENCY") AND #FORM.AGENCY# NEQ "">
    '#FORM.AGENCY#'
      <cfelse>
      NULL
  </cfif>
  , ADDRESS=
  <cfif IsDefined("FORM.ADDRESS") AND #FORM.ADDRESS# NEQ "">
    '#FORM.ADDRESS#'
      <cfelse>
      NULL
  </cfif>
  , POSTAL_CODE=
  <cfif IsDefined("FORM.POSTAL_CODE") AND #FORM.POSTAL_CODE# NEQ "">
    '#FORM.POSTAL_CODE#'
      <cfelse>
      NULL
  </cfif>
  , CITY_PROVINCE=
  <cfif IsDefined("FORM.CITY_PROVINCE") AND #FORM.CITY_PROVINCE# NEQ "">
    '#FORM.CITY_PROVINCE#'
      <cfelse>
      NULL
  </cfif>
  , COUNTRY=
  <cfif IsDefined("FORM.COUNTRY") AND #FORM.COUNTRY# NEQ "">
    '#FORM.COUNTRY#'
      <cfelse>
      NULL
  </cfif>
  , AREA_CODE=
  <cfif IsDefined("FORM.AREA_CODE") AND #FORM.AREA_CODE# NEQ "">
    '#FORM.AREA_CODE#'
      <cfelse>
      NULL
  </cfif>
  , PHONE_NUMBER=
  <cfif IsDefined("FORM.PHONE_NUMBER") AND #FORM.PHONE_NUMBER# NEQ "">
    '#FORM.PHONE_NUMBER#'
      <cfelse>
      NULL
  </cfif>
   , FAX_NUMBER=
  <cfif IsDefined("FORM.FAX_NUMBER") AND #FORM.FAX_NUMBER# NEQ "">
    '#FORM.FAX_NUMBER#'
      <cfelse>
      NULL
  </cfif>
  , IATA=
  <cfif IsDefined("FORM.IATA") AND #FORM.IATA# NEQ "">
    '#FORM.IATA#'
      <cfelse>
      NULL
  </cfif>
  , CLIA=
  <cfif IsDefined("FORM.CLIA") AND #FORM.CLIA# NEQ "">
    '#FORM.CLIA#'
      <cfelse>
      NULL
  </cfif>
  , PROVINCIAL_REG=
  <cfif IsDefined("FORM.PROVINCIAL_REG") AND #FORM.PROVINCIAL_REG# NEQ
"">
    '#FORM.PROVINCIAL_REG#'
      <cfelse>
      NULL
  </cfif>
  , NUMBER_OF_EMPLOYEES=
  <cfif IsDefined("FORM.NUMBER_OF_EMPLOYEES") AND
#FORM.NUMBER_OF_EMPLOYEES# NEQ "">
    '#FORM.NUMBER_OF_EMPLOYEES#'
      <cfelse>
      NULL
  </cfif>
  , CRS_CONTRACT=
  <cfif IsDefined("FORM.CRS_CONTRACT") AND #FORM.CRS_CONTRACT# NEQ "">
    '#FORM.CRS_CONTRACT#'
      <cfelse>
      NULL
  </cfif>
  , CURRENT_CRS=
  <cfif IsDefined("FORM.CURRENT_CRS") AND #FORM.CURRENT_CRS# NEQ "">
    '#FORM.CURRENT_CRS#'
      <cfelse>
      NULL
  </cfif>
  , DATE_RENEW_CRS=
  <cfif IsDefined("FORM.DATE_RENEW_CRS") AND #FORM.DATE_RENEW_CRS# NEQ
"">
    '#FORM.DATE_RENEW_CRS#'
      <cfelse>
      NULL
  </cfif>
  , DATE_OF_CRS_RENEW=
  <cfif IsDefined("FORM.DATE_OF_CRS_RENEW") AND #FORM.DATE_OF_CRS_RENEW#
NEQ "">
    '#FORM.DATE_OF_CRS_RENEW#'
      <cfelse>
      NULL
  </cfif>
  , USERNAME=
  <cfif IsDefined("FORM.USERNAME") AND #FORM.USERNAME# NEQ "">
    '#FORM.USERNAME#'
      <cfelse>
      NULL
  </cfif>
  , PASSWORD=
  <cfif IsDefined("FORM.PASSWORD") AND #FORM.PASSWORD# NEQ "">
    '#FORM.PASSWORD#'
      <cfelse>
      NULL
  </cfif>
  , EMAIL=
  <cfif IsDefined("FORM.EMAIL") AND #FORM.EMAIL# NEQ "">
    '#FORM.EMAIL#'
      <cfelse>
      NULL
  </cfif>
  , COMMENTS=
  <cfif IsDefined("FORM.COMMENTS") AND #FORM.COMMENTS# NEQ "">
    '#FORM.COMMENTS#'
      <cfelse>
      NULL
  </cfif>
  , VERIFY=
  <cfif IsDefined("FORM.VERIFY") AND #FORM.VERIFY# NEQ "">
    '#FORM.VERIFY#'
      <cfelse>
      NULL
  </cfif> 
  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>
 
 
 
Syntax error in UPDATE statement.       
        
The error occurred in
E:\Inetpub\wwwroot\hume-travel.com\httpdocs\humeonline\editor\easymod.cf
m: line 144
        
142 :   </cfif>
143 :   
144 :   WHERE agencyID=#FORM.agencyID#
145 :   </cfquery>
146 :   <cflocation url="easyres_list.cfm">
________________________________

SQL         UPDATE easyres_login SET FIRST_NAME= 'Grant' , LAST_NAME=
'Hodgson' , AGENCY= 'Hume Travel' , ADDRESS= '1281 West Georgia Street'
, POSTAL_CODE= 'V6E 3J7' , CITY_PROVINCE= 'Vancouver, BC' , COUNTRY=
'Canada' , AREA_CODE= '604' , PHONE_NUMBER= '6827581' , FAX_NUMBER= NULL
, IATA= '61674955' , CLIA= NULL , PROVINCIAL_REG= '1204-0' ,
NUMBER_OF_EMPLOYEES= '6-10' , CRS_CONTRACT= 'yes' , CURRENT_CRS=
'Amadeus' , DATE_RENEW_CRS= 'known' , DATE_OF_CRS_RENEW= NULL ,
USERNAME= 'demo' , PASSWORD= 'pass' , EMAIL= '[EMAIL PROTECTED]' ,
COMMENTS= NULL , VERIFY= NULL WHERE agencyID=334        
DATASOURCE         humetravel_hume_travel_com   
VENDORERRORCODE    3092 
SQLSTATE           &nbsp;       


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1299
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

Syntax error in UPDATE statement.

Reply via email to