Dave I tried your syntax and still end up with the "The character '$' is invalid. -----Original Message----- From: Dave Wilson <dave.wil...@autodesk.com> To: List, MapGuide Users Mail <mapguide-users@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-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@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-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Mark Hedges Sent: Wednesday, August 26, 2009 4:29 PM To: mapguide-users@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-boun...@lists.osgeo.org [mailto:mapguide-users- >> boun...@lists.osgeo.org] On Behalf Of Mark Hedges >> Sent: Wednesday, August 26, 2009 2:52 PM >> To: mapguide-users@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@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapguide-users > _______________________________________________ > mapguide-users mailing list > mapguide-users@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
