Help:Uploading an image and saving it in db.

Dev Shed Forums Sponsor:

Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!

March 1st, 2005, 07:52 PM

perlnewbie23

Contributing User

Join Date: Oct 2004

Posts: 105

Time spent in forums: 4 h 41 sec
Reputation Power: 4

Help:Uploading an image and saving it in db.

Hi, I'm trying to upload an image from my webpage that i'm creating and inserting it into my database in access. But i'm having an error message that said: "Invalid data C:\CFusionMX7\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp20871.tmp,Upload for CFSQLTYPE CF_SQL_LONGBINARY."

Here is my code:

PHP Code:


		
			
<!--Insert a new product into the shoe table-->

<cflock name="InsertNewProduct" type="exclusive" timeout="30">

<cftransaction>

<cfquery name="AddProduct" datasource="shoes">

    INSERT INTO shoe(manufactorID, brand, name, details, type, price, color, size)

    VALUES('#form.manufactorID#', '#form.brand#', '#form.name#', '#form.details#', '#form.type#', 

    '#form.price#','#form.color#', '#form.size#')

</cfquery>

<!--This query retrieves the primary key value of the product we just inserted-->

<cfquery name="GetPK" datasource="shoes">

    SELECT MAX(shoeID) AS MaxShoeID FROM Shoe

</cfquery>

</cftransaction>

</cflock>



<!--This query uses the value returned by the GetPK query to lookup the full product we inserted-->

<cfquery name="GetProduct" datasource="shoes">

    SELECT shoeID, manufactorID, brand, name, details, type, price, imageURL, color, size FROM shoe

    WHERE shoeID = #GetPK.MaxShoeID#

</cfquery>



<!---file upload--->

<cfif isdefined("form.imageURL")>

<cffile action="Upload"

filefield="imageURL"

destination="C:\Inetpub\wwwroot\soleshop"

nameconflict="makeunique"

accept="image/*">

<cfset upload_file= #file.serverfile#>

<cfoutput>#serverFile# successfully added. Size of the upload file:

#Numberformat(Evaluate(File.FileSize/1024))# KB. 

</cfoutput>

</cfif>

<cfinsert datasource="shoes"

tablename ="shoe"

formfields="imageURL">



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

</html>

Please help. Thanks!

March 1st, 2005, 08:32 PM

kiteless

Moderator

Join Date: Jun 2002

Location: Raleigh, NC

Posts: 3,627

Time spent in forums: 1 Week 4 Days 10 h 8 m 55 sec
Reputation Power: 53

Not sure about the error, but I strongly recommend NOT storing the image in the database. Store the image on the hard drive and store the PATH to the image in the database. CLOBS and BLOBS are always a real pain to work with, each driver and each database deal with them differently. Save yourself a lot of pain.

__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian.
How to Post a Question in the Forums

March 1st, 2005, 08:35 PM

perlnewbie23

Contributing User

Join Date: Oct 2004

Posts: 105

Time spent in forums: 4 h 41 sec
Reputation Power: 4

Quote:

Originally Posted by kiteless

How do I store the image path into the database?

March 2nd, 2005, 07:54 AM