<cfquery datasource="test">
INSERT INTO Table
(vehicleType,modelYear,manufacturerName,vehicleDescription,uploadedFile)
VALUES
('#form.vehicleType#','#form.modelYear#','#form.manufacturerName#','#for
m.vehicleDescription#','#variables.uploadedFile#')
</cfquery>-----Original Message----- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: vrijdag 18 januari 2002 9:14 To: CF-Talk Subject: CFFILE/VARIABLES - Dumb Question No question is too dumb until you read below. I don't know if I am just having a brain fart or what, I am still new to CF but I should know this: I am uploading a file to my server using <CFFILE> then I want to write the location of the file to the database in this format: #cffile.ServerDirectory#/#cffile.serverFile# My current <CFINSERT>/<CFSET> looks like: <CFSET uploadedFile="#cffile.ServerDirectory#/#cffile.serverFile#"> <cfinsert datasource="test" TABLENAME="Table1" formFields= "vehicleType,modelYear,manufacturerName,vehicleDescription"> How do I get it to pull the value from my variable and put it into the database using <CFINSERT> or other method? Right now it is just inserting form values from the previous page. Any Suggestions? Thanks! Jim ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
