WHERE month(TO_DATE(eventdate)) = #form.eventdate# should be close. I don't have Oracle installed here currently.
-----Original Message----- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 10:29 AM To: CF-Talk Subject: Group queries in Coldfusion by date. Hi I have a query that brings back entries from my database, so that users can edit them in their web browser. At present the query returns all records, but I would like to display the output generated by date, so for example only January would be shown and if entries in the database existing for events in February, March etc they would be accessible via a drop down form select box. I.E. The user selects April from the select box and the page is refreshed showing only the entries for April and not January. Any ideas on how to achieve this? or is it achievable. This is my current code, I am using an Oracle 8 database <CFQUERY DATASOURCE="#Application.DSN#" NAME="updateguide"> SELECT eventid, eventdate, longtitle FROM whatson ORDER BY eventdate </CFQUERY> ----------------- <table width="100%" cellpadding="1" cellspacing="1" border="0" valign="top"> <!--- START ---> <CFOUTPUT QUERY="updateguide"> <tr> <td width="20%"> <span class="gstext11">#DateFormat(eventdate,"d-mmmm-yyyy")#</span> </td> <td width="60%"><span class="gsheader11">#longtitle#</span></td> <td width="10%" align="center"><a href="changeeventdetails.cfm?eventid=#eventid#" class="gsyellow11">EDIT</a></td> <td width="10%" align="center"><a href="javascript:confirmDelete('mediadelete.cfm?eventid=#eventid#')" class="checkprice">DELETE</a></td></tr> <tr> <td width="100%" colspan="4" align="center"> <img src="/images/dot_grey.gif" width="100%" height="1" vspace="2"> </td> </tr> </CFOUTPUT> <!--- END ---> </table> TIA Ian ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
