I'd usually go with:
<cfset someString = "#StartDate# AND #EndDate#">
Much more readable. I'm not sure about the performance, though. Anyone?
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
-----Original Message-----
From: Russel Madere [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 22, 2000 8:31 AM
To: CF-Talk
Subject: RE: Cocatenation
Try:
<cfset someString = StartDate & " AND " & EndDate>
assuming of course that StartDate and EndDate are variables.
Russel
============================================================
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
Just what the heck is a Turbo Squid?!?!?!?!?!? Ask me.......
============================================================
-----Original Message-----
From: Christopher S Martin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 21, 2000 15:34
To: CF-Talk
Subject: Cocatenation
How do I concatenate three strings?
I want to cocatenate two variable name, with AND. I tried :
cfset someString = Evaluate("StartDate" & AND & "EndDate")
as well as:
Evaluate("StartDate" & DE(AND & "EndDate")
BUt niether of the worked. I would like to use someString as a where clause
in a query, so it should output the values stored in some string. WHat
should I do?
Thanks,
Chris Martin
[EMAIL PROTECTED]
www.fsenablers.com
www.fslink.com
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
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.mail-archive.com/[email protected]/
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.mail-archive.com/[email protected]/
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.
