Chad, What's the error that you're getting and where???
Regards Stephen > -----Original Message----- > From: list@objekt [mailto:[EMAIL PROTECTED]] > Sent: 02 October 2001 13:29 > To: CF-Talk > Subject: where date = day problem > > > 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 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
