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

[Traian Stanev]

Kori,

In this particular case you can set the label to an expression of the form:

 0 + Property_Name

The 0 will be treated as an integer and therefore the whole expression will evaluate as an integer, resulting in the value displying as integer. This is a trick that exploits the behavior of the expression engine, since there is currently no FORMAT function. 

Jason, there is a NULL check, the syntax for which is:

Property_Name NULL

You can also use the filter expression builder to set up NULL comparisons.

Traian
 

-----Original Message-----
From: Kori Maleski [mailto:km at pat.ca] 
Sent: Tuesday, March 21, 2006 1:50 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] SQL functions in the expression builder?

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


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org