| Author |
 Topic  |
|
Kristen
Test
United Kingdom
22191 Posts |
 Posted - 07/28/2004 : 10:40:37
|
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 |
 |
|
|
largehotmail
Starting Member
12 Posts |
Posted - 07/29/2004 : 01:53:01
|
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?
 |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/29/2004 : 02:03:38
|
"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 |
|
|
|
largehotmail
Starting Member
12 Posts |
Posted - 07/29/2004 : 02:29:45
|
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 |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/29/2004 : 05:32:15
|
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 |
|
|
|
largehotmail
Starting Member
12 Posts |
Posted - 08/03/2004 : 02:15:35
|
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?
|
|
|
|
Lakeside
Starting Member
Nigeria
5 Posts |
|
|
orti7483
Starting Member
1 Posts |
Posted - 06/14/2006 : 15:19:38
|
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
|
|
|
|
Topic |
|
How to get Images or blobs into SQL table
Forum Locked
