4 Replies Latest reply on Jan 8, 2009 10:30 AM by ProWebService

    Storing Uploaded Audio Files in Your Database

      I have been using the cffile tag to upload files into a directory on the server and then writing the details of that file into a database, but I would like to now instead of uploading and writing the file to a directory, I would like to write that file into a field of a database table and then call it out later to listen to it or view it.

      Does anyone have any experience with writing a file into a database along with it's file details and then code to read it out and display the file details and view or listen to the file?

      I'm guessing that I would need a field in the database table that is a byte array, data type "image" to hold the file and then the other fields would be "type" "varchar" to hold the details of the file.

      MySQL or SQL Server are my choices of databases.

      Thank you!