|
 |
asp_databases thread: get image object from oracle db
Message #1 by "Akhsanun Niam" <akhsanun.NIAM@t...> on Thu, 19 Jul 2001 09:56:24
|
|
Dear friends,
I am trying to get data from oracle in my asp pages.
Could anyone help me out how to query & get image data type from table in
ORACLE databases.
The data structure is shown below (for example):
TABLE EMPLOYEE
(SERIALNUMBER INTEGER,
PHOTO LONG)
The PHOTO field holds the image data type.
Many Thanks
niam
Message #2 by "JOHN P. PARLATO" <jparlato@m...> on Thu, 19 Jul 2001 07:43:29 -0700
|
|
you realy should place the image in a file, then a pointer(or name of the
file) in your oracle data base. You going to find that images in the data
base are not easily maintained and are in-efficient.
-----Original Message-----
From: Akhsanun Niam [mailto:akhsanun.NIAM@t...]
Sent: Thursday, July 19, 2001 9:56 AM
To: ASP Databases
Subject: [asp_databases] get image object from oracle db
Dear friends,
I am trying to get data from oracle in my asp pages.
Could anyone help me out how to query & get image data type from table in
ORACLE databases.
The data structure is shown below (for example):
TABLE EMPLOYEE
(SERIALNUMBER INTEGER,
PHOTO LONG)
The PHOTO field holds the image data type.
Many Thanks
niam
---
Message #3 by "swapna ankireddy" <swapnaankireddy@y...> on Fri, 20 Jul 2001 07:40:23
|
|
Hi,
Why don't u use 'blob' data type to store the photo.
Message #4 by Greg Griffiths <griffiths@x...> on Thu, 19 Jul 2001 21:48:31 +0100
|
|
Many of us just store the URL to the picture in the database and store the
actual image outside in a normal folder.
At 09:56 19/07/01 +0000, you wrote:
>Dear friends,
>
>I am trying to get data from oracle in my asp pages.
>
>Could anyone help me out how to query & get image data type from table in
>ORACLE databases.
>The data structure is shown below (for example):
>
>TABLE EMPLOYEE
>(SERIALNUMBER INTEGER,
>PHOTO LONG)
>
>The PHOTO field holds the image data type.
>
>Many Thanks
>niam
|
|
|
View Cart
