Adding cfqueryparam to the insert statement solved my problem for me. <CFQUERYPARAM value="#theFileName#" cfsqltype="CF_SQL_CHAR">
Now... I'm off to figure out the rest of <cffile ... Thanks Brook... you got me looking deeper. At 05:45 PM 10/2/02, you wrote: >Sorry, re read this and I don't think wat your are trying to do is >possible. The file IS uploaded as soon as you submit the form to the >tempfile location you show below. Nothing you can do about that.... > >At 05:08 PM 02/10/02 -0700, you wrote: >>Using the type=file attribute on an <input> to a form >> >>I browse to this: >>\\YREKA\yreka.root\var\www\html\af\images\explode.gif >> >>When I submit the form it ends up saving the Form<input string to the >>database like this: >>\YREKAyreka.rootvarwwwhtmlafimagesexplode.gif >> >>It strips out all the \ except for the double one. >>Could this be an effect of <cf_formurl2attributes> ?? >> >>Anyway... >>So I add enctype="multipart/form-data" to the <form tag> >> >>Now I get this in the database: >>/home/coldfusionmx/runtime/servers/default/SERVER-INF/temp/wwwroot-tmp/neot >>mp20506.tmp >> >>Whats that??? looks like a temp storage location that CF might want to use >>while the file uploads??? HOWEVER, all I am doing at the moment is Naming >>a file and trying to store the name... Later I will go get the file and >>Upload it. >> >>So I add enctype="text/plain" to the <form tag> >>And it throws me to my login page... seems like it is blowing out all my >>client.variables which if the system sees takes the user straight to the >>LogIn page. >> >>------------ >>What I'm trying to do is ... simply browse to a file name... and then use >>that in a subsequent cffile upload.... but first I am saving the filename >>to a database... I will be turning that around once I can save the >>filename properly. >> >>Any pointers... or point me to where I can find this explained in more >>detail than I can find. It seems that trial and error is required because >>I really don't understand what I am reading. >> >>Thanks ;-( >>Brian >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
