[postgis-users] Problem file.map to Postgis

[strk at refractions.net]

On Wed, Jun 15, 2005 at 05:45:51PM +0200, Levert Donovan wrote:
> 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.

Sounds as a memory error in the postgis connector
(an unchecked string function return ?)
Your .map is an ascii file, isn't it ?
--strk;

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