Access Database info into Page

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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)
|/---------------------------------------------------
*----------------------------------------------------
 
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
Click to expand...
Click to expand...
 
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top