Image Map and MS CGI controls

[Ian]

Hi Randy that helped, thank you! Now I have a new problem though.

MapServer is treating my unique identifiers (SITE_ID) as numbers when they
are actually strings, and I'm getting this error:

Content-type: text/html msOracleSpatialLayerGetShape(): OracleSpatial error.
Error: ORA-01722: invalid number . Query statement: SELECT SITE_ID,
SITE_CODE, SHAPE FROM (select site_id,site_code,shape from site where
site_id in (select cm.monument_id from campaign_monument cm,
geodetic_campaign gc where gc.code = 'YOLO2005' and gc.id =
cm.geodetic_campaign_id)) WHERE SITE_ID = 3080000 .Check your data
statement.

How can I get MS to see these UIDs as strings instead?
Thank you,

Ian

On 5/26/06, Randy James <rjames57 at yahoo.com> wrote:
>
> Hi me
>
> Have you tried adjusting the TOLERANCE and TOLERANCEUNITS parameters
> for your point layer in your mapfile?
> Randy
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060530/e358261f/attachment.htm>