I don't trust CreateODBC date in the slightest....are you using SQL? if so I would use a daterange using a charachter string in the format 'dd/mm/yyyy' to capture all dates between to consecutive dates (hence one day) All you need to do in addition to this is before executing your SQL statement ensure you include the line of code SET DATEFORMAT DMY
------------------------------------------------------------------ Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net ------------------------------------------------------------------ United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 ------------------------------------------------------------------ New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 ------------------------------------------------------------------ The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 02 October 2001 13:41 To: CF-Talk Subject: RE: where date = day problem 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
