ColdFusion

Image upload to MySQL using CF & DW CS3???

Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2008

Posts: 8

Reputation: Loki421 is an unknown quantity at this point

Solved Threads: 0

Loki421

Offline

Newbie Poster

Image upload to MySQL using CF & DW CS3???

Jul 7th, 2008

Hi all!!!

This is my first post here so please feel free to move if it's in the wrong place :-)

Ok, i am just starting out in web development, and i have created a data entry form in DW CS3 and succesfully link it into MySQL (big deal for me!), the problems is i cannot get images to upload to the database. I am using CF locally and MySQL is also on the development machine.

So here's what i've got so far

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
  <cfquery datasource="affinity">   
    INSERT INTO vehicle_details (vehicle_description, contract_details, available_to, deposit, business_price, personal_price, additional_infomation, manufacturer)
VALUES (<cfif IsDefined("FORM.vehicle_description") AND #FORM.vehicle_description# NEQ "">
<cfqueryparam value="#FORM.vehicle_description#" cfsqltype="cf_sql_clob" maxlength="200">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.contract_details") AND #FORM.contract_details# NEQ "">
<cfqueryparam value="#FORM.contract_details#" cfsqltype="cf_sql_clob" maxlength="150">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.available_to") AND #FORM.available_to# NEQ "">
<cfqueryparam value="#FORM.available_to#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.deposit") AND #FORM.deposit# NEQ "">
<cfqueryparam value="#FORM.deposit#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.business_price") AND #FORM.business_price# NEQ "">
<cfqueryparam value="#FORM.business_price#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.personal_price") AND #FORM.personal_price# NEQ "">
<cfqueryparam value="#FORM.personal_price#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.additional_infomation") AND #FORM.additional_infomation# NEQ "">
<cfqueryparam value="#FORM.additional_infomation#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.manufacturer") AND #FORM.manufacturer# NEQ "">
<cfqueryparam value="#FORM.manufacturer#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
)
  </cfquery>
  <cflocation url="adminwelcome.cfm">
</cfif>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>admin inside</title>
<style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: small;
	color: #999999;
}
body {
	background-color: #FFFFFF;
	background-image: url(images/Background_Affinity.jpg);
	background-repeat: no-repeat;
}
#container {
	width: 900px;
	margin-top: 60px;
	margin-right: auto;
	margin-left: auto;
}
#container #form1 #button2 {
	float: right;
}
-->
</style>
</head>
 
<body>
<div id="container">
  <form id="form1" name="form1" method="POST" action="<cfoutput> #CurrentPage# </cfoutput> ">
    <table width="582" border="0" cellpadding="2"> 
      <tr> 
        <td width="151"> Vehicle Description</td> 
        <td width="230"> <label> 
          <input type="text" name="vehicle_description" id="vehicle_description" /> 
        </label> </td> 
        <td width="181"> <label> 
          <input type="button" name="button5" id="button5" value="Help!" /> 
        </label> </td> 
      </tr> 
      <tr> 
        <td> Contract Details</td> 
        <td> <label> 
          <input type="text" name="contract_details" id="contract_details" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Available To</td> 
        <td> <label> 
          <input type="text" name="available_to" id="available_to" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Deposit</td> 
        <td> <label> 
          <input type="text" name="deposit" id="deposit" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Business Price</td> 
        <td> <label> 
          <input type="text" name="business_price" id="business_price" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Personal Price</td> 
        <td> <label> 
          <input type="text" name="personal_price" id="personal_price" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Additional Info</td> 
        <td> <label> 
          <input type="text" name="additional_infomation" id="additional_infomation" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td height="27"> Manufacturer</td> 
        <td> <label> 
          <input type="text" name="manufacturer" id="manufacturer" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Image</td> 
        <td> <input name="userfile[]2" type="file" /> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Brochure</td> 
        <td> <label> 
        <input name="userfile[]" type="file" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> &nbsp;</td> 
        <td> &nbsp;</td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> <input type="submit" name="Submit" id="button" value="Save Vehicle " /> </td> 
        <td> <label> 
          <input type="button" name="button2" id="button2" value="Cancel" onclick="history.back()" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> <label> 
          <input type="submit" name="button6" id="button6" value="Delete Vehicle" /> 
        </label> </td> 
        <td> &nbsp;</td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> &nbsp;</td> 
        <td> &nbsp;</td> 
        <td> &nbsp;</td> 
      </tr> 
    </table> 
    <input type="hidden" name="MM_InsertRecord" value="form1" /> 
  </form> 
</div> 
</body> 
</html> 
<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
  <cfquery datasource="affinity">   
    INSERT INTO vehicle_details (vehicle_description, contract_details, available_to, deposit, business_price, personal_price, additional_infomation, manufacturer)
VALUES (<cfif IsDefined("FORM.vehicle_description") AND #FORM.vehicle_description# NEQ "">
<cfqueryparam value="#FORM.vehicle_description#" cfsqltype="cf_sql_clob" maxlength="200">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.contract_details") AND #FORM.contract_details# NEQ "">
<cfqueryparam value="#FORM.contract_details#" cfsqltype="cf_sql_clob" maxlength="150">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.available_to") AND #FORM.available_to# NEQ "">
<cfqueryparam value="#FORM.available_to#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.deposit") AND #FORM.deposit# NEQ "">
<cfqueryparam value="#FORM.deposit#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.business_price") AND #FORM.business_price# NEQ "">
<cfqueryparam value="#FORM.business_price#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.personal_price") AND #FORM.personal_price# NEQ "">
<cfqueryparam value="#FORM.personal_price#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.additional_infomation") AND #FORM.additional_infomation# NEQ "">
<cfqueryparam value="#FORM.additional_infomation#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.manufacturer") AND #FORM.manufacturer# NEQ "">
<cfqueryparam value="#FORM.manufacturer#" cfsqltype="cf_sql_clob" maxlength="45">
<cfelse>
''
</cfif>
)
  </cfquery>
  <cflocation url="adminwelcome.cfm">
</cfif>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>admin inside</title>
<style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: small;
	color: #999999;
}
body {
	background-color: #FFFFFF;
	background-image: url(images/Background_Affinity.jpg);
	background-repeat: no-repeat;
}
#container {
	width: 900px;
	margin-top: 60px;
	margin-right: auto;
	margin-left: auto;
}
#container #form1 #button2 {
	float: right;
}
-->
</style>
</head>

<body>
<div id="container">
  <form id="form1" name="form1" method="POST" action="<cfoutput>#CurrentPage#</cfoutput>">
    <table width="582" border="0" cellpadding="2">
      <tr>
        <td width="151">Vehicle Description</td>
        <td width="230"><label>
          <input type="text" name="vehicle_description" id="vehicle_description" />
        </label></td>
        <td width="181"><label>
          <input type="button" name="button5" id="button5" value="Help!" />
        </label></td>
      </tr>
      <tr>
        <td>Contract Details</td>
        <td><label>
          <input type="text" name="contract_details" id="contract_details" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Available To</td>
        <td><label>
          <input type="text" name="available_to" id="available_to" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Deposit</td>
        <td><label>
          <input type="text" name="deposit" id="deposit" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Business Price</td>
        <td><label>
          <input type="text" name="business_price" id="business_price" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Personal Price</td>
        <td><label>
          <input type="text" name="personal_price" id="personal_price" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Additional Info</td>
        <td><label>
          <input type="text" name="additional_infomation" id="additional_infomation" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="27">Manufacturer</td>
        <td><label>
          <input type="text" name="manufacturer" id="manufacturer" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Image</td>
        <td><input name="userfile[]2" type="file" /></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Brochure</td>
        <td><label>
        <input name="userfile[]" type="file" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td><input type="submit" name="Submit" id="button" value="Save Vehicle " /></td>
        <td><label>
          <input type="button" name="button2" id="button2" value="Cancel" onclick="history.back()" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td><label>
          <input type="submit" name="button6" id="button6" value="Delete Vehicle" />
        </label></td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
    </table>
    <input type="hidden" name="MM_InsertRecord" value="form1" />
  </form>
</div>
</body>
</html>

So i'm thinking i must be missing a small command somewhere, but as i say i am a novice so if anyone out there can help me i'd be very grateful!!

Hope to hear from someone soon :-)

Thanks in advance!!

Last edited by peter_budo; Jul 7th, 2008 at 7:27 am. Reason: Code tag correction, closing tag is [/code] not [code]

•

Join Date: Feb 2008

Posts: 72

Reputation: cmhampton is an unknown quantity at this point

Solved Threads: 10

cmhampton

Offline

Junior Poster in Training

Re: Image upload to MySQL using CF & DW CS3???

Jul 7th, 2008

Couple of things here:

Use CFFILE to upload the files to the server.

(http://livedocs.adobe.com/coldfusion...2.html#4003197)

You also need to change the form's encoding type to multipart. I have updated your code below:

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
 
	<!--- Set the destination folder.  Use ExpandPath to properly map the folder. --->
	<cfset filePath = ExpandPath("/uploads") />
 
	<!--- Upload the image file.  Notice that the fileField value is not enclosed in #s.  This is the correct syntax --->
	<cffile action="upload" filefield="form.imageFile" nameconflict="makeunique" destination="#filePath#" result="imageUpload" />
 
	<!--- Upload the brochure file. --->
	<cffile action="upload" filefield="form.brochureFile" nameconflict="makeunique" destination="#filePath#" result="brochureUpload" />
 
	<cfquery datasource="affinity">   
		INSERT INTO 
				vehicle_details 
				(vehicle_description, contract_details, available_to, deposit, business_price, personal_price, additional_infomation, manufacturer, imageFile, brochureFile)
		VALUES (
				<cfif IsDefined("FORM.vehicle_description") AND FORM.vehicle_description NEQ "">
					<cfqueryparam value="#FORM.vehicle_description#" cfsqltype="cf_sql_clob" maxlength="200">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.contract_details") AND FORM.contract_details NEQ "">
					<cfqueryparam value="#FORM.contract_details#" cfsqltype="cf_sql_clob" maxlength="150">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.available_to") AND FORM.available_to NEQ "">
					<cfqueryparam value="#FORM.available_to#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.deposit") AND FORM.deposit NEQ "">
					<cfqueryparam value="#FORM.deposit#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.business_price") AND FORM.business_price NEQ "">
					<cfqueryparam value="#FORM.business_price#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.personal_price") AND FORM.personal_price NEQ "">
					<cfqueryparam value="#FORM.personal_price#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.additional_infomation") AND FORM.additional_infomation NEQ "">
					<cfqueryparam value="#FORM.additional_infomation#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.manufacturer") AND FORM.manufacturer NEQ "">
					<cfqueryparam value="#FORM.manufacturer#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("imageUpload") AND Len(Trim(imageUpload)) NEQ 0>
					<cfqueryparam value="#imageUpload.ServerFile#" cfsqltype="cf_sql_varchar">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("brochureUpload") AND Len(Trim(brochureUpload)) NEQ 0>
					<cfqueryparam value="#brochureUpload.ServerFile#" cfsqltype="cf_sql_varchar">
				<cfelse>
					''
				</cfif>
			)
	</cfquery>
 
  <cflocation url="adminwelcome.cfm">
 
</cfif>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>admin inside</title>
<style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: small;
	color: #999999;
}
body {
	background-color: #FFFFFF;
	background-image: url(images/Background_Affinity.jpg);
	background-repeat: no-repeat;
}
#container {
	width: 900px;
	margin-top: 60px;
	margin-right: auto;
	margin-left: auto;
}
#container #form1 #button2 {
	float: right;
}
-->
</style>
</head>
 
<body>
<div id="container">
 
  <!--- Set the form encoding type to multipart. --->
  <form id="form1" name="form1" method="POST" enctype="multipart/form-data" action="<cfoutput> #CurrentPage# </cfoutput> ">
    <table width="582" border="0" cellpadding="2"> 
      <tr> 
        <td width="151"> Vehicle Description</td> 
        <td width="230"> <label> 
          <input type="text" name="vehicle_description" id="vehicle_description" /> 
        </label> </td> 
        <td width="181"> <label> 
          <input type="button" name="button5" id="button5" value="Help!" /> 
        </label> </td> 
      </tr> 
      <tr> 
        <td> Contract Details</td> 
        <td> <label> 
          <input type="text" name="contract_details" id="contract_details" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Available To</td> 
        <td> <label> 
          <input type="text" name="available_to" id="available_to" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Deposit</td> 
        <td> <label> 
          <input type="text" name="deposit" id="deposit" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Business Price</td> 
        <td> <label> 
          <input type="text" name="business_price" id="business_price" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Personal Price</td> 
        <td> <label> 
          <input type="text" name="personal_price" id="personal_price" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Additional Info</td> 
        <td> <label> 
          <input type="text" name="additional_infomation" id="additional_infomation" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td height="27"> Manufacturer</td> 
        <td> <label> 
          <input type="text" name="manufacturer" id="manufacturer" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Image</td> 
        <td> <input name="imageFile" type="file" /> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> Brochure</td> 
        <td> <label> 
        <input name="brochureFile" type="file" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> &nbsp;</td> 
        <td> &nbsp;</td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> <input type="submit" name="Submit" id="button" value="Save Vehicle " /> </td> 
        <td> <label> 
          <input type="button" name="button2" id="button2" value="Cancel" onclick="history.back()" /> 
        </label> </td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> <label> 
          <input type="submit" name="button6" id="button6" value="Delete Vehicle" /> 
        </label> </td> 
        <td> &nbsp;</td> 
        <td> &nbsp;</td> 
      </tr> 
      <tr> 
        <td> &nbsp;</td> 
        <td> &nbsp;</td> 
        <td> &nbsp;</td> 
      </tr> 
    </table> 
    <input type="hidden" name="MM_InsertRecord" value="form1" /> 
  </form> 
</div> 
</body> 
</html> 
<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">

	<!--- Set the destination folder.  Use ExpandPath to properly map the folder. --->
	<cfset filePath = ExpandPath("/uploads") />

	<!--- Upload the image file.  Notice that the fileField value is not enclosed in #s.  This is the correct syntax --->
	<cffile action="upload" filefield="form.imageFile" nameconflict="makeunique" destination="#filePath#" result="imageUpload" />
	
	<!--- Upload the brochure file. --->
	<cffile action="upload" filefield="form.brochureFile" nameconflict="makeunique" destination="#filePath#" result="brochureUpload" />

	<cfquery datasource="affinity">   
		INSERT INTO 
				vehicle_details 
				(vehicle_description, contract_details, available_to, deposit, business_price, personal_price, additional_infomation, manufacturer, imageFile, brochureFile)
		VALUES (
				<cfif IsDefined("FORM.vehicle_description") AND FORM.vehicle_description NEQ "">
					<cfqueryparam value="#FORM.vehicle_description#" cfsqltype="cf_sql_clob" maxlength="200">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.contract_details") AND FORM.contract_details NEQ "">
					<cfqueryparam value="#FORM.contract_details#" cfsqltype="cf_sql_clob" maxlength="150">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.available_to") AND FORM.available_to NEQ "">
					<cfqueryparam value="#FORM.available_to#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.deposit") AND FORM.deposit NEQ "">
					<cfqueryparam value="#FORM.deposit#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.business_price") AND FORM.business_price NEQ "">
					<cfqueryparam value="#FORM.business_price#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.personal_price") AND FORM.personal_price NEQ "">
					<cfqueryparam value="#FORM.personal_price#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.additional_infomation") AND FORM.additional_infomation NEQ "">
					<cfqueryparam value="#FORM.additional_infomation#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("FORM.manufacturer") AND FORM.manufacturer NEQ "">
					<cfqueryparam value="#FORM.manufacturer#" cfsqltype="cf_sql_clob" maxlength="45">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("imageUpload") AND Len(Trim(imageUpload)) NEQ 0>
					<cfqueryparam value="#imageUpload.ServerFile#" cfsqltype="cf_sql_varchar">
				<cfelse>
					''
				</cfif>,
				<cfif IsDefined("brochureUpload") AND Len(Trim(brochureUpload)) NEQ 0>
					<cfqueryparam value="#brochureUpload.ServerFile#" cfsqltype="cf_sql_varchar">
				<cfelse>
					''
				</cfif>
			)
	</cfquery>
  
  <cflocation url="adminwelcome.cfm">
  
</cfif>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>admin inside</title>
<style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: small;
	color: #999999;
}
body {
	background-color: #FFFFFF;
	background-image: url(images/Background_Affinity.jpg);
	background-repeat: no-repeat;
}
#container {
	width: 900px;
	margin-top: 60px;
	margin-right: auto;
	margin-left: auto;
}
#container #form1 #button2 {
	float: right;
}
-->
</style>
</head>

<body>
<div id="container">

  <!--- Set the form encoding type to multipart. --->
  <form id="form1" name="form1" method="POST" enctype="multipart/form-data" action="<cfoutput>#CurrentPage#</cfoutput>">
    <table width="582" border="0" cellpadding="2">
      <tr>
        <td width="151">Vehicle Description</td>
        <td width="230"><label>
          <input type="text" name="vehicle_description" id="vehicle_description" />
        </label></td>
        <td width="181"><label>
          <input type="button" name="button5" id="button5" value="Help!" />
        </label></td>
      </tr>
      <tr>
        <td>Contract Details</td>
        <td><label>
          <input type="text" name="contract_details" id="contract_details" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Available To</td>
        <td><label>
          <input type="text" name="available_to" id="available_to" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Deposit</td>
        <td><label>
          <input type="text" name="deposit" id="deposit" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Business Price</td>
        <td><label>
          <input type="text" name="business_price" id="business_price" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Personal Price</td>
        <td><label>
          <input type="text" name="personal_price" id="personal_price" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Additional Info</td>
        <td><label>
          <input type="text" name="additional_infomation" id="additional_infomation" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="27">Manufacturer</td>
        <td><label>
          <input type="text" name="manufacturer" id="manufacturer" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Image</td>
        <td><input name="imageFile" type="file" /></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Brochure</td>
        <td><label>
        <input name="brochureFile" type="file" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td><input type="submit" name="Submit" id="button" value="Save Vehicle " /></td>
        <td><label>
          <input type="button" name="button2" id="button2" value="Cancel" onclick="history.back()" />
        </label></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td><label>
          <input type="submit" name="button6" id="button6" value="Delete Vehicle" />
        </label></td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
    </table>
    <input type="hidden" name="MM_InsertRecord" value="form1" />
  </form>
</div>
</body>
</html>

I hope this helps. Let me know if you need anything.

•

Join Date: Jul 2008

Posts: 8

Reputation: Loki421 is an unknown quantity at this point

Solved Threads: 0

Loki421

Offline

Newbie Poster

Re: Image upload to MySQL using CF & DW CS3???

Jul 7th, 2008

That's great!! Thanks, really appreciate the time you've taken for me.

Unfortunatly i'm getting this error now when i try to use it:

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator. 
 
The following information is meant for the website developer for debugging purposes.  
 
Error Occurred While Processing Request  
Complex object types cannot be converted to simple values.  
The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. 
The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a cfif tag. 
 
 
Resources: 
Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debug Output Settings, and select the Robust Exception Information option. 
Check the ColdFusion documentation to verify that you are using the correct syntax. 
Search the Knowledge Base to find a solution to your problem. 
 
 
Browser   Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; YPC 3.2.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 1.1.4322; InfoPath.1) 
Remote Address   127.0.0.1 
Referrer   <a rel="nofollow" class="t" href="http://localhost:8500/affinity_new_site_testing/updatedcode.cfm" target="_blank">http://localhost:8500/affinity_new_s...pdatedcode.cfm</a> 
Date/Time   07-Jul-08 07:17 PM
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator. 

The following information is meant for the website developer for debugging purposes.  

Error Occurred While Processing Request  
Complex object types cannot be converted to simple values.  
The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. 
The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a cfif tag. 
 
  
Resources: 
Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debug Output Settings, and select the Robust Exception Information option. 
Check the ColdFusion documentation to verify that you are using the correct syntax. 
Search the Knowledge Base to find a solution to your problem. 

 
Browser   Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; YPC 3.2.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 1.1.4322; InfoPath.1) 
Remote Address   127.0.0.1 
Referrer   <a rel="nofollow" class="t" href="http://localhost:8500/affinity_new_site_testing/updatedcode.cfm" target="_blank">http://localhost:8500/affinity_new_s...pdatedcode.cfm</a> 
Date/Time   07-Jul-08 07:17 PM

Don't suppose you know what's up with it do you? :-)

Last edited by peter_budo; Jul 9th, 2008 at 8:10 am. Reason: Please avoid using an excessive amount of [bbcode] to alter font styles

•

Join Date: Feb 2008

Posts: 72

Reputation: cmhampton is an unknown quantity at this point

Solved Threads: 10

cmhampton

Offline

Junior Poster in Training

Re: Image upload to MySQL using CF & DW CS3???

Jul 7th, 2008

Go into the ColdFusion Administrator and turn on Robust Debugging. Check the line number and let me know where the error is occurring. I didn't get a chance to actually test this, so I probably missed something.

Last edited by cmhampton; Jul 7th, 2008 at 4:44 pm.