Hello What i am trying to do is a query for a select box
I want to return all the StudioName's for this month who haven't already done a submission for this month. So if a studio has submitted this months form there name is no longer in the list, of studios who need to fill it out. But next month there name would be in the select again. i think AND (tblKid.StudioID <> tblStudio.StudioID)) would permanently hide the name But right now it is showing all the studios, even though is should be hiding a few. Any help would be great. -paul <CFSET todayDate = #DateFormat(Now(), "M/DD/YYYY")#> <cfquery name="rsStudio" datasource="kid"> SELECT tblStudio.StudioID, tblStudio.StuShort, tblStudio.StudioName, tblKid.StudioID, tblKid.KidDate FROM tblStudio, tblKid WHERE ((tblKid.KidDate NOT IN (#todayDate#)) AND (tblKid.StudioID <> tblStudio.StudioID)) GROUP BY tblStudio.StudioID, StuShort, StudioName, tblKid.StudioID, tblKid.KidDate ORDER BY StudioName ASC </cfquery> Studio <select name="StudioID" class="input"> <option value="">Select Studio</option> <cfoutput query="rsStudio" group="StudioID"> <option value="#rsStudio.StudioID#">#rsStudio.StudioName#</option> </cfoutput> </select> ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
