BLOBs Images and Front Page

  • Thread starter Thread starter bfiser
  • Start date Start date
B

bfiser

Good morning everyone. I am creating a page using Front Page 2000 that
has a search form and then based on what is searched displays employee
information. One of the fields I'm trying to display is an image. I
get everything to return properly except the image field it shows up as
[#BINARY#]. Can anyone give me some advice on what I need to do to get
this to display right? Or point me in the direction of a website that
could help me out? If this is too vague please let me know and I can
clarify. Thanks in advance for any advice.
Ben
 
I appreciate the quick reply however I have a SQL Database. I was
browsing through this group and saw where it is recommended to not
access the images through this method but it appears to be my only
option as far as I know. I hope this updated information will help
lead me to a proper solution.
Thanks,
Ben

How to display a picture by using an Access database in FrontPage 2000
http://support.microsoft.com/kb/216285

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


Good morning everyone. I am creating a page using Front Page 2000 that
has a search form and then based on what is searched displays employee
information. One of the fields I'm trying to display is an image. I
get everything to return properly except the image field it shows up as
[#BINARY#]. Can anyone give me some advice on what I need to do to get
this to display right? Or point me in the direction of a website that
could help me out? If this is too vague please let me know and I can
clarify. Thanks in advance for any advice.
Ben
Click to expand...
Click to expand...
 
See
http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
for more information about why it's not a good idea to store information in
a database this way.

You're better off putting the images in a folder on your site and then
creating a field in your database that just holds the path to the image and
then build the <img> tag using the path results from the database. Ex: <img
src = "<%=rs("IMAGEPATH")%>



I appreciate the quick reply however I have a SQL Database. I was
browsing through this group and saw where it is recommended to not
access the images through this method but it appears to be my only
option as far as I know. I hope this updated information will help
lead me to a proper solution.
Thanks,
Ben

How to display a picture by using an Access database in FrontPage 2000
http://support.microsoft.com/kb/216285

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


Good morning everyone. I am creating a page using Front Page 2000 that
has a search form and then based on what is searched displays employee
information. One of the fields I'm trying to display is an image. I
get everything to return properly except the image field it shows up as
[#BINARY#]. Can anyone give me some advice on what I need to do to get
this to display right? Or point me in the direction of a website that
could help me out? If this is too vague please let me know and I can
clarify. Thanks in advance for any advice.
Ben
Click to expand...
Click to expand...
Click to expand...
 
I agree, however my problem is my company is using a software program
to create ID cards and the images as well as employee information go
into this SQL database. I was given an assignment by my boss to use
this database and the data it holds to create a search page for
employees to then have their generic information and data displayed.
The images by default get stored in the database and when I was talking
about storing them elsewhere was told it is not an option. Thanks for
the response though, I guess I will just keep plugging away.
Thanks,
Ben

David said:
See
http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
for more information about why it's not a good idea to store information in
a database this way.

You're better off putting the images in a folder on your site and then
creating a field in your database that just holds the path to the image and
then build the <img> tag using the path results from the database. Ex: <img
src = "<%=rs("IMAGEPATH")%>



I appreciate the quick reply however I have a SQL Database. I was
browsing through this group and saw where it is recommended to not
access the images through this method but it appears to be my only
option as far as I know. I hope this updated information will help
lead me to a proper solution.
Thanks,
Ben

How to display a picture by using an Access database in FrontPage 2000
http://support.microsoft.com/kb/216285

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


Good morning everyone. I am creating a page using Front Page 2000 that
has a search form and then based on what is searched displays employee
information. One of the fields I'm trying to display is an image. I
get everything to return properly except the image field it shows up as
[#BINARY#]. Can anyone give me some advice on what I need to do to get
this to display right? Or point me in the direction of a website that
could help me out? If this is too vague please let me know and I can
clarify. Thanks in advance for any advice.
Ben
Click to expand...
Click to expand...
Click to expand...
 
In your IE Address bar type:

? Displaying BLOBs Images from MS SQL

then hit Enter

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================


I agree, however my problem is my company is using a software program
to create ID cards and the images as well as employee information go
into this SQL database. I was given an assignment by my boss to use
this database and the data it holds to create a search page for
employees to then have their generic information and data displayed.
The images by default get stored in the database and when I was talking
about storing them elsewhere was told it is not an option. Thanks for
the response though, I guess I will just keep plugging away.
Thanks,
Ben

David said:
See
http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
for more information about why it's not a good idea to store information in
a database this way.

You're better off putting the images in a folder on your site and then
creating a field in your database that just holds the path to the image and
then build the <img> tag using the path results from the database. Ex: <img
src = "<%=rs("IMAGEPATH")%>



I appreciate the quick reply however I have a SQL Database. I was
browsing through this group and saw where it is recommended to not
access the images through this method but it appears to be my only
option as far as I know. I hope this updated information will help
lead me to a proper solution.
Thanks,
Ben


Kathleen Anderson [MVP - FrontPage] wrote:
How to display a picture by using an Access database in FrontPage 2000
http://support.microsoft.com/kb/216285

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


Good morning everyone. I am creating a page using Front Page 2000 that
has a search form and then based on what is searched displays employee
information. One of the fields I'm trying to display is an image. I
get everything to return properly except the image field it shows up as
[#BINARY#]. Can anyone give me some advice on what I need to do to get
this to display right? Or point me in the direction of a website that
could help me out? If this is too vague please let me know and I can
clarify. Thanks in advance for any advice.
Ben
Click to expand...
Click to expand...
Click to expand...
 
Back
Top