3 Replies Latest reply on Nov 17, 2006 10:22 AM by Newsgroup_User

    Upload File Insert into Database

    ssailer Level 1
      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!
        • 1. Re: Upload File Insert into Database
          Level 7
          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.
          • 2. Re: Upload File Insert into Database
            ssailer Level 1
            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...
            • 3. Re: Upload File Insert into Database
              Level 7
              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?