[mapguide-users] Numeric Search

[Dave Wilson]

Try this:

ToString(FID) LIKE  '$USER_VARIABLE%'

This works for me.

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:45 PM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Numeric Search

I had some notes passed back and forth with Mark separately...  What he is trying to do is run this query within the expression builder within Mapguide.  Is this possible Dave or Traian?

Martin

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Dave Wilson
Sent: Wednesday, August 26, 2009 4:35 PM
To: MapGuide Users Mail List
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

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