hi everyone.... I am trying to do a query that will just show me events for a chosen day.
i have an output like this... <cfoutput query="days"> <CFSET yourDate = CreateDate(years, months, days)> <a href="index.cfm?showDate=#URLEncodedFormat(yourDate)#"> #DateFormat(yourDate, "dd/mmm [dddd]")# </a> </cfoutput> which gives me a urlencoded date format I then want to pass this to a query to show all events for that day. <cfquery name="events" datasource="#DSN#" dbtype="ODBC"> SELECT * FROM events WHERE eventdatestart = #createODBCdate(showdate)# ORDER BY eventdateStart </cfquery> I am not getting an error, but no results are being returned. I have tried also tried '#createODBCdate(showdate)#' (with single quotes) this should be so simple but i cant get results!? any help is appreciated. thanks chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
