[Pmapper-users] Postgis query syntax error

2006-10-11 Thread Marino Fiorito
Sorry but for me in this moment is complicated to open an access ssh on a server with oracle client and pmapper installed and configured. An alternative is, if you have time, to download and install Oracle Express Edition it's free for data less than 4Gb and it has an extension (locator) in order

[Pmapper-users] Postgis query syntax error

2006-10-09 Thread Armin Burger
> I have tried to activate a search also on a layer oracle (10g) with > oraclespatial type connection: > DATA "GEOMETRY FROM SEZIONI_CENS01 USING UNIQUE ID2" > > The search does not produce result and no error in the log php appears. > The search on oracle layer is also possible? > no, becasue

[Pmapper-users] Postgis query syntax error

2006-10-09 Thread Marino Fiorito
With the new lines of code the search works perfectly and is sure one solution more standard. I have tried to activate a search also on a layer oracle (10g) with oraclespatial type connection: DATA "GEOMETRY FROM SEZIONI_CENS01 USING UNIQUE ID2" The search does not produce result and no error i

[Pmapper-users] Postgis query syntax error

2006-10-08 Thread Armin Burger
if your layer/table has an entry in table 'geometry_columns' you can also skip completely 'using srid=26591'. This is just needed in case this entry is not existing, typically eg. for DB views. I don't know why 'USING UNIQUE srid=26591' doesn't produce a low level error of Mapserver, though, Map

[Pmapper-users] Postgis query syntax error

2006-10-08 Thread Marino Fiorito
Sorry Armin, if I have not answered fastly to your first message. Yes my definition DATA in the mapfile is: > "the_geom from mytable USING UNIQUE gid using srid=26591" I have changed the definition DATA with this: "the_geom from mytable USING UNIQUE gid USING UNIQUE srid=26591" and now the qu

[Pmapper-users] Postgis query syntax error

2006-10-07 Thread Armin Burger
I guess your DATA definition is of type "the_geom from mytable USING UNIQUE gid using srid=26591" try to substitute in squery.php the line ~716 $data_list['unique_field'] = trim($tabl[1]); with $unique_list = preg_split('/[\s]+/', trim($tabl[1])); $data_list['unique_field'] = trim($u

[Pmapper-users] Postgis query syntax error

2006-10-07 Thread Armin Burger
Marino Fiorito wrote: > Hi, > > I'm trying a postgis layer in pmapper with administrative boundaries. > The visualization of map it's ok but the query on the column of a layer > is not performed and the query returned the following php error: > > [04-Oct-2006 10:40:15] PHP Warning: pg_query()

[Pmapper-users] Postgis query syntax error

2006-10-04 Thread Marino Fiorito
Hi, I'm trying a postgis layer in pmapper with administrative boundaries. The visualization of map it's ok but the query on the column of a layer is not performed and the query returned the following php error: [04-Oct-2006 10:40:15] PHP Warning: pg_query() [function.pg-query]: Query failed: ERR