upload .avi files using coldfusion?

need to pass info into database.

Page 1 of 1

7 Replies - 8240 Views - Last Post: 01 May 2006 - 04:56 PM Rate Topic: -----

#1 chipshot  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 38
  • Joined: 30-April 06

upload .avi files using coldfusion?

Posted 01 May 2006 - 08:27 AM

Is it possible to be able to upload 8-12MB .avi clips to a database along with UserID, description, and DateUploaded to the Database?
I'm currently using MS Access on a testing server but plan on migrating to MySql once the site is completed.
Thank You ...
Chipshot
johnandon@hvc.rr.com
Is This A Good Question/Topic? 0
  • +

Replies To: upload .avi files using coldfusion?

#2 skyhawk133  Icon User is offline

  • Head DIC Head
  • member icon

Reputation: 1868
  • View blog
  • Posts: 20,280
  • Joined: 17-March 01

Re: upload .avi files using coldfusion?

Posted 01 May 2006 - 08:58 AM

I believe it is possible to upload any binary file to a database using ColdFusion... but why do you want to store the videos in a database? Storing large binary files in any database will ultimatley lead to database bloat and application slow down.

It's far better to store the videos on the filesystem and store the filename in the database.
Was This Post Helpful? 0
  • +
  • -

#3 chipshot  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 38
  • Joined: 30-April 06

Re: upload .avi files using coldfusion?

Posted 01 May 2006 - 09:31 AM

Thanks for the quick reply skyhawk133

It's far better to store the videos on the filesystem and store the filename in the database....

If I store the filename it should be possible for both admin's and users to view the clips by linking from the database? (right should work)!!

Do you know of any tutorials on the subject, I'm a total newbee.

Thanks,
Chipshot
Was This Post Helpful? 0
  • +
  • -

#4 skyhawk133  Icon User is offline

  • Head DIC Head
  • member icon

Reputation: 1868
  • View blog
  • Posts: 20,280
  • Joined: 17-March 01

Re: upload .avi files using coldfusion?

Posted 01 May 2006 - 10:12 AM

I'm not sure exactly what you mean by admins and users.

Could you explain what you were trying to accomplish by storing the videos in the database?

You can use the <cffile action=upload... to upload files from a form.

Here is some code from the CF documentation:
<!--- Windows Example --->
<!--- Check to see if the Form variable exists --->
<cfif isDefined("Form.FileContents") >
<!--- If TRUE then upload the file --->
<cffile action = "upload"
fileField = "FileContents"
destination = "c:\files\upload\"
nameConflict = "MakeUnique">
<cfelse>
<!--- If FALSE then show the Form --->
<form method="post" action=<cfoutput>#cgi.script_name#</cfoutput> name="uploadForm" enctype="multipart/form-data">
<input name="FileContents" type="file">
<br>
<input name="submit" type="submit" value="Upload File">
</form>
</cfif>


When you run a cffile tag, there are a bunch of attributes that are available. Specifically, you could run a cfquery to insert #cffile.serverFile# in to your table, this will store the filename as it appears on the server.

Let me know if this makes sense.
Was This Post Helpful? 0
  • +
  • -

#5 chipshot  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 38
  • Joined: 30-April 06

Re: upload .avi files using coldfusion?

Posted 01 May 2006 - 02:12 PM

yes that makes sense I hav'nt had a chance to try it yet. But what I am trying to accomplish is to allow a site member to upload a video file of a golf swing.
Have an admin open the file to view and add a video analysis to the file with all the x's and o's and voice-over comments. Send out an e-mail to the user that their file is ready to view the video lesson. with their username and password.

Does that make sense?
check out further explanation at http://www.finaltouc...eoanalysis.html

That's the site I have up currently I'm in the process of rediong the site.

Thank You,
Chipshot

P.S. I'm a golf pro/ trying to be a web designer.
Was This Post Helpful? 0
  • +
  • -

#6 supersloth  Icon User is offline

  • serial frotteur - RUDEST MEMBER ON D.I.C.
  • member icon


Reputation: 4503
  • View blog
  • Posts: 28,409
  • Joined: 21-March 01

Re: upload .avi files using coldfusion?

Posted 01 May 2006 - 02:46 PM

so are you trying to develop the tools to enable them to add the tips, or just trying to create the process to enable them to download the movie, edit it, and upload it again?
Was This Post Helpful? 0
  • +
  • -

#7 chipshot  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 38
  • Joined: 30-April 06

Re: upload .avi files using coldfusion?

Posted 01 May 2006 - 03:04 PM

trying to create the process to enable them to download the movie, edit it, and upload it again?
Was This Post Helpful? 0
  • +
  • -

#8 supersloth  Icon User is offline

  • serial frotteur - RUDEST MEMBER ON D.I.C.
  • member icon


Reputation: 4503
  • View blog
  • Posts: 28,409
  • Joined: 21-March 01

Re: upload .avi files using coldfusion?

Posted 01 May 2006 - 04:56 PM

well the process i would apply based on what your saying is this:

upload the file
rename it
save it
make record in database of location
link the user to edit so he can download the file
let them change it
reupload it in different 'final' directory
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1