Give the fields the same name.
In most languages that results in a commadelimited value which you could
then strip out.
You could also just concatenate them together in your queryparam:
<cfqueryparam value="#trim(form.xdate_use)##trim(form.xtime)#"
cfsqltype="CF_SQL_DATE" />
-----Original Message-----
From: Les Mizzell [mailto:[email protected]]
Sent: Thursday, May 10, 2012 8:50 PM
To: cf-talk
Subject: date and time from two different inputs query a single datetime
field
<cfinput type="text" name="xdate_use" > ex: 05/31/2012 <cfinput type="text"
name="xtime" > ex: 3:31 PM
Given the values used as examples for the fields above, exactly how would I
go about querying a datetime stamp field (SQL Server) to find all records
dates on or after the date/time above?
No problem doing it with just the date:
responsedate >= <cfqueryparam value="#trim(form.xdate)#"
cfsqltype="CF_SQL_DATE" />
but for the life of me, I can't figure how to put both fields together to
do date AND time...
I'm probably an idiot..
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351113
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
