I did post the entire code. I am using NaviCat and I literally copied and pasted.
-----Original Message----- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Monday, December 10, 2012 10:13 AM To: sql Subject: Re: Update data in a field from concatenated data No, post your entire code in other words is it wrapped like this? <cfquery ......> UPDATE Wawa_DB Set CityStateZip = '#City#' & ' ' & '#State#' & ' ' & '#PostalCode#' </cfquery> -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3485 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
