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 <[EMAIL PROTECTED]> wrote:
Hi me
Have you tried adjusting the TOLERANCE and TOLERANCEUNITS parameters
for your point layer in your mapfile?
Randy
