<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>This is Great! I just tried and it
worked.</FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks a lot everyone,
especially for David, Ruck and Jacob.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Xiaopeng</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=David.Fawcett@state.mn.us
href="mailto:David.Fawcett@state.mn.us">Fawcett, David</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=xpxiong@purdue.edu
href="mailto:xpxiong@purdue.edu">Xiaopeng Xiong</A> ; <A
title=David.Fawcett@state.mn.us
href="mailto:David.Fawcett@state.mn.us">Fawcett, David</A> ; <A
title=MAPSERVER-USERS@lists.umn.edu
href="mailto:MAPSERVER-USERS@lists.umn.edu">MAPSERVER-USERS@lists.umn.edu</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, October 10, 2006 3:02
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [UMN_MAPSERVER-USERS] Help:
generating a hyperlink in query result</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=324365618-10102006><FONT face=Arial color=#0000ff size=2>In
your query template, you could use the value from one of your shapefile
columns or database columns to build a URL. </FONT></SPAN></DIV>
<DIV><SPAN class=324365618-10102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=324365618-10102006><FONT face=Arial color=#0000ff
size=2>Something like: </FONT></SPAN></DIV>
<DIV><SPAN class=324365618-10102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=324365618-10102006><FONT face=Arial color=#0000ff
size=2><a href="<A
href='http://myserver.com/mydir/[IMAGENAME]">[IMAGENAME]</a'>http://myserver.com/mydir/[IMAGENAME]">[IMAGENAME]</a</A>>
</FONT></SPAN></DIV>
<DIV><SPAN class=324365618-10102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=324365618-10102006><FONT face=Arial color=#0000ff size=2>or
</FONT></SPAN></DIV>
<DIV><SPAN class=324365618-10102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=324365618-10102006><SPAN class=324365618-10102006><FONT
face=Arial color=#0000ff size=2><a href=<A
href="http://myserver.com/mydir/[IMAGENUMBER].img">http://myserver.com/mydir/[IMAGENUMBER].img</A>>[IMAGENUMBER].img</a>
</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=324365618-10102006><SPAN class=324365618-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=324365618-10102006><SPAN class=324365618-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=324365618-10102006><SPAN class=324365618-10102006><FONT
face=Arial color=#0000ff size=2>If you wanted to use a URL to send the user
directly from a map click to the image, you could
use:</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=324365618-10102006><SPAN class=324365618-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=324365618-10102006><SPAN class=324365618-10102006><FONT
face=Arial color=#0000ff size=2>TEMPLATE "<A
href="http://myserver.com/mydir/[IMAGENUMBER].img">http://myserver.com/mydir/[IMAGENUMBER].img</A>"
</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=324365618-10102006><SPAN class=324365618-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=324365618-10102006><SPAN class=324365618-10102006><FONT
face=Arial color=#0000ff size=2>**note, URL templates only work in mode=query,
NOT in mode=nquery!</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=324365618-10102006><SPAN class=324365618-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=324365618-10102006><SPAN class=324365618-10102006><FONT
face=Arial color=#0000ff size=2>David.</FONT></SPAN></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Xiaopeng Xiong
[mailto:xpxiong@purdue.edu] <BR><B>Sent:</B> Tuesday, October 10, 2006 1:50
PM<BR><B>To:</B> Fawcett, David;
MAPSERVER-USERS@lists.umn.edu<BR><B>Subject:</B> Re: [UMN_MAPSERVER-USERS]
Help: generating a hyperlink in query result<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I probably want the second way. A difference is
that the clickable links are not exactly the same as the attribute values in
the index, because I have to change a UNIX file path (e.g.,
/home/MyDir/1.img) to a Web-accessible path (e.g., <A
href="http://SomeWeb/MyDir/1.img">http://SomeWeb/MyDir/1.img</A>).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Xiaopeng</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=David.Fawcett@STATE.MN.US
href="mailto:David.Fawcett@STATE.MN.US">Fawcett, David</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=MAPSERVER-USERS@LISTS.UMN.EDU
href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, October 10, 2006 2:40
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [UMN_MAPSERVER-USERS]
Help: generating a hyperlink in query result</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=197073818-10102006><FONT face=Arial color=#0000ff
size=2>Are you interested in having the user click on the map and be
directed automatically to another Web page? This could be done using
a URL as a query template and setting the mode to query.
</FONT></SPAN></DIV>
<DIV><SPAN class=197073818-10102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=197073818-10102006><FONT face=Arial color=#0000ff
size=2>Or, do you want the user to click on the map, presumably as a query
and return a page or text on the existing page that includes a list of
clickable links? </FONT></SPAN></DIV>
<DIV><SPAN class=197073818-10102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=197073818-10102006><FONT face=Arial color=#0000ff
size=2>David.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> UMN
MapServer Users List [mailto:MAPSERVER-USERS@LISTS.UMN.EDU] <B>On Behalf
Of </B>Xiaopeng Xiong<BR><B>Sent:</B> Tuesday, October 10, 2006 1:23
PM<BR><B>To:</B> MAPSERVER-USERS@LISTS.UMN.EDU<BR><B>Subject:</B> Re:
[UMN_MAPSERVER-USERS] Help: generating a hyperlink in query
result<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Jacob, thank for your reply.
</FONT></DIV>
<DIV><FONT face=Arial size=2>I think your method generates hyperlinks
after post-processing of query result. But I wonder if it is possible to
return hyperlinks to a uer directly when he/she clicks on the map. I
wonder it is possible?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Xiaopeng</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Jacob.Delfos@maunsell.com
href="mailto:Jacob.Delfos@maunsell.com">Delfos, Jacob</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=xpxiong@PURDUE.EDU
href="mailto:xpxiong@PURDUE.EDU">Xiaopeng Xiong</A> ; <A
title=MAPSERVER-USERS@LISTS.UMN.EDU
href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, October 10, 2006
12:11 AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE:
[UMN_MAPSERVER-USERS] Help: generating a hyperlink in query
result</DIV>
<DIV><BR></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>Hi Xiaopeng,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>If the attribute value is simply
passed into the HTML, then it's simply a matter of putting in the
right HTML code:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2><a href="<A
href="http://someWebsite/myDir/1.img">http://someWebsite/myDir/1.img</A>"
target=#>Click for 1.img</a> (the target=# makes it
open in a new window)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>I normally generate a directory
listing, and paste it into a spreadsheet (e.g. excel / openOffice
CALC), and split up the parts of the link, then concatenate them. For
example, imagine a row in a spreadsheet:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>column
1: <a
href="http://someWebsite/mydir/</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>column
2: 1</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>column
3: ".img
target=#></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>column
4: click for image </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>column
5: 1</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>column 6:
</a></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>column 7:
=concatenate(column1, column2, column3, column4,
column6)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>Only column 2 and 5 will change (can
use autonumber). All other columns will hold the same value, and can
be copied across.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>Hope this makes
sense.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>regards,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2>Jacob</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=670570404-10102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> UMN MapServer Users List
[mailto:MAPSERVER-USERS@LISTS.UMN.EDU] <B>On Behalf Of </B>Xiaopeng
Xiong<BR><B>Sent:</B> 10 October 2006 11:42<BR><B>To:</B>
MAPSERVER-USERS@LISTS.UMN.EDU<BR><B>Subject:</B>
[UMN_MAPSERVER-USERS] Help: generating a hyperlink in query
result<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial>I have one index on raster images and it can
be displayed and queried through Mapserver.</FONT></DIV>
<DIV><FONT face=Arial>I wonder whether it would be possible to
generate a hyperlink in query result.</FONT></DIV>
<DIV><FONT face=Arial>The hyperlink will be generated based on one
attribute in the index. </FONT></DIV>
<DIV><FONT face=Arial>For example, if the attribute value is
"/home/myDir/1.img", the hyperlink will direct user to <A
href="http://SomeWebsite/myDir/1.img">http://SomeWebsite/myDir/1.img</A>".</FONT></DIV>
<DIV><FONT face=Arial>I appreciate any suggestions or
ideas.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Thank you</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Best regards,</FONT></DIV>
<DIV><FONT
face=Arial>Xiaopeng</FONT></DIV></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>