<Cfif parameterexists(form.photo) and #form.photo# is not ''>

		<cfset imagepath="/home/home2/domains/parentsknow.com/public_html/regionalhomepages/">
  <cffile action="upload"
accept="image/jpeg,image/pjpeg"
	      nameconflict="makeunique"
			  filefield="photo"
			  destination="#imagepath#">

	<cfset photo = "#File.ServerFile#">
  <cfset photo = replace(photo," ","_","ALL")>


 <cffile
   action = "rename"
   source = "#imagepath#/#File.ServerFile#"
   destination = "#imagepath#/#photo#"
   mode = "644">

<CFQUERY datasource="#ds#">
	UPDATE ParentsListingsCatMain2011 SET 
	catname = '#form.name#',
	shortname = '#form.shortname#',
	catnamealias = '#form.catnamealias#',
	catdescription = '#form.catdescription#',
	defaultimage = 'http://www.nymetroparents.com/regionalhomepages/#photo#',
	rocklanddescription = '#form.rocklanddescription#',
	regionaldescription = '#form.regionaldescription#',

	mastercat = #form.mastercat#,
	articlecategory = #form.articlecategory#,
	ignoreregions = #form.ignoreregions#,
	enhancedlisting = '#form.copyedit#',
		newnympsub = '#form.newnympsub#',

	hide = #form.hide#
	WHERE id = #form.id#
	</CFQUERY>
	
	
<cfelse>


<CFQUERY datasource="#ds#">
	UPDATE ParentsListingsCatMain2011 SET 
	catname = '#form.name#',
	shortname = '#form.shortname#',
	catdescription = '#form.catdescription#',
	mastercat = #form.mastercat#,
			newnympsub = '#form.newnympsub#',
				rocklanddescription = '#form.rocklanddescription#',
	regionaldescription = '#form.regionaldescription#',

	ignoreregions = #form.ignoreregions#,
	articlecategory = #form.articlecategory#,

	enhancedlisting = '#form.copyedit#',
	hide = #form.hide#
	WHERE id = #form.id#
	</CFQUERY>
	

</Cfif>
	


<cflocation url="addbestbetcategory2011.cfm" addtoken="no">