I'll second that book suggestion. It's got both basic and advanced concepts and it's very friendly to read. I keep it in my bookbag with me at all times.
<!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 19, 2006 10:00 AM To: CF-Talk Subject: RE: Need help building pages with multiple queries and tables Ben also wrote a book a long time ago called Sams Teach Yourself SQL in 10 minutes. I still have it on my book shelf. It just gives you references to SQL statements, not how the world began and the invention of SQL like a lot of books. Bruce Sorge -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 19, 2006 7:55 AM To: CF-Talk Subject: Re: Need help building pages with multiple queries and tables 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:247056 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
