Re: [mapguide-users] Numeric Search

2009-08-26 Thread Mark Hedges
-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 1:40 PM > To: dave.wil...@autodesk.com; mapguide-users@lists.osgeo.org > Subject: SPAM-LOW: Re: [mapguide-users] Numer

Re: [mapguide-users] Numeric Search

2009-08-26 Thread Andy Morsell
n...@lists.osgeo.org] On Behalf Of Mark Hedges Sent: Wednesday, August 26, 2009 1:40 PM To: dave.wil...@autodesk.com; mapguide-users@lists.osgeo.org Subject: SPAM-LOW: Re: [mapguide-users] Numeric Search Dave I tried your syntax and still end up with the "The character '$' is inval

RE: [mapguide-users] Numeric Search

2009-08-26 Thread Dave Wilson
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-

Re: [mapguide-users] Numeric Search

2009-08-26 Thread Mark Hedges
Dave I tried your syntax and still end up with the "The character '$' is invalid. -Original Message- From: Dave Wilson To: List, MapGuide Users Mail Sent: 8/26/2009 1:35:02 PM Subject: RE: [mapguide-users] Numeric Search correct me if I'm wrong, but shouldn&

RE: [mapguide-users] Numeric Search

2009-08-26 Thread Martin Morrison
...@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), '%')

RE: [mapguide-users] Numeric Search

2009-08-26 Thread Dave Wilson
t: 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

RE: [mapguide-users] Numeric Search

2009-08-26 Thread Martin Morrison
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

RE: [mapguide-users] Numeric Search

2009-08-26 Thread Mark Hedges
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 > >

RE: [mapguide-users] Numeric Search

2009-08-26 Thread Traian Stanev
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@lis

RE: [mapguide-users] Numeric Search

2009-08-26 Thread 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-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Mark Hedges Sent: Wednesday, August 26, 2009 2:5