Hi, I am not getting an error.
just no results! even if i enter a date directly into the statement. thanks chad > 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 > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
