For more info on this, I strongly recommend you invest in Ben Forta's "Web Application Construction Kit" because this info is fundamental to designing web apps with Coldfusion.
http://www.forta.com/books/0321223675/ On 7/19/06, Charlie Hanlon <[EMAIL PROTECTED]> wrote: > <cfquery name="qcf_getSchools" datasource="yourDSN"> > SELECT s.SchoolID, s.SchoolName, t.SchoolType > FROM Schools s, SchoolType t > WHERE s.SchoolTypeID = t.SchoolTypeID > ORDER BY t.SchoolType, s.SchoolName > </cfquery> > > <cfoutput query="qcf_getSchools" group="SchoolType"> > #qcf_getSchools.SchoolType# > <cfoutput> > <a > href="school.cfm?id=#qcf_getSchools.SchoolID#">#qcf_getSchools.SchoolName#</a> > </cfoutput> > </cfoutput> > > I would add a SchoolTypeID field to table SchoolType and then reference that > ID within table Schools -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247045 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
