Opps... had some stray code in there. SELECT blah.... FROM tblCalendar WHERE EventDate BETWEEN #CreateODBCDate(someStartDate)# AND #CreateODBCDate(someEndDate)#
Much better. G! > On Thu, Dec 17, 2009 at 10:06 AM, Damo Drumm <[email protected] > > wrote: > >> >> Hi im having some bother trying to get a search by date range working on a >> form in coldfusion. does anyone have any tips on setting this up? >> It would be greatly appreciated >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
