Yet Another Problem i am trying to group by Month/Year i just cant seem to get it.
i have read ever thing i can find in WACK on group, GROUP BY, & CreateODBCDate to no avail. I have tried <cfoutput query="rsViewDate" group="#LSDateFormat(rsViewDate.KidDate,'MMMM YYYY')#"> but that does nothing good. in this query. i want it to show my dates entered but on duplicates of the date. so all the entrees for this month would just be in the select as April 2002 Thank You! <cfquery name="rsViewDate" datasource="kid"> SELECT KidDate FROM tblKid GROUP BY KidDate ORDER BY KidDate ASC </cfquery> <select name="KidDate" class="input"> <option value="">Select Date</option> <cfoutput query="rsViewDate" group="KidDate"> <option value="#rsViewDate.KidDate#">#LSDateFormat(rsViewDate.KidDate,'MMMM YYYY')#</option> </cfoutput> </select> -paul ______________________________________________________________________ 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
