<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=Content-Type content="text/html; charset=ISO-8859-1">
<META content="MSHTML 6.00.2900.3676" name=GENERATOR>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2>The URL field of an object holds a piece of SQL (Structured
Query Language). The concat is a function of SQL. As part of the rules around
SQL, free text is encased in ' and fields have none.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2>The URL string should look something like this
concat('http://www.someserver.com/report_page.php?clicked_item_id=',
item_unique_field)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2>where item_unique_field is a field of the
layer.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2>for example if I have a water_line object and it has the
following fields;</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2>Primary_key</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2>Size</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2>Date</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2>line</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2>The geometry for the layer will be set to the line field. I
might do some styling on the size field and i want to launch a reporting page
using the Primary_key field. To do this the URL property of the layer will be
set to concat('http://www.someserver.com/report_page.php?clicked_item_id=',
Primary_key).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2>Hope this helps.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=376011905-30072010><FONT face=Arial
color=#0000ff size=2>Mark</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Mauricio Villablanca [via OSGeo.org]
[mailto:<a href="/user/SendEmail.jtp?type=node&node=5353784&i=0" target="_top" rel="nofollow">[hidden email]</a>] <BR><B>Sent:</B>
Friday, 30 July 2010 3:06 PM<BR><B>To:</B> VOLZ Mark (FN)<BR><B>Subject:</B> Re:
URL Activated for features<BR></FONT><BR></DIV>
<DIV></DIV>SQL???? You mean URL? <BR><BR>concat ('<A
href="http://www.someserver.com/report_page.php?clicked_item_id='" target=_top rel="nofollow" link="external">http://www.someserver.com/report_page.php?clicked_item_id='</A>,
"item_unique_field") <BR><BR>Double quotes for attributes, single quotes for
strings. <BR><BR>
<HR color=#cccccc noShade SIZE=1>
<DIV style="FONT: 11px tahoma,geneva,helvetica,arial,sans-serif; COLOR: #666666">View
message @ <A href="http://osgeo-org.1803224.n2.nabble.com/URL-Activated-for-features-tp5238025p5353750.html?by-user=t" target="_top" rel="nofollow" link="external">http://osgeo-org.1803224.n2.nabble.com/URL-Activated-for-features-tp5238025p5353750.html</A>
<BR>To unsubscribe from Re: URL Activated for features, <A target="_top" rel="nofollow" link="external">click
here</A>. </DIV><BR><BR><BR><FONT style="BACKGROUND-COLOR: #ffffff">
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff">Click <A
href="https://www.mailcontrol.com/sr/qx6l088xDpnTndxI!oX7UhHqCnr9FF1iDOfqIOJHxe1sp64j1RnUV1B0oK2KYEYNj6B2UVGAGYQcloz8rNwSTQ==" target="_top" rel="nofollow" link="external">here</A>
to report this email as spam.</FONT></P></FONT><p> <br />*************************************************************************<br />This e-mail (including any attachments) may contain confidential or<br />privileged information and is intended for the sole use of the person(s) to<br />whom it is addressed. If you are not the intended recipient, or the person<br />responsible for delivering this message to the intended recipient, please<br />notify the sender of the message or send an e-mail to<br /><a href="/user/SendEmail.jtp?type=node&node=5353784&i=1" target="_top" rel="nofollow">[hidden email]</a> immediately, and delete all copies. Any<br />unauthorised review, use, alteration, disclosure or distribution of this<br />e-mail by an unintended recipient is prohibited. Ergon Energy accepts no<br />responsibility for the content of any e-mail sent by an employee which is of<br />a personal nature.</p><p>Ergon Energy Corporation Limited ABN 50 087 646 062<br />*************************************************************************</p>
<br><hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/URL-Activated-for-features-tp5238025p5353784.html">RE: URL Activated for features</a><br>
Sent from the <a href="http://osgeo-org.1803224.n2.nabble.com/MapGuide-Users-f1803227.html">MapGuide Users mailing list archive</a> at Nabble.com.<br>