<CFSET str_MyString = Left(FORM.Fname, 1) & Right(FORM.Lname,
Evaluate(Len(FORM.Lname)-1))>
<CFQUERY
Name="qry_MyQuery"
Datasource="#ds_MyDataSource#">
SELECT *
FROM Users
WHERE (startdate >= '#FORM.Startdate#' AND enddate <= '#FORM.Enddate#')
AND (username = '#str_MyString#')
</CFQUERY>
Exact syntax for the SQL will be dependent upon your database
Steve
-----Original Message-----
From: Christopher S Martin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 21, 2000 4: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/cf-talk@houseoffusion.com/
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.
