>- see footer for list info -< I'm sure it's not the first time Paul :-)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Swingewood Sent: 11 October 2005 09:13 To: [email protected] Subject: RE: [CF-Dev] Thoughts >- see footer for list info -< What a sensible idea .... Why didn't I think of that .... I feel very stupid now ..... Thanks Kerry .... >From: "Kerry" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED],Coldfusion Development ><[email protected]> >To: "Coldfusion Development" <[email protected]> >Subject: RE: [CF-Dev] Thoughts >Date: Tue, 11 Oct 2005 08:56:03 +0100 > > >- see footer for list info -< >Make the first option "Please select..." so that there is always an >onchange? > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of Paul Swingewood >Sent: 11 October 2005 08:35 >To: [email protected] >Subject: [CF-Dev] Thoughts > > > >- see footer for list info -< >The best way I can describe this is to give you a link. > >http://www.bgfl.org/cfpages/calendar > >If you click the known issues link you will see an a-z list and a drop >down box. The drop down box shows the schools which have the first >letter chosen from the a-z list. > >I have a line of code > ><select name="selected_School" onChange="this.form.submit()"> > >So that when the the list is changed known issues (if there are any) >are shown in a box below. >The problem is that this doesn't work first time around. (becuse ther >is no 'onChange'. > >So how do I force it to bring back known issues for the current school >in the drop down list. It will need to see the letter selected each time too? > >I guess I could make a query that brings back the first record each >time a letter is chosen but is there a better way ...? > >Regards - Paul > >The queries so far .... > ><!--- Set the letter to 'A' if no letter is passed in the URL ---> ><cfif not isdefined("url.letter")> > <cfset url.letter = 'a'> ></cfif> > ><!--- Get the first letter of all of the schools to produce the a-z >list >---> ><cfquery name="select_az" datasource="#Application.SchoolsDSN#"> >SELECT DISTINCT LEFT(SchoolName,1) AS letter > FROM tblSchools > ORDER BY LEFT(SchoolName,1) ></cfquery> > > > ><!--- Get the schools that start with the first letter passed in the >URL >---> ><cfquery name="GetSchools" datasource="#Application.SchoolsDSN#"> >SELECT SchoolIDPK, SchoolName >FROM tblSchools >WHERE LEFT(SchoolName,1) = '#URL.Letter#' >ORDER BY SchoolName ></cfquery> > > >and when the form is submitted to itself .... > ><cfif isdefined("form.selected_school")> ><cfquery name="GetIssues" datasource="#application.CalendarDSN#"> >SELECT IssueIDPK, >SchoolIDFK, >ReportedBy, >ReportedDate, >Issue, >ActionedBy, >ActionDate, >IssueAction >FROM tblIssues >WHERE SchoolIDFK = #form.Selected_School# </cfquery> > > >_______________________________________________ > >For details on ALL mailing lists and for joining or leaving lists, go >to http://list.cfdeveloper.co.uk/mailman/listinfo > >-- >CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > >help >-< > >_______________________________________________ > >For details on ALL mailing lists and for joining or leaving lists, go >to http://list.cfdeveloper.co.uk/mailman/listinfo > >-- >CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > >help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
