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
