[mapguide-users] RE: URL Activated for features

[mark volz]

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.
 
The URL string should look something like this
concat('http://www.someserver.com/report_page.php?clicked_item_id=',
item_unique_field)
 
where item_unique_field is a field of the layer.
 
for example if I have a water_line object and it has the following
fields;
Primary_key
Size
Date
line
 
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).
 
Hope this helps.
 
Mark

________________________________

From: Mauricio Villablanca [via OSGeo.org]
[mailto:ml-node+5353750-2132739293-173264 at n2.nabble.com] 
Sent: Friday, 30 July 2010 3:06 PM
To: VOLZ Mark (FN)
Subject: Re: URL Activated for features


SQL???? You mean URL? 

concat ('http://www.someserver.com/report_page.php?clicked_item_id=',
"item_unique_field") 

Double quotes for attributes, single quotes for strings. 


________________________________

View message @
http://osgeo-org.1803224.n2.nabble.com/URL-Activated-for-features-tp5238
025p5353750.html 
To unsubscribe from Re: URL Activated for features, click here
<http://osgeo-org.1803224.n2.nabble.com/subscriptions/Unsubscribe.jtp?co
de=bWFyay52b2x6QGVyZ29uLmNvbS5hdXw1MjkxMTY3fDE0NDczNDg2NTA=> . 



Click here
<https://www.mailcontrol.com/sr/qx6l088xDpnTndxI!oX7UhHqCnr9FF1iDOfqIOJH
xe1sp64j1RnUV1B0oK2KYEYNj6B2UVGAGYQcloz8rNwSTQ==>  to report this email
as spam.


 
*************************************************************************
This e-mail (including any attachments) may contain confidential or
privileged information and is intended for the sole use of the person(s) to
whom it is addressed. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, please
notify the sender of the message or send an e-mail to
mailto:help.desk at ergon.com.au immediately, and delete all copies. Any
unauthorised review, use, alteration, disclosure or distribution of this
e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
responsibility for the content of any e-mail sent by an employee which is of
a personal nature.

Ergon Energy Corporation Limited      ABN 50 087 646 062
*************************************************************************

-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/URL-Activated-for-features-tp5238025p5353784.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20100729/bf231db1/attachment.html