SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 How to get Images or blobs into SQL table
 Forum Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Kristen
Test

United Kingdom
22403 Posts

Posted - 07/28/2004 :  10:40:37  Show Profile
Its another muddle.

There is some issue with doing an UPLOAD and transferring any other form fields at the same time - I think they need to happen as two separate "posts", which is a pain if you want a user to provide a path/filename for upload AND, say, a description etc. at the same time.

There are also file permission issues on the server. If you grant WRITE permissions to the user then that helps them if they want to hack in ... or upload PORN.MPG and tell all their friends its now on your server ...

We use Software Artisans tools for this. This lets us adjust the file permissions on a just-in-time basis. It also makes file upload easier. And it can tell you the Height / Width of image files an so on. It behaves as a replacement for the System File Object.

Kristen
Go to Top of Page

largehotmail
Starting Member

12 Posts

Posted - 07/29/2004 :  01:53:01  Show Profile
quote:
Originally posted by Kristen

Its another muddle.

There is some issue with doing an UPLOAD and transferring any other form fields at the same time - I think they need to happen as two separate "posts", which is a pain if you want a user to provide a path/filename for upload AND, say, a description etc. at the same time.

There are also file permission issues on the server. If you grant WRITE permissions to the user then that helps them if they want to hack in ... or upload PORN.MPG and tell all their friends its now on your server ...

We use Software Artisans tools for this. This lets us adjust the file permissions on a just-in-time basis. It also makes file upload easier. And it can tell you the Height / Width of image files an so on. It behaves as a replacement for the System File Object.

Kristen



After it was uploaded, it would need to be reviewed before being available to the public.

Can you give me the link to find the software Artisans tools? Using this tool, what do I need to learn to make this happen?
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 07/29/2004 :  02:03:38  Show Profile
"it would need to be reviewed before being available to the public"

We do this by putting it into a holding holder, and then when the reviewer marks it as OK the file is moved to the "live" folder.

"Can you give me the link to find the software Artisans tools?"

Come on, give me a break:

http://www.google.com/search?q=software+artisans

Kristen
Go to Top of Page

largehotmail
Starting Member

12 Posts

Posted - 07/29/2004 :  02:29:45  Show Profile
quote:
Originally posted by Kristen

"it would need to be reviewed before being available to the public"

We do this by putting it into a holding holder, and then when the reviewer marks it as OK the file is moved to the "live" folder.

"Can you give me the link to find the software Artisans tools?"

Come on, give me a break:

http://www.google.com/search?q=software+artisans


Kristen



Sorry about that!

SoftArtisans FileUp Standard is this the one?

What exactly is this product? I sorry I'm new at this! I've been playing around with SQL off and on for a year now. What is the SQL team, are you from Microsoft??

FileUpEE 3-Tier Database Upload Sample
Enter Filename:
Enter file comments:

--------------------------------------------------------------------------------

Enter Filename:
Enter file comments:

--------------------------------------------------------------------------------

Enter Filename:
Enter file comments:

--------------------------------------------------------------------------------






Edited by - largehotmail on 07/29/2004 02:34:52
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 07/29/2004 :  05:32:15  Show Profile
Its a COM object that you can build into your application.

The one we use (File manager I think) replaces the System File Object with a richer set of (more secure) commands.

I think it also includes Put/Get Blobs into databases.

And they also do fancy stuff for file upload, but I don't know whether you need that. I know we had a bear of a time developing our file upload routine, and I think it was all to do with trying to get some data off the same web form IN ADDITION TO the Filename to be uploaded. But that's about all I know I'm afraid.

Kristen
Go to Top of Page

largehotmail
Starting Member

12 Posts

Posted - 08/03/2004 :  02:15:35  Show Profile
quote:
Originally posted by Kristen

We looked at storing images in the database for our web application.

Also, nothing downstream was going to cache the image - not the user's browser; not the user's ISP. So we decided that would place an unnecessary burden on our servers and ditched the idea in favour of storing on the disk.

Kristen



Well, I'm using Web Assistant in Enterprise manager it can easily be setup to send once, time interval, etc.. . My point is it’s stored as html on the web server, and does not need to be constantly refreshed except as a web page. You mention that the image needs to be in cashe, why would you need that, it’s stored as html?

Go to Top of Page

Lakeside
Starting Member

Nigeria
5 Posts

Posted - 07/12/2005 :  10:10:18  Show Profile
If you are doing ASP or Coldfusion person you could try the link below;
http://www.chestysoft.com/imagefile/default.asp

Go to Top of Page

orti7483
Starting Member

1 Posts

Posted - 06/14/2006 :  15:19:38  Show Profile
Can you please send details on the trick to #1, textcopy please!

quote:
Originally posted by largehotmail

I know of two methods.

1. Textcopy - Not easy to use, but works. There a trick to it! Can not move image into database unless you do something first!

2. A super program that I'm currently using that can transfer any format. Example: Pictures, movies, almost anything

3. Looking for third methed, and forth

Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000