<cfinclude template="/header.cfm">

<table width=100%><tr><td>
<div align="center"><font face=verdana size=+1><strong>Export CG Print Guide</strong></font>
</div>
<p><font face=verdana size=-2>

<form  method="post"  enctype="multipart/form-data" action="cgexportguide.cfm">
<Br />
<select name="tablename">
<cfquery name="getstuff" datasource="#ds#">
select SubCatTableName
from _SubCat
order by SubCatTableName
</cfquery>

<cfoutput query="getstuff">

<option value="#SubCatTableName#">#SubCatTableName#

</cfoutput>
</select>


 <input type="submit" Value="Search"></form>
 
 <cfif parameterexists(form.tablename)>
 

 <p>

<Cfquery name="getm" datasource="#ds#">
select name,phone,website,address,city,description,email,fulldescription
from #form.tablename#
</CFQUERY>
<cfoutput query="getm">
<font size=+1>#name#</font>
<p>
<cfif #address# is not ''>#address#, #city#<br></cfif>
<Cfif #phone# is not ''>#phone#<p></CFIF>


<cfif #website# is not ''><em>#website#</em><br /></cfif>
<cfif #email# is not ''><em>#email#</em><br /></cfif>
<p><font size=+1 face=arial>#fulldescription#</font><br>

<p>
</Cfoutput>
 </cfif>
</td></tr></table>


<cfinclude template="/footer.cfm">