|
 |
asp_databases thread: How to insert a image into database from ASP?
Message #1 by "THTAM" <THTAM@l...> on Wed, 30 Aug 2000 12:23:05 +0100
|
|
Hi!
Could you help me, please?
How to insert a image into database from ASP?
Message #2 by Hari Yellina <hyellina@k...> on Wed, 30 Aug 2000 07:10:11 -0500
|
|
you cannot insert image directly. You can store it in a binary format. While
reading you have to read in binary format.
> ----------
> From: THTAM[SMTP:THTAM@l...]
> Sent: Wednesday, August 30, 2000 4:53 PM
> To: ASP Databases
> Subject: [asp_databases] How to insert a image into database from
> ASP?
>
>
> Hi!
> Could you help me, please?
> How to insert a image into database from ASP?
>
> ---
> You are currently subscribed to asp_databases
> $subst('Email.Unsub')
>
Message #3 by Chris Neale <Chris.Neale@s...> on Wed, 30 Aug 2000 13:55:26 +0100
|
|
Yay.. use Blobs.. blobs rock.. (a Blob is a 'Binary Large Object'..)
Essentially all you do is write a binary stream to your database table.
Theres plenty of Image Upload examples on the internet for this purpose.. (I
think theres one on ASPtoday that uses pure Vbscript, no plugins, components
etc. Thus no money..
Chris
Chaos! Panic! Disaster! (My work here is done)
Chris Neale. Web/Wap Developer
Chris.neale@s... <mailto:Chris.neale@s...>
www.sparkresponse.co.uk
-----Original Message-----
From: Hari Yellina
Sent: Wednesday, August 30, 2000 1:10 PM
To: ASP Databases
Subject: [asp_databases] RE: How to insert a image into
database from ASP?
you cannot insert image directly. You can store it in a binary
format. While
reading you have to read in binary format.
> ----------
> From: THTAM[SMTP:THTAM@l...]
> Sent: Wednesday, August 30, 2000 4:53 PM
> To: ASP Databases
> Subject: [asp_databases] How to insert a image into database
from
> ASP?
>
>
Message #4 by "JOHN P. PARLATO" <jparlato@m...> on Wed, 30 Aug 2000 20:58:59 -0700
|
|
Are you sure you want to do that? It might be better to send the image to a
file (saupload), then just put the file's name in the data base. Think
about it.
----- Original Message -----
From: THTAM <THTAM@l...>
To: ASP Databases <asp_databases@p...>
Sent: Wednesday, August 30, 2000 4:23 AM
Subject: [asp_databases] How to insert a image into database from ASP?
>
> Hi!
> Could you help me, please?
> How to insert a image into database from ASP?
>
> ---
> You are currently subscribed to asp_databases
$subst('Email.Unsub')
>
Message #5 by "Asmadi Ahmad" <chloro@e...> on Thu, 31 Aug 2000 17:03:40 +0800
|
|
Yup that is a better idea.
I have used Access to store images (BMP format) and the file size increased
very fast. You can imagine that out of 70Megs total file size, only
1.2Megs are actual data (text, string, numbers). Others are all image
binaries. That was despite scanning images at very low grayscale resolution
.
asmadi
www.effitech.com
----- Original Message -----
From: JOHN P. PARLATO
To: ASP Databases <asp_databases@p...>
Sent: Thursday, 31 August, 2000 11:58 AM
Subject: [asp_databases] Re: How to insert a image into database from ASP?
> Are you sure you want to do that? It might be better to send the image to
a
> file (saupload), then just put the file's name in the data base. Think
> about it.
> ----- Original Message -----
> From: THTAM <THTAM@l...>
> To: ASP Databases <asp_databases@p...>
> Sent: Wednesday, August 30, 2000 4:23 AM
> Subject: [asp_databases] How to insert a image into database from ASP?
>
>
> >
> > Hi!
> > Could you help me, please?
> > How to insert a image into database from ASP?
> >
Message #6 by Hari Yellina <hyellina@k...> on Thu, 31 Aug 2000 03:16:42 -0500
|
|
The answer below is correct. Because it will be more faster. You save lot of
database transaction. Ok.
> ----------
> From: JOHN P. PARLATO[SMTP:jparlato@m...]
> Sent: Thursday, August 31, 2000 9:28 AM
> To: ASP Databases
> Subject: [asp_databases] Re: How to insert a image into database from
> ASP?
>
> Are you sure you want to do that? It might be better to send the image to
> a
> file (saupload), then just put the file's name in the data base. Think
> about it.
> ----- Original Message -----
> From: THTAM <THTAM@l...>
> To: ASP Databases <asp_databases@p...>
> Sent: Wednesday, August 30, 2000 4:23 AM
> Subject: [asp_databases] How to insert a image into database from ASP?
>
>
> >
> > Hi!
> > Could you help me, please?
> > How to insert a image into database from ASP?
> >
> > ---
> > You are currently subscribed to asp_databases
> $subst('Email.Unsub')
> >
>
>
> ---
> You are currently subscribed to asp_databases
> $subst('Email.Unsub')
>
Message #7 by "Asmadi Ahmad" <chloro@e...> on Thu, 31 Aug 2000 17:03:40 +0800
|
|
Yup that is a better idea.
I have used Access to store images (BMP format) and the file size increased
very fast. You can imagine that out of 70Megs total file size, only
1.2Megs are actual data (text, string, numbers). Others are all image
binaries. That was despite scanning images at very low grayscale resolution
.
asmadi
www.effitech.com
----- Original Message -----
From: JOHN P. PARLATO <jparlato@m...>
To: ASP Databases <asp_databases@p...>
Sent: Thursday, 31 August, 2000 11:58 AM
Subject: [asp_databases] Re: How to insert a image into database from ASP?
> Are you sure you want to do that? It might be better to send the image to
a
> file (saupload), then just put the file's name in the data base. Think
> about it.
> ----- Original Message -----
> From: THTAM <THTAM@l...>
> To: ASP Databases <asp_databases@p...>
> Sent: Wednesday, August 30, 2000 4:23 AM
> Subject: [asp_databases] How to insert a image into database from ASP?
>
>
> >
> > Hi!
> > Could you help me, please?
> > How to insert a image into database from ASP?
> >
> > ---
> > You are currently subscribed to asp_databases
> $subst('Email.Unsub')
> >
>
>
> ---
> You are currently subscribed to asp_databases
$subst('Email.Unsub')
>
>
Message #8 by "Nick Middleweek" <nickm@t...> on Thu, 31 Aug 2000 10:38:33 +0000
|
|
Taking a step backwards,
What data type would one use to save a picture or Blob?
What would the SQL code be to save the data into the field?
Lets assume that I open a file and want to save it away!
I'm a little rusty on the FileSystem Object so that code would be
appreciated too!
Regards
Nick Middleweek
----------
> Are you sure you want to do that? It might be better to send the image to a
> file (saupload), then just put the file's name in the data base. Think
> about it.
|
|
|
View Cart
