How to set SQL 2000 and FP2003 DRW to view .doc and .pdf file

C

celarsen

How do I store the path to .doc & .pdf files in SQL 2000? I am trying to use

Frontpage 2003 DRW to create a result page displaying the doc or pdf file.

So far I have DRW displaying all the info need in the SQL database, but the
path for the doc & pdf files displays instead of the document.

Thank You

reply to: administrator(remove this)@lepinandrenehan.com
 
J

Jim Buyens

I presume you want the DRW to create a list of links to documents. If so,
code a custom query such as:

SELECT *, '<href="/PathToDocs/' & [docfilename] & '">' & [docdesc] & '</a>'
AS doclink, ...

and make sure you report the doclink field. When the wizard ends,
right-click the doclink column, choose Database Column Value Properties, and
select Column Value Contains HTML.

Jim Buyens
Microsoft 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)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
C

celarsen

No I do not want to create a list. I want the document to show up under the
rest of the data.
(xxxx = data from database)
xxxxx xxxxxxxxxxx xxxxxxxx xxxxxxxxxxx xxxxxxxxxx
document (not path) shows here
| |
| |
| |
| |
_____________________



Thank You,

Cory


Jim Buyens said:
I presume you want the DRW to create a list of links to documents. If so,
code a custom query such as:

SELECT *, '<href="/PathToDocs/' & [docfilename] & '">' & [docdesc] & '</a>'
AS doclink, ...

and make sure you report the doclink field. When the wizard ends,
right-click the doclink column, choose Database Column Value Properties, and
select Column Value Contains HTML.

Jim Buyens
Microsoft 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)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

celarsen said:
How do I store the path to .doc & .pdf files in SQL 2000? I am trying to use

Frontpage 2003 DRW to create a result page displaying the doc or pdf file.

So far I have DRW displaying all the info need in the SQL database, but the
path for the doc & pdf files displays instead of the document.

Thank You

reply to: administrator(remove this)@lepinandrenehan.com
 
T

Thomas A. Rowe

You would have to create link to the document in the database, then use the FileSystemObject to read
the document and then display the content on the page. This will require custom ASP/VBScript coding
or you could load the document in IFrame based on the link in the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

celarsen said:
No I do not want to create a list. I want the document to show up under the
rest of the data.
(xxxx = data from database)
xxxxx xxxxxxxxxxx xxxxxxxx xxxxxxxxxxx xxxxxxxxxx
document (not path) shows here
| |
| |
| |
| |
_____________________



Thank You,

Cory


Jim Buyens said:
I presume you want the DRW to create a list of links to documents. If so,
code a custom query such as:

SELECT *, '<href="/PathToDocs/' & [docfilename] & '">' & [docdesc] & '</a>'
AS doclink, ...

and make sure you report the doclink field. When the wizard ends,
right-click the doclink column, choose Database Column Value Properties, and
select Column Value Contains HTML.

Jim Buyens
Microsoft 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)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

celarsen said:
How do I store the path to .doc & .pdf files in SQL 2000? I am trying to use

Frontpage 2003 DRW to create a result page displaying the doc or pdf file.

So far I have DRW displaying all the info need in the SQL database, but the
path for the doc & pdf files displays instead of the document.

Thank You

reply to: administrator(remove this)@lepinandrenehan.com
 
C

celarsen

The Iframe appears the way to go.
How do I put the sql results into the iframe? the results return the full
path where the file is located.

Your help is greatly appreaciated.

Cory Larsen

______

Thomas A. Rowe said:
You would have to create link to the document in the database, then use the FileSystemObject to read
the document and then display the content on the page. This will require custom ASP/VBScript coding
or you could load the document in IFrame based on the link in the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

celarsen said:
No I do not want to create a list. I want the document to show up under the
rest of the data.
(xxxx = data from database)
xxxxx xxxxxxxxxxx xxxxxxxx xxxxxxxxxxx xxxxxxxxxx
document (not path) shows here
| |
| |
| |
| |
_____________________



Thank You,

Cory


Jim Buyens said:
I presume you want the DRW to create a list of links to documents. If so,
code a custom query such as:

SELECT *, '<href="/PathToDocs/' & [docfilename] & '">' & [docdesc] & '</a>'
AS doclink, ...

and make sure you report the doclink field. When the wizard ends,
right-click the doclink column, choose Database Column Value Properties, and
select Column Value Contains HTML.

Jim Buyens
Microsoft 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)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

:

How do I store the path to .doc & .pdf files in SQL 2000? I am trying to use

Frontpage 2003 DRW to create a result page displaying the doc or pdf file.

So far I have DRW displaying all the info need in the SQL database, but the
path for the doc & pdf files displays instead of the document.

Thank You

reply to: administrator(remove this)@lepinandrenehan.com
 
T

Thomas A. Rowe

You have to have page with the SQL statement already loaded in the IFrame.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

celarsen said:
The Iframe appears the way to go.
How do I put the sql results into the iframe? the results return the full
path where the file is located.

Your help is greatly appreaciated.

Cory Larsen

______

Thomas A. Rowe said:
You would have to create link to the document in the database, then use the FileSystemObject to
read
the document and then display the content on the page. This will require custom ASP/VBScript
coding
or you could load the document in IFrame based on the link in the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

celarsen said:
No I do not want to create a list. I want the document to show up under the
rest of the data.
(xxxx = data from database)
xxxxx xxxxxxxxxxx xxxxxxxx xxxxxxxxxxx xxxxxxxxxx
document (not path) shows here
| |
| |
| |
| |
_____________________



Thank You,

Cory


:

I presume you want the DRW to create a list of links to documents. If so,
code a custom query such as:

SELECT *, '<href="/PathToDocs/' & [docfilename] & '">' & [docdesc] & '</a>'
AS doclink, ...

and make sure you report the doclink field. When the wizard ends,
right-click the doclink column, choose Database Column Value Properties, and
select Column Value Contains HTML.

Jim Buyens
Microsoft 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)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

:

How do I store the path to .doc & .pdf files in SQL 2000? I am trying to use

Frontpage 2003 DRW to create a result page displaying the doc or pdf file.

So far I have DRW displaying all the info need in the SQL database, but the
path for the doc & pdf files displays instead of the document.

Thank You

reply to: administrator(remove this)@lepinandrenehan.com
 
J

Jim Buyens

Well then, in

SELECT *, '<href="/PathToDocs/' & [docfilename] & '">' & [docdesc] & '</a>'
AS doclink, ...

change '<href="/PathToDocs/' & [docfilename] & '">' & [docdesc] & '</a>' to
whatever pile of HTML you want.

Jim Buyens
Microsoft 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)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

celarsen said:
No I do not want to create a list. I want the document to show up under the
rest of the data.
(xxxx = data from database)
xxxxx xxxxxxxxxxx xxxxxxxx xxxxxxxxxxx xxxxxxxxxx
document (not path) shows here
| |
| |
| |
| |
_____________________



Thank You,

Cory


Jim Buyens said:
I presume you want the DRW to create a list of links to documents. If so,
code a custom query such as:

SELECT *, '<href="/PathToDocs/' & [docfilename] & '">' & [docdesc] & '</a>'
AS doclink, ...

and make sure you report the doclink field. When the wizard ends,
right-click the doclink column, choose Database Column Value Properties, and
select Column Value Contains HTML.

Jim Buyens
Microsoft 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)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

celarsen said:
How do I store the path to .doc & .pdf files in SQL 2000? I am trying to use

Frontpage 2003 DRW to create a result page displaying the doc or pdf file.

So far I have DRW displaying all the info need in the SQL database, but the
path for the doc & pdf files displays instead of the document.

Thank You

reply to: administrator(remove this)@lepinandrenehan.com
 

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