[ms4w-users] RE: failed to modify or delete or create my postgis layers in FIST

[Aaron Koning]

I notice that your DATA variable for cities doesn't contain a FROM keyword:
          DATA "the_geom cities"
I think it needs to be:
          DATA "the_geom FROM cities"
And for FIST:
          DATA "the_geom FROM public.cities"

Aaron

On 3/20/06, Ilias Petrou <iliaskoz at yahoo.com> wrote:
>
> I tried to put the public schema in my data in the
> mapfile and the result is thatthe layers not even
> appear now . Before inserting the  public(which IS the
> schema that my CITIES and coast layer are under) i
> could watch my coast and cities layers and zoom and
> query and measure distances in FIST.
> Below is my mapfile without using ths public schema
>
> MAP
>   NAME "lesvo"
>   STATUS ON
>   EXTENT 395671.8775452 4306847.90554 469213.1224548
> 4365767.09446
>   SIZE 400 300
>   IMAGETYPE PNG
>   IMAGECOLOR 0 0 255
>   UNITS METERS
>   WEB
>     IMAGEPATH "c:\ms4w\apps\fist\htdocs\tmp\"
>     IMAGEURL "/tmp/"
>   END
>
>       QUERYMAP
>                 STYLE HILITE
>                 COLOR 255 255 0
>         END
>
>         OUTPUTFORMAT
>           NAME png
>           DRIVER "GD/PNG"
>           MIMETYPE "image/png"
>           IMAGEMODE RGB
>           EXTENSION "png"
>         END
>
>         # ----- MAP ELEMENTS -------------------
>         # --------------------------------------
>
>         PROJECTION
>           "init=epsg:32635"
>         END
>
>         LEGEND
>                 STATUS ON
>         END
>
>         SCALEBAR
>                 STATUS on
>                 UNITS kilometers
>                 INTERVALS 3
>                 SIZE 150 5
>                 OUTLINECOLOR 0 0 0
>                 LABEL
>                         SIZE small
>                 END
>         END
>
>   SYMBOL
>     NAME "circle"
>     TYPE ELLIPSE
>     FILLED TRUE
>     POINTS
>        1 1
>     END
>   END
>
>
>
>
>   LAYER
>     NAME "coast"
>     STATUS ON
>     DATA "the_geom from coast"
>     TYPE POLYGON
>     CONNECTIONTYPE POSTGIS
>     CONNECTION "user=postgres password=iliaskoz
> dbname=peirama host=localhost port=5432"
>     CLASSITEM "gid"
>     UNITS METERS
>     SIZEUNITS PIXELS
>     TOLERANCE 0
>     TOLERANCEUNITS PIXELS
>     CLASS
>       NAME "gid"
>       STYLE
>         SYMBOL "circle"
>         COLOR 198 87 56
>         BACKGROUNDCOLOR 198 87 56
>         SIZE 0
>         MINSIZE 1
>         MAXSIZE 100
>       END
>     END
>   END
> LAYER
>     NAME "cities"
>     STATUS ON
>     DATA "the_geom cities"
>     TYPE POINT
>     TEMPLATE "nepas.html"
>     CONNECTIONTYPE POSTGIS
>     CONNECTION "user=postgres password=iliaskoz
> dbname=peirama host=localhost port=5432"
>     CLASSITEM "cities_"
>     UNITS METERS
>     SIZEUNITS PIXELS
>     TOLERANCE 0
>     TOLERANCEUNITS PIXELS
>     CLASS
>       NAME "cities_"
>       STYLE
>         SYMBOL "circle"
>         COLOR 120 20 20
>         SIZE 8
>         MINSIZE 1
>         MAXSIZE 100
>       END
>     END
>     PROJECTION
>          "init=epsg:32635"
>     END
> END
> END
>
> --- Aaron Koning <aaronkoning at gmail.com> wrote:
>
> > I bet your problem has to do with the DATA variable
> > in your mapfile not
> > containing a schema name. See post:
> >
> http://www.freelists.org/archives/fist-users/03-2006/msg00021.html
> >
> > Thanks,
> > Aaron
> >
> > On 3/19/06, Ilias Petrou <iliaskoz at yahoo.com> wrote:
> > >
> > > hi i have installed ms4w and then install FIST.
> > > when I am trying to modify or delete or create new
> > > features of my postgis layer( the active one)
> > nothing
> > > happen. The user i use in the connection string is
> > the
> > > owner of the postgis table so normally he does
> > have
> > > the right to modify the tables.
> > > Note that i added the
> > > " <context>
> > >               <modes>
> > >                        <mode>edit</mode>
> > >                </modes>
> > >              </context> "
> > > in the layer config file  under the layer i want.
> > >
> > > So for example when i want to digitize a new point
> > it
> > > shows the
> > > message "Accept the location of the point." but
> > when i
> > > choose the button  "NEXT " nothing happens!!!
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam?  Yahoo! Mail has the best spam
> > protection around
> > > http://mail.yahoo.com
> > > _______________________________________________
> > > ms4w-users mailing list
> > > ms4w-users at lists.maptools.org
> > >
> >
> http://lists.maptools.org/mailman/listinfo/ms4w-users
> > >
> >
> >
> >
> > --
> > +--------------------------------------------
> > |  Aaron Koning
> > |  Information Technologist
> > |  Prince George, BC, Canada.
> > +--------------------------------------------
> > |  http://datashare.gis.unbc.ca/fist/
> > |  http://datashare.gis.unbc.ca/gctp-js/
> > +--------------------------------------------
> > > _______________________________________________
> > ms4w-users mailing list
> > ms4w-users at lists.maptools.org
> >
> http://lists.maptools.org/mailman/listinfo/ms4w-users
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> _______________________________________________
> ms4w-users mailing list
> ms4w-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/ms4w-users
>



--
+--------------------------------------------
|  Aaron Koning
|  Information Technologist
|  Prince George, BC, Canada.
+--------------------------------------------
|  http://datashare.gis.unbc.ca/fist/
|  http://datashare.gis.unbc.ca/gctp-js/
+--------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/ms4w-users/attachments/20060320/7b5a62fc/attachment-0001.html