CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge -> Programming

 Hyperlink to scanned documents

Print topic Send  topic

Author Message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.