Skip to main content
Participating Frequently
April 26, 2010
Question

Can I update database by uploading files to a directory?

  • April 26, 2010
  • 1 reply
  • 314 views

Hello, everyone.

I was wondering whether it would be possible to upload files to a directory on the server and have a database update itself based on that.

Specifically, I would like to upload images to a directory and have that action create new entries in a table in a database.

I am guessing I could update the database at the same time that I'm uploading files (with something like cffile, for instance), but I was wondering whether there might exist a more elegant solution.

I've tried to look up information using Google, but I think I'm not even asking the question right, because nothing that comes up is even remotely useful.

Thank you,

A  noob

    This topic has been closed for replies.

    1 reply

    ilssac
    Inspiring
    April 26, 2010

    Check into the ColdFusion Gateway technology.

    A gateway is ColdFusion code in a component that can be set to run on various triggers, such as the receiving of a SMS message or changes to a directory amoung many others.

    https://www.adobe.com/livedocs/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00001649.htm

    http://livedocs.adobe.com/coldfusion/8/htmldocs/UseGateways_9.html

    http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-77f7.html

    http://coldfusion.sys-con.com/node/317586