[postgis-users] cannt connect in mapserver

[Chen Fu]

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