<cfinclude template="header.cfm">
<!---
<cfquery name="getcat" datasource="cg22">
select *
from _SubCat
where SubCatTableName <> 'Galleries'
and SubCatTableName <> 'Travel'
order by SubCatName
</cfquery>


<cfloop from="1" to="#getcat.recordcount#" index="i">
  
  <cfquery name="Geter" datasource="#ds#">
    select id, zip from #getcat.SubCatTableName[i]# 
  </cfquery>
  
  <Cfoutput query="geter">
    
    <cfif isnumeric(geter.zip)>
<cfquery name="getne" datasource="#ds#">
    select * from neighborhood2022
    where zip = #geter.zip#
</cfquery>    
    
    <cftry>
    <cfquery name="ud" datasource="#ds#">
      
      update #getcat.SubCatTableName[i]# 
      set neighborhood = '#getne.neighborhood#'
      where zip = #geter.zip#
    </cfquery>
    <cfcatch></cfcatch>
    </cftry>
    </cfif>
  </Cfoutput>
  
  
</cfloop>
--->

<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;"><cfquery name="getcat" datasource="cg22">
select *
from _SubCat
order by SubCatName
</cfquery>

<cfif parameterexists(form.SubCatTableName)>
<cfquery name="getcat2" datasource="cg22">
select *
from Cat#form.SubCatTableName#
order by cat
</cfquery>
</cfif>
					<table border="0" cellpadding="8" cellspacing="0" width="100%">
					<tr>
					<td valign="top">

<span class="header">Add Listing</span></strong><br>




<p>
<table><tr><Td width=50% valign=top>
<cfif not parameterexists(form.catid)>
<FORM action="addlisting.cfm" method="post">

<SELECT size=1 name="SubCatTableName">
<option value=''>Select Category
<cfoutput query="getcat">
<option value="#SubCatTableName#"><cfif #subcatname# 
contains 'Car'>Travel Services<cfelse>#SubCatName#</cfif></option>
</cfoutput>
</select>
<INPUT type=submit value="Pick Catagory">
</FORM>
</cfif>
</Td><td width=50%>

<cfif parameterexists(form.SubCatTableName)>
<cfoutput>
<FORM action="addlisting.cfm?SubCatTableName=#form.SubCatTableName#" method="post">
</cfoutput>
<SELECT size=1 name="catid">
<option value=''>Select SubCategory
<cfoutput query="getcat2">
<option value="#CatID#">#Cat#</option>
</cfoutput>
</select>
<INPUT type=submit value="Pick Subcategory">
</FORM>
</cfif>
</td></tr></table>


<cfif parameterexists(url.SubCatTableName) and parameterexists(form.catid)>


<FORM action="addlisting2.cfm" method="post">
<cfoutput>
<input NAME="subcattablename"  MAXLENGTH="200" TYPE="hidden" value="#url.subcattablename#">
<input NAME="catid"  MAXLENGTH="200" TYPE="hidden" value="#form.catid#">
</cfoutput>
<table>

<tr>
<td VALIGN=TOP><b><font face="Arial" size="+0">Name:</font></b></td>
<td VALIGN=TOP><input NAME="Name" MAXLENGTH="200" TYPE="text" SIZE="30"></td>
</tr>

<tr>
<td><b><font face="Arial" size="+0">Advertiser:</font></b></td>

<td><SELECT SIZE="1" NAME="Advertiser">
  <OPTION VALUE="1">Yes</option>
  <OPTION VALUE="0">No</option>
  </SELECT></td>
</tr>






<tr>
<td VALIGN=TOP><b><font face="Arial" size="+0">Address:</font></b></td>
<td VALIGN=TOP><input NAME="Address" MAXLENGTH="200" TYPE="text" SIZE="30">
</td>
</tr>

<tr>
<td VALIGN=TOP><b><font face="Arial" size="+0">City:</font></b></td>
<td VALIGN=TOP><input NAME="City" MAXLENGTH="200" TYPE="text" SIZE="30">
</td>
</tr>

<tr>
<td VALIGN=TOP><b><font face="Arial" size="+0">State:</font></b></td>
<td VALIGN=TOP><input NAME="State" MAXLENGTH="200" TYPE="text" SIZE="30">
</td>
</tr>

<tr>
<td VALIGN=TOP><b><font face="Arial" size="+0">Zip:</font></b></td>
<td VALIGN=TOP><input NAME="Zip" MAXLENGTH="200" TYPE="text" SIZE="30">
</td>
</tr>

<tr>
<td VALIGN=TOP width=20><b><font face="Arial" size="+0">Contact:</font></b></td>
<td VALIGN=TOP><input NAME="contactname" MAXLENGTH="200" TYPE="text" SIZE="30">
</td>
</tr>
<tr>
<td VALIGN=TOP><b><font face="Arial" size="+0">Phone:</font></b></td>
<td VALIGN=TOP><input NAME="Phone" MAXLENGTH="200" TYPE="text" SIZE="30">
</td>
</tr>

<tr>
<td VALIGN=TOP><b><font face="Arial" size="+0">Email:</font></b></td>
<td VALIGN=TOP><input NAME="Email" MAXLENGTH="200" TYPE="text" SIZE="30">
</td>
</tr>
<tr>
<td VALIGN=TOP><b><font face="Arial" size="+0">Web Site:</font></b></td>
<td VALIGN=TOP><input NAME="website" MAXLENGTH="200" TYPE="text" SIZE="30">
</td>
</tr>



<tr><td>
	  <b><font SIZE="+0" FACE="arial">Contact First Name:</font></b>
  </td><td>
	  <input NAME="contactfirst" SIZE="10">
  </td></tr>

	    <tr><td>
	  <b><font SIZE="+0" FACE="arial">Contact Last Name:</font></b>
  </td><td>
	  <input NAME="contactlast" SIZE="15">
  </td></tr>

      <tr><td>
	  <b><font SIZE="+0" FACE="arial">Contact Title:</font></b>
  </td><td>
	  <input NAME="contactitle" SIZE="15">
  </td></tr>

      <tr><td>
	  <b><font SIZE="+0" FACE="arial">Contact Phone Number:</font></b>
  </td><td>
	  <input NAME="contactphone" SIZE="15">
  </td></tr>

      <tr><td>
	  <b><font SIZE="+0" FACE="arial">Contact E-Mail:</font></b>
  </td><td>
	  <input NAME="contactemail" SIZE="15">
  </td></tr>


<tr>
<td VALIGN=TOP><b><font face="Arial" size="+0">Short Description:</font></b></td>
<td VALIGN=TOP><textarea name="description" cols="40" rows=20></textarea>
</td>
</tr>

<tr>
<td VALIGN=TOP><b><font face="Arial" size="+0">Full Description:</font></b></td>
<td VALIGN=TOP><textarea name="fulldescription" cols="40" rows=20></textarea>
</td>
</tr>



</table>


<p><input type="submit" value="Add Listing"></form></center>


</cfif>


</td></tr></table>