[mapserver-users] followup - q. combining mapscript and PostGIS

[Lowell.Filak]

We currently use DBI without a problem but not with the Pg module
(DBD::XBase & DBD::mysql). The error may not be tied directly to
mapscript & Pg however. A search on google shows the errors having to do
with needing to compile the module with -flat_namespace.?
Lowell F.

On Tue, 13 Aug 2002, Alex Rice wrote:

> It appears that the filter on a layer objects only decides the
> content, not the extent of the layer. Is that correct? Also, is
> it even possible to use Perl DBI from Mapscript? My script dies
> when I attempt it:
>
> % ./mapscript.cgi
> dyld: perl multiple definitions of symbol _DLAddHead
> /Library/Perl/darwin/auto/mapscript/mapscript.bundle definition
> of _DLAddHead
> /Library/Perl/darwin/auto/DBD/Pg/Pg.bundle definition of _DLAddHead
>
> Thanks for any suggestions,
> Alex
>
> Begin forwarded message:
>
> > From: Alex Rice <alex_rice at arc.to>
> > Date: Tue Aug 13, 2002  09:32:12  AM US/Mountain
> > To: vinko at cprsig.cl
> > Subject: Re: [mapserver-users] q. combining mapscript and PostGIS
> >
> >
> > On Tuesday, August 13, 2002, at 03:07  AM, Vinko Vrsalovic wrote:
> >>
> >> I didn't get if you actually do a query in your mapscript code or not.
> >
> > So far I am only doing the queries by setting the filter on my
> > layer objects using mapscript, not doing a query with DBI.
> >
> > This is my first mapscript app and I'm kind of getting a feel for
> > the design issues involved.
> >
> >> If not, and the queries are done by mapserver libraries and you
> >> wish to
> >> avoid doing an extra query, my guess is that you can't, because,
> >> AFAIU,
> >> FILTER is used to determine what is shown, not how... but I may
> >> be wrong.
> >
> > OK, thanks for confirming. At least two pairs of eyes think so.
> >
> >> If you do a query, you could extract the extent in that same query, as
> >> in:
> >>
> >> select name, zipcode, extent(the_geom) as extent from streets where
> >> <...> group by name,zipcode;
> >>
> >
> > Yes, I guess I'll just do this. I may need to use DBI for other
> > purposes in this app as well. Not sure.
> >
> > Thanks,
> >
> > Alex Rice, Software Developer
> > Architectural Research Consultants, Inc.
> > alex_rice at arc.to
> > alrice at swcp.com
> >
> >
>