Another options is to change the query to
SELECT isnull(firstname,'') + ' ' + isnull(lastname,'') as fullname from
TABLENAME
Then just use #fullname#. The isNulls are there because if one of the
fields is NULL, the entire fullname value will be NULL.
Jonathan McGuire
Impact Solutions, Inc.
----- Original Message -----
From: "Clint Tredway" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 17, 2000 8:39 AM
Subject: RE: Newbie qts -
When you output your query just put them side by side <cfoutput
query="queryname">#fname# #lname#</cfoutput>
HTH
-----Original Message-----
From: Dharmendar Kumar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 17, 2000 5:23 AM
To: [EMAIL PROTECTED]
Subject: Newbie qts -
This is a multi-part message in MIME format.
------=_NextPart_000_003E_01BFC017.F515F160
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am selecting two fields in a query - firstname and lastname.
I want to concatenate the two fields and display the fullname in a =
single column in a CFGRID. How do I do this.
Can anyone help me?
Dharmendar Kumar
------=_NextPart_000_003E_01BFC017.F515F160
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dwindows-1252" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I am selecting two fields in a query - =
firstname=20
and lastname.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I want to concatenate the two fields =
and display=20
the fullname in a single column in a CFGRID. How do I do =
this.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Can anyone help me?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Dharmendar =
Kumar</FONT></DIV></BODY></HTML>
------=_NextPart_000_003E_01BFC017.F515F160--
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
