[mapguide-users] Numeric Search

Mark Hedges HedgesM at cityofnorthlasvegas.com
Wed Aug 26 16:39:34 EDT 2009


Dave I tried your syntax and still end up with the "The character '$' is invalid. 
-----Original Message-----
From: Dave Wilson <dave.wilson at autodesk.com>
To: List, MapGuide Users Mail <mapguide-users at lists.osgeo.org>

Sent: 8/26/2009 1:35:02 PM
Subject: RE: [mapguide-users] Numeric Search

correct me if I'm wrong, but shouldn't the full syntax be:

ToString(FID) LIKE Concat(ToString($USER_VARIABLE), '%')

Dave

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Martin Morrison
Sent: Wednesday, August 26, 2009 2:32 PM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Numeric Search

Are you by chance using dotnet instead of php?

-----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 4:29 PM
To: mapguide-users at lists.osgeo.org
Subject: RE: [mapguide-users] Numeric Search


Thank you for reply.  I have tried this code along with several others and
still no luck.  This now gives me an invalid character error message for the
$.  I will keep trying.

Traian Stanev wrote:
> 
> Try something like:
> 
> 
> FID LIKE Concat(ToString($USER_VARIABLE), '%')
> 
> 
> Traian
> 
> 
>> -----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
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Numeric-Search-tp3518680p3519257.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

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users



More information about the mapguide-users mailing list