<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.emailstyle17
{mso-style-name:emailstyle17;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Sorry didn’t respond to everyone….<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Thanks for the help and thoughts….<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Jay Kapalczynski <br>
<b>Sent:</b> Monday, December 29, 2008 10:07 AM<br>
<b>To:</b> 'Dan Little'<br>
<b>Subject:</b> RE: [Geomoose-users] Open an Image<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>I am using php page but maybe
not the correct way…I am not using a shapefile to find the images due to the
fact that there may be many images per location.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I am querying a database to find
image names…<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Currently this is an internal
application, but understand what you are saying about giving the full
path. My next steps are to learn more about securing the site for outside
viewers….so you are saying that the URL will be showing me the location….by
doing it your way I will be masking the URL path….is that correct…<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I am a bit confused because I
think you were assuming that I was using a shapefile for the image names.
I do not think that applies to how I am doing this….see below..<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Any thoughts would be
appreciated.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><u><span style='color:black'>THIS IS THE BUTTON THAT THE
USER HITS TO RUN THE QUERY<o:p></o:p></span></u></b></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><tr><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><td
align="center" width='100'>Both SQL and Access:</td><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><td style=
"cursor:pointer" align="center"
onclick="javascript:getResulthype('parcellink3.php','[PID]','S')"><font
size='2' color='#007FFF' >Open Images</font></td><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'></tr><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><u><span style='color:black'>THIS IS AN ajax page that is
called above with “getResulthype”<o:p></o:p></span></u></b></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>function
getResulthype(page,id,type){<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
var _target = 'content_details_form';<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
if (id.length == 0) { <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
document.getElementById(_target).innerHTML="<b>No Information
Available</b>";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
return;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
}<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
xmlHttp = GetAJAXObject();<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
if (xmlHttp==null) {<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
alert ("Unable to process your request, your browser does not support
AJAX!");<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
return;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
} <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
var url =
"http://127.0.0.1:80/geomoose/php/"+page+"?id="+id+"&type="+type;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
xmlHttp.onreadystatechange = showResult;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
xmlHttp.open("GET",url,true);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
xmlHttp.send(null);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>}<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><u><span style='color:black'>THIS IS THE PHP Page to run
the query “parcellink3.php”<o:p></o:p></span></u></b></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><?php<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>require("FuncDef.php");<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>?><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
$sql_str2 = "SELECT * FROM PHOTOS WHERE PID = '".$p_num."' AND
Photo_Doc = 'S'";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
$photo_rs2 = $conn->execute($sql_str2); <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
echo "<br>";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
echo "<div class='redbg'> <b><big>Assessing
Sketches:</big></b></div>";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
echo "<br>";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
If ($photo_rs2->EOF)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
{<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
echo "No photos exist for this parcel!";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
} else<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
{<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
$photo_rs2->MoveFirst();<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
echo "<table border='2' width='100%'>";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
While (!$photo_rs2->EOF)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
{<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
$p_name2 = $photo_rs2->Fields("Filename")->Value;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
$p_hype2 = "javascript:window.open('file://C:/ms4w/apps/GeoMOOSE/htdocs/pdf/Assessing_Sketches/".$p_name2."','photowindow','width=450,height=350')";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
writelinewhype($p_name2,"Image",$p_hype2);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
$photo_rs2->MoveNext();<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
}<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
echo "</table>";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
$photo_rs2->Close();<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
$photo_rs2 =
null;
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>
}<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><span style='color:red'><o:p> </o:p></span></b></p>
<p class=MsoNormal><b><u><span style='color:black'>THIS IS THE </span></u></b><b><u><span
style='font-size:9.0pt;color:black'>FuncDef.php<o:p></o:p></span></u></b></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><?php<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>function
writelinewhype($p_obj,$p_name,$hypelink) {<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'> echo
"<tr>";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'> echo
"<td style= 'text-align:center' width = '100'><font
size='1'>".$p_name."</font></td>";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'> echo
"<td style= 'cursor:pointer' align='center' onClick
=".$hypelink."><font size='1'
color='#007FFF'>".$p_obj."</font></td>";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'> echo
"</tr>";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>}<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'>?><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Dan Little
[mailto:danlittle@yahoo.com] <br>
<b>Sent:</b> Monday, December 29, 2008 9:39 AM<br>
<b>To:</b> Jay Kapalczynski; geomoose-developers@lists.sourceforge.net;
geomoose-users@lists.sourceforge.net<br>
<b>Subject:</b> Re: [Geomoose-users] Open an Image<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Jay,<br>
<br>
This type of request is really, really, really bad practice:<br>
1) It shows the full path to the storage of all of your images.<br>
2) That path is relative to the computer you are USING not the computer where
you have the images stored.<br>
<br>
You should really have a PHP script like the following (put it in the
htdocs/php folder and name it "getSketch.php" or something
intuitive):<br>
<br>
<?php<br>
<br>
$sketchName = $_REQUEST['sketch_name'];<br>
<br>
header('Content-type: application/pdf');<br>
readfile('c:/ms4w/apps/GeoMOOSE/htdocs/pdf/Assessing_Sketches/'.sketchName);<br>
?><br>
<br>
And the hyperlink should look like this... (assuming [SKETCHNAME] is the field
containing the unique ID in a mapserver template file of some sort).<br>
<br>
<a href="php/getSketch.php?sketch_name=[SKETCHNAME]"
target="photowindow">View Sketch PDF</a> <br>
<br>
Or if you must use the javascript windows...<br>
<br>
<a
href="javascript:window.open('php/getSketch.php?sketch_name=[SKETCHNAME]',
'photowindow', 'width=450,height=350')"> View Sketch PDF</a><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
<hr size=1 width="100%" align=center>
</span></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> Jay Kapalczynski
<jkapalczynski@ci.maple-grove.mn.us><br>
<b>To:</b> "geomoose-developers@lists.sourceforge.net"
<geomoose-developers@lists.sourceforge.net>; "geomoose-users@lists.sourceforge.net"
<geomoose-users@lists.sourceforge.net><br>
<b>Sent:</b> Monday, December 29, 2008 9:27:09 AM<br>
<b>Subject:</b> [Geomoose-users] Open an Image</span><span style='font-size:
12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<div>
<p class=MsoNormal>I am having a problem here…<o:p></o:p></p>
<p class=MsoNormal>I have two different locations where I am storing my
imagery. As seen below with the two different paths.<o:p></o:p></p>
<p class=MsoNormal>I verified that the image is present in both locations, and
that the path names are correct….but for some reason I cannot get the image in
the C drive to open. The image located in the S drive opens fine.<o:p></o:p></p>
<p class=MsoNormal>Can anyone see why that may be….is there some sort of syntax
issue with storing the files within the ms4w folder?<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>Not working<o:p></o:p></p>
<p class=MsoNormal>$p_hype2 =
"javascript:window.open('file://C:/ms4w/apps/GeoMOOSE/htdocs/pdf/Assessing_Sketches/".$p_name2."','photowindow','width=450,height=350')";<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>Working<o:p></o:p></p>
<p class=MsoNormal>$p_hype2 =
"javascript:window.open('file://S:/GeoImag/Assessing/Sketches/".$p_name2."','photowindow','width=450,height=350')";<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
</div>
</div>
</div>
</div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
</div>
</body>
</html>