Groups | Blog | Home
all groups > coldfusion flash integration > march 2006 >

coldfusion flash integration : CFCalendar & Sql


hhr_jb
3/13/2006 11:42:26 PM
Trying to do a query using the CFCalendar. After the user select the dates how
do I pass the user select dates in my query?

I have created 2 cf calendar for the user to select from
Here's the query I want to use, but not sure how I would write the query
statement. I would like to display the data as the user selects . Do I need
to create a function on change, or do data binding ?

Select * from Inventory where Date >= "1st Select Date" and Date < "2nd
Selected Date"?

Thanks,
Jimmy

LL NO[at]SPAM Work
3/17/2006 4:20:16 PM
Invoking the cfquery will not work in client-side onchange() scripting because
the selected date must be passed back to the server in order to process the
query.
CFML code is always processed on the server.
hhr_jb
3/17/2006 4:56:56 PM
Thanks for your reply. Would you happen to know how this could be done? I've
seen this worked on sites like this one. It's written in cfml.

http://reservations.ihotelier.com/onescreen.cfm?hotelID=2054

Thanks,
AddThis Social Bookmark Button