[mapguide-users] Numeric Search

[Martin Morrison]

I don't "like" is ever valid for numeric data.  If you need to use "like" convert your data to a string.

Martin



-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Mark Hedges
Sent: Wednesday, August 26, 2009 2:52 PM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] Numeric Search


I have created several searches like PROJECT_TITLE LIKE '%$USER_VARIABLE%'
which works great.  The data in the Project_Title table is not Numeric. 
When I try to create a search for a Numeric field such as FID LIKE
'%$USER_VARIABLE%' I get the following message: "Arguement types for
operator 'LIKE' are mismatched.  The validation operation expected 'Boolean'
but the expression returned 'Unknown".  It appears that I cannot use this
expression on Numeric data.  Any help would be greatly appreciated.
-- 
View this message in context: http://n2.nabble.com/Numeric-Search-tp3518680p3518680.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users