[mapguide-users] expression builder problem (Tooltip)

[Kenneth, GEOGRAF A/S]

It is an SQL expression. An the FDO dialect i believe.
I don't know how to do extract a substring from the column, and it is 
probably provider specific.
A workaround would be to use a tooltip like:
concat(concat('<iframe src="renderpage.php?id=', "PHOTO"), '"></iframe>')

Then have the renderpage.php do all the logic, ea. lookup rows and 
display multiple pictures.

Regards, Kenneth, GEOGRAF A/S



Jose Manuel C G skrev:
> I would like to know what kind of language is used in the Text Expression
> Builder (Tooltip):
>
> I try to build an expression like this(PHOTO = '001,002'):
>
> My goal was show screenshot:001, screenshot:002... but it's impossible. Now
> simply I want 'screenshot:001'
>
> My expression is:
> concat('screenshot: "', concat("PHOTO"'.substring(0,3)'))
>
> But doesn't work...any idea?
>
> Thks in advanced.
>