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 !