yes, i remember that syntax now... still getting an error of Too Few parameters. looking into it.
-----Original Message----- From: Steven Monaghan [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 1:21 PM To: CF-Talk Subject: RE: Still need a little help Use this for a Microsoft database... <cfquery name="insert" datasource="dllr930"> update tbl_users set fullname = firstname & " " & lastname where firstname = '#Trim(form.firstname)#' and lastname = '#Trim(form.lastname)#' </cfquery> ------------------------------------- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com ------------------------------------- -----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 1:24 PM To: CF-Talk Subject: Still need a little help As stated before, i was thinking insert when i should have been thinking update. still have not got it working just right. want to merge two populated fields into a third field. in this case take FIRSTNAME and LASTNAME which are separate fields and merge them into a new column FULLNAME. <cfquery name="insert" datasource="dllr930"> update tbl_users set fullname = '#firstname# #lastname#' where firstname = '#Trim(form.firstname)#' and lastname = '#Trim(form.lastname)#' </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
