this is the query I am using on the viewschool.cfm doc... <cfquery name="getSchools" datasource="savvy">
SELECT * FROM Schools s, Principals p, VicePrincipals v WHERE s.SchoolID = (<cfqueryparam value="#URL.id#">) AND p.SchoolID = (<cfqueryparam value="#URL.id#">) AND v.SchoolID = (<cfqueryparam value="#URL.id#">) </cfquery> and this is body code... <body> <h1>Schools & Centers</h1> <cfoutput query="getSchools" maxrows="1"> <table width="95%" border="0" cellspacing="10"> <tr> <td valign="top" width="25%" align="right"><img src="/website/images/schoollogos/#SchoolName#-large.gif" alt="#SchoolName#'s Logo"/></td> <td valign="top"><strong>#SchoolNameLong#</strong><br /> Click <a href="javascript:openWin('#SchoolWeb#')">here</a> to go to #SchoolName#'s website</td> </tr> <tr valign="top"> <td align="right"><strong>School Address:</strong></td> <td>#SchoolAddr#<br />#SchoolCity#, #SchoolState# #SchoolZip#</td> </tr> <tr valign="top"> <td align="right"><strong>School Phone and Fax Numbers:</strong></td> <td>#SchoolPhone# (main phone) <br /> #SchoolPhone2#(alternate phone) <br /> #SchoolFax# (fax)</td> </tr> <tr valign="top"> <td align="right"><strong>Administration:</strong></td> <td>Principal: <ul><li>#PrincipalPrefix# #PrincipalFName# #PrincipalLName#</li></ul>Vice Principal(s): <ul><cfoutput><li>#VPPrefix# #VPFName# #VPLName#</li></cfoutput></ul></td> </tr> <tr valign="top"> <td align="right"><strong>School Start and End Times:</strong></td> <td>Start Time: #SchoolStart#<br />End Time: #SchoolEnd#</td> </tr> </table> </cfoutput> </body> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:247340 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4