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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
