'#FORM.DATE_RENEW_CRS#'
try removing the quotes from around your dates and/or using the createODBCdate() function. -----Original Message----- From: Victoria Mitchell [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 3: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. <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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:1301 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
