jg1130
Posts: 6
|
Posted: 05/16/2005, 2:30 PM |
|
Greetings,
I am using CC, ASP and Access 2k
I have a table that stores the location of scanned documents.
I want to be able to link to the docuements viw the web so that a user can login and see a particular doc.
I have set the DocLocation field to URL yada yada yada...
My problem is that the documents show as a URL, however I can not figure on how to make them open via the web.
I have searched the forum and have not found a solution.
I need some help in making this work, if anyone can provide some assistance I would be very greatful.
Thanks,
Juan
|
|
|
peterr
Posts: 5971
|
Posted: 05/16/2005, 2:50 PM |
|
Look at the Portal example. It contains the "Links" section with each link pointing to external Website. You can implement links in the same way.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Juan
|
Posted: 05/16/2005, 3:42 PM |
|
Hi Peter,
I've decided to use a small bit of code from another project I worked on, the only problem is I think I'm missing something.
Can you take a look and see what you think.
fldDocLocation="<a href = ""http://localhost/expressservices/scanneddocuments="" & fldDocLocation& "">"& fldDocLocation& "</a>"
I am using it in the BeforeShow event. However it is not working properly.
Thanks,
Juan
|
|
|
peterr
Posts: 5971
|
Posted: 05/16/2005, 6:22 PM |
|
Any more details?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Juan
|
Posted: 05/16/2005, 6:27 PM |
|
The documents are all pdf and were scanned and reside in the ScannedDocuments directory of the web server.
They are hyperlinked within MS Access from the ScannedDocuments directory so that users can view them.
Thats about all I can add.
Thanks,
Juan
|
|
|
peterr
Posts: 5971
|
Posted: 05/16/2005, 6:29 PM |
|
No, I'm asking about "it is not working properly". I don't know what this means.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Juan
|
Posted: 05/16/2005, 6:30 PM |
|
One more thing when I run this code:
fldDocLocation="<a href = ""http://localhost/expressservices/scanneddocuments"" & fldDocLocation & "">"&fldDocLocation&"</a>"
This is what displays on the web page:
<a href = "http://localhost/expressservices/scanneddocuments" & fldDocLocation & ">#John R Gordon.doc#
|
|
|
peterr
Posts: 5971
|
Posted: 05/16/2005, 6:31 PM |
|
This means that you didn't close the 1st quote peroperly. Should be: scanneddocuments="""
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Juan
|
Posted: 05/16/2005, 6:34 PM |
|
Hi Peter,
When I close the first quote this is what I get:
fldDocLocation="<a href = ""http://localhost/expressservices/scanneddocuments=""" & fldDocLocation & "">"&fldDocLocation&"</a>"
|
|
|
peterr
Posts: 5971
|
Posted: 05/16/2005, 6:37 PM |
|
Actually I'm concerned that you can make this more complex than it could be, unless the standard method doesn't work in your case.
Take a look at the Portal example to see how it should be done. All you need to do is to specify that this field is "URL" and this should work automatically without any programming.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Juan
|
Posted: 05/16/2005, 6:49 PM |
|
Hi Peter,
I checked out the Portal example and did the same thing. The document shows as a link, however when I click on it nothing happens.
It shows on the web page as this:
#Letter.doc#
By alll accounts it should open, but it does not.
I'm stumped.
|
|
|
peterr
Posts: 5971
|
Posted: 05/16/2005, 6:59 PM |
|
I see. So you're not storing the full URL in the database. Back to your code then. Please try this:
fldDocLocation="<a href = ""http://localhost/expressservices/scanneddocuments=""" & fldDocLocation& ">"""& fldDocLocation& "</a>"
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
peterr
Posts: 5971
|
Posted: 05/16/2005, 7:00 PM |
|
Actually:
fldDocLocation="<a href = ""http://localhost/expressservices/scanneddocuments=" & fldDocLocation & """>"& fldDocLocation& "</a>"
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Juan
|
Posted: 05/16/2005, 7:38 PM |
|
Hi Peter,
I almost have it, this is what I now have:
http://localhost/expressservices/scanneddocuments/#Letter.doc#
Using the following in the Before Show event:
fldDocLocation="<a href = ""http://localhost/expressservices/scanneddocuments/" & fldDocLocation & """>"& fldDocName &"</a>"
If I can figure how to loose the # signs before and after Letter.doc it should work.
Juan
|
|
|
peterr
Posts: 5971
|
Posted: 05/16/2005, 10:02 PM |
|
Looks like you're database is outputting those characters. You may need to change the database field type to regular text/char.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|