Upload File Insert into Database

[ssailer]

Okay - I have seen numerous posts on similar subjects in the forum, but no one has addressed this topic exactly - Is there a wizard or 3rd party tag out there that will upload a file AND insert it into a database field at the same time? I have used the file upload tag by Interakt Online, but I do not like it. I do not like it because you must create a form using their program and every element must interact with their form. It's flaky at best and I've had a lot of trouble even getting it to work. Does anybody have anything else that they use that does NOT need to be installed on a web server and alter the registry? The ISPs that I work with will not allow the registry to be edited in any way. I am so frustrated and I can't believe that Macromedia/Adobe didn't think it was important to include the ability to do this with ColdFusion. Thank you to whoever responds!

[Newsgroup_User]

I can't believe that Macromedia/Adobe didn't think it was important to
include the ability to do this with ColdFusion.


Ummm what are you trying to do that is so difficult?

<form...>
<input type="file"...>
</form>


<cffile action="upload" ...>


<cfquery ...>
INSERT INTO ....
(#cffile.serverFile#, ...)
<cfquery>

I do stuff like this all the time and no third party or registry
funkiness required. I've been doing it with ColdFusion's built in
capabilities since CF4.5 days under Allaire.

[ssailer]

I'm just tired of having to go in behind the scenes and code for it manually each and evey time a file is uploaded and the record is either updated or a new record is added. I'm looking for a way to to automate this process to save time...

[Newsgroup_User]

I'm looking for a way to to automate this process to save
time...

I would think this is doable, but one would need to know more about
"this process" if one is to give advice.

How are the files uploaded by whom? What data is recorded in the
database? What determines an update from an insert? Basically what is
the current process?