[mapguide-users] SQL functions in the expression builder?

[Kori Maleski]

I need to be able to run some sort of FORMAT function.

If I try to label with a decimal column, it is displaying 6 zeroes after the
decimal - annoying when you try to label contours...




Kori Maleski  BSc. 
Senior Technical Consultant
 


Suite 400 - 534 17 Ave. SW Calgary, AB CANADA T2S 0B1
TEL 
403.770.1917
 
 
FAX
877.691.9149
 TOL
877.691.9171
www.pat.ca

________________________________________
From: Jason Birch [mailto:Jason.Birch at nanaimo.ca] 
Sent: March 21, 2006 11:16 AM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] SQL functions in the expression builder?

Is there a reference available for what SQL expressions are available in the
expression builder?
 
For tooltips, I'd like to be able to use something like ISNULL() or IIF() to
display "UNKNOWN" when an attribute value is null or blank.
 
Jason