Rick... I'm relatively new to CF myself, but managed to develop a calendar app that does among other things, the two variable query you reference... keep in mind, the solutions are not always "laid out" nicely to see
In the situation you reference (the month/year scenario), I set up a database that includes numeric fields for each of the year and month. I set up drop down lists to pass the variables to a query template (as you indicate), then do a query on them ... something like <cfquery datasource="dates" name="cal"> SELECT * FROM events e, category c where (e.firstmonth=#firstmonth# and e.firstyear=#firstyear#) and (e.category=c.cat_no or e.category2=c.cat_no order by event_no, firstyear </cfquery> check out http://208.249.126.159/calendar/webcalendar_first.cfm T -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 6:31 AM To: CF-Talk Subject: Another Newbie Problem In all my cfm references I cannot find a single example of a common task, although you see this kind of thing being used everywhere. What I want to do is select from a pair of drop down lists (like Month and Year) and then display only the records from November 2002, for instance. How do you pass just those two variables to a query and draw just the date and month from a standard db date/time string. Is it a datepart function? I just don't get it. Any insight or pointing toward a tutorial would be appreciated. humbled by cfm yet again.... Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
