2. PHPRunner General questions
  3. lan documents access
This topic is locked

lan documents access

 		3/25/2010 1:15:41 AM
PHPRunner General questions
M
 meirco author

I have a server with thousands of documents word , pdf, wordperfect etc... The documents are in folders assoiciated to case numbers where case 999-1234 will store all relevant documents in Folder 999 and sub-folder - 1234 my data base

contains all the record numbers and a link field which is the path to folders and the document name x:/999/1234/test1.doc when I click on the link It doesn't open the word program How can I achieve that. I dont want the users to download a document every time they need to open it.
the current way PHPR5.1 requires you to have the documents in sub-folder of your htdocs I understand the reason .

My app. will run on a secured local network. I need to point to the existing document server. I resolved all access permissions issues. any help is appreciated.
Sergey Kornilov admin 3/25/2010

If your question is 'how to link to local or network file' check this article: http://www.htmlcodetutorial.com/help/sutra41677.html
M
 		meirco author 3/25/2010



If your question is 'how to link to local or network file' check this article: http://www.htmlcodetutorial.com/help/sutra41677.html


here is what I have

sql query

SELECT

BMBMNO,

concat('file:///r:/', mid(BMBMNO, 1, 3), '/', mid(BMBMNO, 5, 4), '/', mid(DOC_PATH, 13), '/', DOCU_NAME) AS doc_link

FROM docsys
this produces the doc_link field
(file:///r:/207/0358/LEGAL/073003TS.DEM AZ.wpd) as an example
in the editor I changed the field view property to view as Hyperlink display URL
after build when I click the link nothing happens.

if I copy the link location of the doc_link field and paste it in the URL it works the way I want.
{BEGIN doc_link_fieldcolumn}<TD class=borderbody vAlign=middle align=middle {$doc_link_style}>&nbsp;{$doc_link_value}</TD>{END doc_link_fieldcolumn}
B
 		bobdansei 3/26/2010



here is what I have

sql query

SELECT

BMBMNO,

concat('file:///r:/', mid(BMBMNO, 1, 3), '/', mid(BMBMNO, 5, 4), '/', mid(DOC_PATH, 13), '/', DOCU_NAME) AS doc_link

FROM docsys
this produces the doc_link field
(file:///r:/207/0358/LEGAL/073003TS.DEM AZ.wpd) as an example
in the editor I changed the field view property to view as Hyperlink display URL
after build when I click the link nothing happens.

if I copy the link location of the doc_link field and paste it in the URL it works the way I want.
{BEGIN doc_link_fieldcolumn}<TD class=borderbody vAlign=middle align=middle {$doc_link_style}>&nbsp;{$doc_link_value}</TD>{END doc_link_fieldcolumn}


i had the same problem.. well i souve it with this custom code..
$value = "<a href='".$value."".$data["SubjectField"]."'>Audio</a>";
this is working perfect in IE8 but i dont know why dont work in firefox or Googlecrome.. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=48803&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' />
M
 		meirco author 3/27/2010



i had the same problem.. well i souve it with this custom code..
$value = "<a href='".$value."".$data["SubjectField"]."'>Audio</a>";
this is working perfect in IE8 but i dont know why dont work in firefox or Googlecrome.. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=48841&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' />



Rodrigo Thank you for your suggestion.

$value = "<a href='".$value."".$data["SubjectField"]."'>Audio</a>"; that puts the value of the field twice. 1 with $value and 2. $data["SubjectField"] besides we need a sultions that work with any browser.
now if I change file:// to http:// clicking on a link puts the request to the URL but of course there is no web page where the file is. It looks like PHPR 5.1 does'nt do with file:// what it does with http:// After some googling I found an add on for mozilla called Locallink at Locallink (it solves the problem for firefox ??)

Thanks.