Ad:

ColdFusion Discussion Thread
Unsolved
Views: 3996

Jul 7th, 2008

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

Expand Post »

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

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]

Loki421

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Jul 2008

Permalink

Jul 7th, 2008

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

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:

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.

cmhampton

Reputation Points: 23

Solved Threads: 10

Junior Poster in Training

Offline

79 posts
since Feb 2008

Permalink

Jul 7th, 2008

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

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:

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" 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" 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

Loki421

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Jul 2008

Permalink

Jul 7th, 2008

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

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.

cmhampton

Reputation Points: 23

Solved Threads: 10

Junior Poster in Training

Offline

79 posts
since Feb 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ColdFusion Forum Timeline: multiple left outer joins on query of query

Next Thread in ColdFusion Forum Timeline: CF8 XML output problem with special character

DaniWeb Message

Cancel Changes

User Name
Password