Hi mike...
that worked perfectly!
I was going crazy...... thanks so much!!!!!!!!!!!
regards
chad
> On the assumption that eventdatestart is a datetime object in your
> database then the query will be looking for the date passed and time =
> 0:00:00. If the inserted records contain timing information on insert
> then this will probably not return any records... Try.
>
> WHERE eventdatestart BETWEEN #createODBCdate(showdate)# AND
> #createODBCdate(DateAdd("d", 1, showdate))#
>
> HTH
>
> Mike
>
> -----Original Message-----
> From: list@objekt [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 2, 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
