Access Database info into Page

G

Guest

Hello,

I am attempting to add a database to one of my pages. I created a very
simple database which displays Label Name and Label Picture. I choose to
insert the pictures using the insert/OLE Object function in access. I
browsed my desktop and inserted the image. I uploaded the page to my site
and the two test names appeared, but the pictures did not. Instead of
pictures the following was dispalyed [#BINARY#]. I then tried to move the
pictures into my images folder and still had the same issues. What is the
best way to fix this problem?

Thank you,
Sam
 
G

Guest

Don't put the pictures in the database. Upload the pictures as files, and put
the *file names* in the database.

To make the Database Results Wizard display the pictures, set up a custom
query that begins like this:

SELECT '<img src="'images/&[picfilename]&'">' as pictag, ...

and report the pictag field. Then, when the DRW conmpletes, right-click
<<pictag>>, choose Database Column Value Properties, and select Column Value
Contains HTML.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
G

Guest

OK,

That worked great! Now I have another questions. I ultimately want to have
a page that list the alphabet across the top. Each letter would be a
hyperlink that would lead to a list of llabel names associated with pictures.
I obviously don't want to make 26 different queries to cover the alphabet.
Is there a way to make one query that will cover the entire alphabet on one
page? If you have further questions let me know.

Thank you,
Sam

Jim Buyens said:
Don't put the pictures in the database. Upload the pictures as files, and put
the *file names* in the database.

To make the Database Results Wizard display the pictures, set up a custom
query that begins like this:

SELECT '<img src="'images/&[picfilename]&'">' as pictag, ...

and report the pictag field. Then, when the DRW conmpletes, right-click
<<pictag>>, choose Database Column Value Properties, and select Column Value
Contains HTML.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


Sam B. said:
Hello,

I am attempting to add a database to one of my pages. I created a very
simple database which displays Label Name and Label Picture. I choose to
insert the pictures using the insert/OLE Object function in access. I
browsed my desktop and inserted the image. I uploaded the page to my site
and the two test names appeared, but the pictures did not. Instead of
pictures the following was dispalyed [#BINARY#]. I then tried to move the
pictures into my images folder and still had the same issues. What is the
best way to fix this problem?

Thank you,
Sam
 
G

Guest

Link each picture to a URL like ?pfx=A. For example:

<a href="?pfx=A">A</a>

Then, add a clause like this to your custom SQL statement:

WHERE Iif('::pfx::'='',Left([LabelName],1)='A',Left([LabelName],1)='::pfx::'))

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


Sam B. said:
OK,

That worked great! Now I have another questions. I ultimately want to have
a page that list the alphabet across the top. Each letter would be a
hyperlink that would lead to a list of llabel names associated with pictures.
I obviously don't want to make 26 different queries to cover the alphabet.
Is there a way to make one query that will cover the entire alphabet on one
page? If you have further questions let me know.

Thank you,
Sam

Jim Buyens said:
Don't put the pictures in the database. Upload the pictures as files, and put
the *file names* in the database.

To make the Database Results Wizard display the pictures, set up a custom
query that begins like this:

SELECT '<img src="'images/&[picfilename]&'">' as pictag, ...

and report the pictag field. Then, when the DRW conmpletes, right-click
<<pictag>>, choose Database Column Value Properties, and select Column Value
Contains HTML.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


Sam B. said:
Hello,

I am attempting to add a database to one of my pages. I created a very
simple database which displays Label Name and Label Picture. I choose to
insert the pictures using the insert/OLE Object function in access. I
browsed my desktop and inserted the image. I uploaded the page to my site
and the two test names appeared, but the pictures did not. Instead of
pictures the following was dispalyed [#BINARY#]. I then tried to move the
pictures into my images folder and still had the same issues. What is the
best way to fix this problem?

Thank you,
Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top