[postgis-users] Problem file.map to Postgis

[Levert Donovan]

Hi, 
> What is your database encoding ?
Lambert : 27582

I don't know why the request was sent... I have write
this request "the_geom FROM popplace" and It isn't me
who has write the error which result an error.

Best Regards.



--- Nicolas Ribot <nicky666 at gmail.com> a écrit :

> 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
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
>
http://postgis.refractions.net/mailman/listinfo/postgis-users
> 



	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com