<CFSET someString = StartDate & " AND " & EndDate>
If startdate and enddate are valid conditions to be used in a WHERE SQL
clause.
Justin Kidman
-----Original Message-----
From: Christopher S Martin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 21, 2000 1:34 PM
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.
