Uploading Images along with Form Information

jasonkeller · May 29, 2001

I am currently writing a coldfusion with access database web site. I am using a form and then posting that form information to another page for processing that contains an CFINSERT for all the info inserted into the database. It works fine.

Is it possible to use along with the CFINSERT, a <cffile action="UPLOAD" filefield="picture"
destination="d:" nameconflict="MAKEUNIQUE"> to tag along with the form information a large and thumbnail image?

I have the database generating an autonumber for every new entry from the form.

RTDesi · May 30, 2001

Yeah, its completely possible. Its pretty easy :

<cftransaction>

<CFQUERY NAME="whatever" DATASOURCE="your_dsn">
<cffile action="UPLOAD"
filefield="picture"
destination="d:"
nameconflict="MAKEUNIQUE">

INSERT INTO your_table_name (NAME,SUBJECT,DESCRIPTION,FILE)
'these are your field names in the database
values ('#txtName#','#txtSubject#','#txtDesc#','#File.ServerFile#')
'these are the names of your textboxes on the form itself
'File.ServerFile is what CF uses as the name of the saved file
</cfquery>
</cftransaction>

That should work.

jasonkeller · May 30, 2001

I am receiving a CFFILE error now. I am kinda getting it but still unsure where to put the cftransaction tag.
Below is a small piece of my form and my processing page which returns the user back to an admin screen where I query the database for all the inputs.

After the info is input by the user it goes to a processinfo page and I think this is where my problem is. Do I need that extra page?

form.cfm
------------------------------------------------------------
<form action="processinfo.cfm" method="POST">

<FONT FACE="Arial" size=2><B>Add / Change:</B></FONT><BR>
<input name="picture" type="file" size="20">br>

<table align=center>
<tr>
<td><FONT FACE="Arial" SIZE=2>Product Code/ID</FONT></td>
<td><input type="Text" name="product_id"></td>
</tr>
<tr>
<td><FONT FACE="Arial" SIZE=2>Product Name</FONT></td>
<td><input type="Text" name="product_name"></td>
</tr>
</table>
<input type="Submit" value="Save New Product">
</form>
------------------------------------------------------------

processinfo.cfm
"This is my complete processing form-the values are not all listed above as they are below"
------------------------------------------------------------
<cftransaction>

<CFQUERY DATASOURCE="mjgrant">

INSERT INTO products

(file,product_id,product_name,category,subcategory,price,size,setup_cost,minorder,description,colors)

VALUES

('#form.colors#','#form.description#','#form.minorder#','#form.setup_cost#','#form.size#','#form.rpice#','#form.subcategory#','#form.product_id#','#form.product_name#','#form.category#','#File.ServerFile#')

</CFQUERY>

</cftransaction>

<HTML>
<HEAD>
<TITLE></TITLE>
<meta http-equiv="refresh" content="1;url=admin_secure.cfm">
</HEAD>

<BODY>
<CENTER><FONT COLOR=black FACE="Arial"><h2>Adding new info. . .Please Wait</h2></FONT></CENTER>

</BODY>
</HTML>

RTDesi · May 30, 2001

Aight, try doing this. First of all in your form tag :

<form ENCTYPE="MULTIPART/FORM-DATA" action="processinfo.cfm" method="POST">

And as far as the <cftransaction> tag goes, it looks fine as is. Try fixing that form issue and see if that works.

RTDesi · May 31, 2001

Also, since your form isn't on the same page, take the 'form.' out of your variables. For example, instead of
'#form.colors#','#form.description#', try just #colors#, #description#, etc

jasonkeller · Jun 1, 2001

Ok, I have tried them all and I am still getting some errors.

Here is my link to the site:

http://66.70.25.16/index.cfm

Look towards the bottom...there is an "Administration Login"
Click there. login is "mjgrant" password is "grantpassword" and click on Add New

Check it out if it helps. Here is a shorter version with 3 inputs and image and two text inputs.

form.cfm
------------------------------------------------------------
<form action="processinfo.cfm" method="POST">

<FONT FACE="Arial" size=2><B>Add / Change:</B></FONT><BR>
<input name="mainpicture_id" type="file" size="20">br>

<table align=center>
<tr>
<td><FONT FACE="Arial" SIZE=2>Product Code/ID</FONT></td>
<td><input type="Text" name="product_id"></td>
</tr>
<tr>
<td><FONT FACE="Arial" SIZE=2>Product Name</FONT></td>
<td><input type="Text" name="product_name"></td>
</tr>
</table>
<input type="Submit" value="Save New Product">
</form>
------------------------------------------------------------

processinfo.cfm
"This is my complete processing form-the values are not all listed above as they are below"
------------------------------------------------------------
<cftransaction>

<CFQUERY DATASOURCE="mjgrant">

INSERT INTO products

(product_id,product_name,mainpicture_id)

VALUES

('#form.product_id#','#form.product_name#','#File.ServerFile#')

</CFQUERY>

</cftransaction>

<HTML>
<HEAD>
<TITLE></TITLE>
<meta http-equiv="refresh" content="1;url=admin_secure.cfm">
</HEAD>

<BODY>
<CENTER><FONT COLOR=black FACE="Arial"><h2>Adding new info. . .Please Wait</h2></FONT></CENTER>

</BODY>
</HTML>

jasonkeller · Jun 1, 2001

Never mind my last post, I have it working.

Next question is???

How to I input 2 images like a mainpicture and a thumbnail picture?

dallasweb · Sep 11, 2001

This tag maybe a solution for you. Autoresize.cfm. Upload an image and it will create your thumbnail for you....otherwise you need two file upload fields.

GL

http://devex.allaire.com/developer/...3475C6-2830-11D4-AA9700508B94F380&method=Full

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Uploading Images along with Form Information

jasonkeller

Programmer

RTDesi

MIS

jasonkeller

Programmer

RTDesi

MIS

RTDesi

MIS

jasonkeller

Programmer

jasonkeller

Programmer

dallasweb

Programmer

Similar threads

Part and Inventory Search

Sponsor