<font face="helvetica" size=-1>

<cfif parameterexists(url.edit)>
	
	<cfquery name=addphoto datasource="#ds#">
update cca2018 

set company = '#form.company#',
email = '#form.email#',
fname = '#form.fname#',
email2 = '#form.email2#'
where id = #url.id#
</cfquery>


Done!
<cflocation url="/voteresetfinalists.cfm" addToken="no" statusCode="301">
 <A href="voteresetfinalists.cfm">back...</A><cfabort>
</cfif>



<Cfif parameterexists(url.editoneon)> 

<cfquery name="getone" dataSource="#ds#">
	select * from cca2018 where id = #url.id#
</cfquery>	

<cfoutput>
<FORM action="voteresetfinalists.cfm?edit=on&id=#url.id#" method="post" enctype="multipart/form-data">
   <table cellspacing=5 cellpadding=5 border=0>
  <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Company</b><br>
  </td><td>
	  <input NAME="company" SIZE="65" <Cfoutput>value="#getone.company#"</Cfoutput>  >
  </td></tr>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">First Name</b><br>
  </td><td>
	  <input NAME="fname" SIZE="65" <Cfoutput>value="#getone.fname#"</Cfoutput>  >
  </td></tr>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Email</b><br>
  </td><td>
	  <input NAME="email" SIZE="65"  <Cfoutput>value="#getone.email#"</Cfoutput> >
  </td></tr>
  
   <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Email2</b><br>
  </td><td>
	  <input NAME="email2" SIZE="65"  <Cfoutput>value="#getone.email2#"</Cfoutput> >
  </td></tr>
  
 

</table>
<center><input type="submit" Value="Edit Entry"></center>
</form>
</cfoutput>


<cfelse>

<Cfquery name="Getall" dataSource="#ds#">
	select * from cca2018
	order by category,company
</cfquery>

<Table border="1" cellpadding="4" cellspacing="0">
	<Tr>
			<Td><b>link</b></Td>
			<Td><b>edit</b></Td>

			<Td><b>category</b></Td>
					<Td><b>company</Td>
					<Td><b>firstname</Td>

					<Td><b>email</Td>
					<Td><b>email2</Td>
<td><b>phone</td>
<td><b>website</td>
<td><b>contactname</td>
<td><b>photo1</td>
<td><b>photo2</td>
<td><b>photo3</td>
<td><b>excellence</td>
	</Tr>	
	<Cfoutput query="Getall">
		<Tr>
			<Td><a href="sendinfo.cfm?id=#id#"><b>link</b></a></Td>

			<Td><a href="voteresetfinalists.cfm?editoneon&id=#id#">edit</a></Td>
			<Td><b>#category#</b></Td>
					<Td>#company#</Td>
					<Td>#fname#</Td>

					<Td>#email#</Td>
					<Td>#email2#</Td>
<td>#phone#</td>
<td>#website#</td>
<td>#contactname#</td>
<td><a href="/2018pics/#photo1#">#photo1#</a></td>
<td><a href="/2018pics/#photo2#">#photo2#</a></td>
<td><a href="/2018pics/#photo3#">#photo3#</a></td>
<td>#excellence#</td>

		</Tr>	
	
	</Cfoutput>	


</Table>		

</cfif>