no errors, but still did not resolve...
did not successfully concatenate, left FULLNAME field empty.
update (Records=0, Time=0ms)
SQL =
update tbl_users
set fullname =
'Rich,Carol,Phil,Richard,John,Barry,Steve,Cindy,Chris,Linda,Bill,Valerie,Joh
n,Pat,Lottie,Mary,Nelson,Jan,Charles,Dave,Liliya,Josiah,Bryan,Jan,Anna,Chris
tie,Boon,Paddy,Mary,Phu,Kim,Mary,Susan,Bev,Dick,Jarrod,Tom,Corey,Greg,Mary,L
yudmilla,Nancy,Henson,Prasad,Vance,Jeff,Carolyn,Stephanie,Jerry,Iva,Avon,Cat
hy,Robert,Bill,Walt,Mike,Robert,Luanne,Tony,Robin,Mike,Patricia,Jim,Al,Lovel
l,James,Greg,Robert,Pete,Joe,Karen,Cesar,Michele,Patricia,Greg,Roger,Dee,Tom
,Klaus'+'
'+'Pragel,Walter,Cody,Brotzman,Ferry,Cooper,Smith,Leo,Kinard,Cartrette,Bevan
,Kurnas,Warchal,Slater,Gowl,Leisure,Fitzgerald,Bloom,Tunstall,Stine,Avramenk
o,Chege,Groff,Hoover,Ketko,Ferrara,Yuth,Kumar,Powers,Nguyen,Wharton,Stegmaie
r,McDonald,grabill,Lehr,Glotfelty,Penner,Gation,Day,Takovich,Elbert,Lin,Rodr
igo,Uppalati,Givens,Ball,Lowe,White,Robinson,Witherspoon,Davis,Schepleng,Ter
ry,Surratt,Womack,Miller,Walker,Stachowski,Piccione,Stout,Beinlein,Cunningha
m,Eckley,Hiatt,Williams,Taavon,Mamayek,Williams,Marcher,Petrosino,Brooks,Rod
riguez,Williams,Lamartina,Faries,Hub,McElroy,Wendel,Reichelt'
where firstname =
'Rich,Carol,Phil,Richard,John,Barry,Steve,Cindy,Chris,Linda,Bill,Valerie,Joh
n,Pat,Lottie,Mary,Nelson,Jan,Charles,Dave,Liliya,Josiah,Bryan,Jan,Anna,Chris
tie,Boon,Paddy,Mary,Phu,Kim,Mary,Susan,Bev,Dick,Jarrod,Tom,Corey,Greg,Mary,L
yudmilla,Nancy,Henson,Prasad,Vance,Jeff,Carolyn,Stephanie,Jerry,Iva,Avon,Cat
hy,Robert,Bill,Walt,Mike,Robert,Luanne,Tony,Robin,Mike,Patricia,Jim,Al,Lovel
l,James,Greg,Robert,Pete,Joe,Karen,Cesar,Michele,Patricia,Greg,Roger,Dee,Tom
,Klaus' and
lastname =
'Pragel,Walter,Cody,Brotzman,Ferry,Cooper,Smith,Leo,Kinard,Cartrette,Bevan,K
urnas,Warchal,Slater,Gowl,Leisure,Fitzgerald,Bloom,Tunstall,Stine,Avramenko,
Chege,Groff,Hoover,Ketko,Ferrara,Yuth,Kumar,Powers,Nguyen,Wharton,Stegmaier,
McDonald,grabill,Lehr,Glotfelty,Penner,Gation,Day,Takovich,Elbert,Lin,Rodrig
o,Uppalati,Givens,Ball,Lowe,White,Robinson,Witherspoon,Davis,Schepleng,Terry
,Surratt,Womack,Miller,Walker,Stachowski,Piccione,Stout,Beinlein,Cunningham,
Eckley,Hiatt,Williams,Taavon,Mamayek,Williams,Marcher,Petrosino,Brooks,Rodri
guez,Williams,Lamartina,Faries,Hub,McElroy,Wendel,Reichelt'
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 2:57 PM
To: CF-Talk
Subject: Re: Still need a little help
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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
