Hyperlink to Oracle OLE

[Guest]

I think I have a simple question with this issue I have yet to deal with
using Frontpage 2003. I have an test.asp page which queries an Oracle DB and
it gives me a list of desired results. However, we recently added to ability
for users to upload files to the db ie: .doc, .xls. txt. or pdf's files.
What I want the test.asp page to do is to open the file which is stored in
Oracle when the user clicks on the file name. I mostly use the DBRW for my
queries and think I would somehow have to use to a hyperlink property to the
desire file in the db but nothing has worked so far. My test.asp page lists
the file name but now how do I open this file when the user requests it? It
must be easy......ugh.

 

[Stefan B Rusynko]

See http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#hyperlinks

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I think I have a simple question with this issue I have yet to deal with
| using Frontpage 2003. I have an test.asp page which queries an Oracle DB and
| it gives me a list of desired results. However, we recently added to ability
| for users to upload files to the db ie: .doc, .xls. txt. or pdf's files.
| What I want the test.asp page to do is to open the file which is stored in
| Oracle when the user clicks on the file name. I mostly use the DBRW for my
| queries and think I would somehow have to use to a hyperlink property to the
| desire file in the db but nothing has worked so far. My test.asp page lists
| the file name but now how do I open this file when the user requests it? It
| must be easy......ugh.

 

[Guest]

This works but not when I click on the hyperlink the results show [#BINARY#]

 

[Thomas A. Rowe]

In your IE address bar, type the following:

? Displaying Binary data from Oracle DB on the web

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

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

This works but not when I click on the hyperlink the results show [#BINARY#]

See http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#hyperlinks

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I think I have a simple question with this issue I have yet to deal with
| using Frontpage 2003. I have an test.asp page which queries an Oracle DB and
| it gives me a list of desired results. However, we recently added to ability
| for users to upload files to the db ie: .doc, .xls. txt. or pdf's files.
| What I want the test.asp page to do is to open the file which is stored in
| Oracle when the user clicks on the file name. I mostly use the DBRW for my
| queries and think I would somehow have to use to a hyperlink property to the
| desire file in the db but nothing has worked so far. My test.asp page lists
| the file name but now how do I open this file when the user requests it? It
| must be easy......ugh.