[postgis-users] cannt connect in mapserver

[Richard Greenwood]

I think your select statement is correct. Have you tested that everything 
works correctly with a shape file?

Rich

At 11:43 AM 7/11/2003 +0800, you wrote:

>Richard:
>
>No. shp2img still doesn't work. it said
>
>[root at cbers mapserver-4.0b]# ./shp2img -m my.map -o
>my2.png
>msDrawMap(): Image handling error. Failed to draw
>layer named 'test'.
>
>I think it fail for postgis doesn't give it the result
>of select.
>
>Is this select statement acceptable in postgis?
>Or should i ask the mapserver list for why mapserver
>generated such a bad syntax statement?
>
>PS my mapserver is 4.0beta
>
>  --- Richard Greenwood <Rich at GreenwoodMap.com>
>µÄÕýÎÄ£º> Is it creating a PNG output file? Postmaster
>reports
> > a lot of information
> > that does not matter.
> >
> > Rich
> >
> >
> > At 10:42 AM 7/11/2003 +0800, you wrote:
> > >Richard:
> > >
> > >Thank you! I never notice the -i option before.
> > >
> > >But this time, postmaster output error information
> > >when i execute shp2img.
> > >Then i open the debug option -d 5
> > >
> > >the debug info list below:
> > >
> > >DEBUG:  ProcessUtility
> > >DEBUG:  CommitTransactionCommand
> > >DEBUG:  StartTransactionCommand
> > >LOG:  query: DECLARE mycursor BINARY CURSOR FOR
> > SELECT
> >
> >asbinary(force_collection(force_2d()),'NDR'),OID::text
> > >from  WHERE  && 'BOX3D(-10 -10,10 10)'::BOX3D
> > >ERROR:  parser: parse error at or near "WHERE" at
> > >character 104
> > >DEBUG:  AbortCurrentTransaction
> > >DEBUG:  proc_exit(0)
> > >DEBUG:  shmem_exit(0)
> > >DEBUG:  exit(0)
> > >DEBUG:  reaping dead processes
> > >DEBUG:  child process (pid 2318) exited with exit
> > code
> > >0
> > >DEBUG:  proc_exit(0)
> > >DEBUG:  shmem_exit(0)
> > >DEBUG:  exit(0)
> > >DEBUG:  reaping dead processes
> > >DEBUG:  child process (pid 2336) exited with exit
> > code
> > >0
> > >
> > >I think something missed between the "where" and
> > "&&".
> > >But what i do in mapserver map file just is
> > >
> > >MAP
> > >   NAME APPLE
> > >   STATUS ON
> > >EXTENT  -10 -10 10 10
> > >UNITS METERS
> > >SIZE 100 100
> > >IMAGETYPE PNG
> > >
> > >LAYER
> > >CONNECTIONTYPE postgis
> > >NAME "test"
> > >CONNECTION "user=postgres password=postgres
> > >dbname=chenfu host=localhost"
> > >DATA "geom FROM test"
> > >STATUS ON
> > >TYPE LINE
> > >END
> > >
> > >END # Map File
> > >
> > >
> > >Do you have any idea of this error?
> > >Thanks in advance!
> > >
> > >
> > >=====
> > >Remote Scensing Satellite Ground Station
> > >Chinese Academy of Science
> > >
> >
> >_________________________________________________________
> > >Do You Yahoo!?
> > >¹úÄÚµçÓÊÓû§·´À¬»øµ÷²éÀ­¿ªá¡Ä»
> >
> >http://cn.rd.yahoo.com/mail_cn/tag/?http://cn.tech.yahoo.com/zhuanti/laji 
> /index.html
> >
> >
> > Richard W. Greenwood, PLS
> > Greenwood Mapping, Inc.
> > Rich <at> GreenwoodMap <dot> com
> > (307) 733-0203
> > http://www.GreenwoodMap.com
> >
>
>=====
>Remote Scensing Satellite Ground Station
>Chinese Academy of Science
>
>_________________________________________________________
>Do You Yahoo!?
>¹úÄÚµçÓÊÓû§·´À¬»øµ÷²éÀ­¿ªá¡Ä»
>http://cn.rd.yahoo.com/mail_cn/tag/?http://cn.tech.yahoo.com/zhuanti/laji/index.html
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users


Richard W. Greenwood, PLS
Greenwood Mapping, Inc.
Rich <at> GreenwoodMap <dot> com
(307) 733-0203
http://www.GreenwoodMap.com