[thelist] CFinsert,update,input=file

[Chris Evans]

Don't use CFINSERT or CFUPDATE.  In my opionion, never use CFINSERT or
CFUDATE, use CFQUERY and write the SQL yourself.  SQL is easy to learn, and
the flexibility of using CFQUERY far overrules any benefits of using
CFINSERT or CFUPDATE.

That said, if you want to upload a file and store the filename in the
database, use something like this:

<cffile action="UPLOAD" filefield="form.fieldname" destination="destination
path" nameconflict="ERROR">
<CFQUERY Name="INsertFile" Datasource="DSN">
INSERT into MyTable
(Filename)
VALUES
('#ServerFile#')
</CFQUERY>



Chris Evans
chris at fuseware.com
http://www.fuseware.com

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Palyne Gaenir
Sent: Tuesday, July 18, 2000 10:52 PM
To: Thelist at lists.evolt.org
Subject: [thelist] CFinsert,update,input=file


Hi gurus,
Can you use cfinsert and cfupdate when one of the form fields is for
the upload of a file?  How would you do that if so, just put the
cffile tag under the cfinsert/update tag?  It won't try to put the
whole 'file' in the table column, will it -- just the filename?  I'm
afraid of really messing something up by experimenting with this
particular (cffile) tag so I'm hoping someone just knows the answer.
By the way in a month or so I intend to make a big 'ol library of
stuff I've been collecting and making (scripts and solutions) and
I'll post it to Evolt.org, to hopefully make a dent in the tip
tithing I owe lately!
Regards,
Palyne





---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !