[postgis-users] Problem file.map to Postgis

[Nicolas Ribot]

Hi Donovan,

Apparently, the connection database does work.
The query is getting executed and Postgis error is:
 ERROR:  syntax error at or near "@" at character 139

You query seem to be very strange:

SELECT Capital::text,Name::text,asbinary(force_collection(force_2d(ä¶J@ä¶J@)),'NDR'),OID::text
from ì¶J@ì¶J@ WHERE ä¶J@ä¶J@ && 
setSRID('BOX3D(-2598687.33333333 -712631,3471487.33333333
3840000)'::BOX3D, find_srid('','ì¶J@ì¶J@','ä¶J@ä¶J@') )

Table names and columns are all messed up in this query.

What is your database encoding ?
You should check this.

Nicolas

On 6/14/05, Levert Donovan <dono78fr at yahoo.fr> wrote:
> Hello,
> I am newbie with Postgis, I use the tutorial example
> Gmap-demo  from FGS(Maptools) and I would like to link
> a .map file with the Postgis database, but I have many
> problems.
> This is a part of file gmap75.map to a Postgis
> connection :
> 
> LAYER
>   NAME popplace
>   METADATA
>     "DESCRIPTION"   "Cities"
>     "RESULT_FIELDS" "NAME"
>   END
>   TYPE POINT
>   STATUS ON
>   DATA "the_geom FROM popplace"
>   CONNECTIONTYPE POSTGIS
>   CONNECTION "user=x password=x dbname=mapcanada
> host=192.168.20.200 port=5432"
> 
>   LabelItem "Name"
>   CLASSITEM "Capital"
>   CLASS
>     EXPRESSION "1"
>     TEMPLATE "ttt_query.html"
>     SYMBOL 2
>     SIZE 8 .....
> 
> The connection to database doesn't works, I activated
> verbose logs, and I see a bad format for the text,
> this is the error log :
> 
> DEBUG:  StartTransactionCommand
> LOG:  statement: DECLARE mycursor BINARY CURSOR FOR
> SELECT
> Capital::text,Name::text,asbinary(force_collection(force_2d(ä¶J@ä¶J@)),'NDR'),OID::text
> from ì¶J@ì¶J@ WHERE ä¶J@ä¶J@ &&
> setSRID('BOX3D(-2598687.33333333
> -712631,3471487.33333333 3840000)'::BOX3D,
> find_srid('','ì¶J@ì¶J@','ä¶J@ä¶J@') )
> ERROR:  syntax error at or near "@" at character 139
> 
> Do you know
> 
> Best Regards,
> LEVERT Donovan
> 
> 
> 
> 
> 
> 
> ___________________________________________________________________________
> Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
> Téléchargez cette version sur http://fr.messenger.yahoo.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>