<Cfif parameterexists(url.add)>
    <cfquery name=addphoto datasource="#ds#">
INSERT INTO cgdirectorycats(catname)
VALUES	('')
</cfquery>

<Cfquery name="Geter" dataSource="#ds#">
    select id from cgdirectorycats order by id desc limit 0,1
</Cfquery>

<cflocation url="cg-directory-category-edit.cfm?id=#geter.id#" addtoken="no" statuscode="301">
</cfif>    

<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">





<cfparam name="getsubq.subcatid" default="0">

<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#><cfif session.email eq ''><cfset Session.email = -1></cfif><cfif IsDefined("Cookie.email")><cfset Session.email = Cookie.email></cfif>
<cfinclude template="header.cfm">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">
	  
<Cfif parameterexists(url.edit)>

<cfparam name="form.ccainfo" default="">
<cfparam name="form.ccadesc" default="">
<cfparam name="form.trackingpixel" default="">
<CFQUERY datasource="#ds#">
	UPDATE cgdirectorycats
	SET
	catname = '#form.catname#'
	WHERE ID = #form.id#
</CFQUERY>
done

<Cflocation addtoken="no" url="cg-directory-cats.cfm">


<cfelse>


<cfquery name="getrecord" datasource="#ds#">
select *
from cgdirectorycats
where id = #url.id#
</cfquery>

<cfoutput><FORM action="cg-directory-category-edit.cfm?edit=on&id=#url.id#" method="post" enctype="multipart/form-data"> </cfoutput>
<cfoutput><input NAME="id"  MAXLENGTH="200" TYPE="hidden" value="#url.id#">
<table>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Category Name:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="catname" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.catname#"></td>
</tr>

</cfoutput>

</table>


<!-- /tinyMCE -->

</td>
</tr>

</table>

</table>
<p><input type="submit" value="Submit the form">

</form></center>


</cfif>
<p>
         </div>
          </div>
        </div>
      </div>






      <!-- /.row -->

     <cfinclude template="footer.cfm">