update tbl_users
set fullname = '#firstname#'+' '+'#lastname#'
where firstname = '#Trim(form.firstname)#' and
lastname = '#Trim(form.lastname)#'
James Taavon <[EMAIL PROTECTED]> on 10/25/2001 12:24:09 PM
Please respond to [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
cc:
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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
