[Mapserver-users] Re: Query data PHP/Mapscript

[Jim Burnett]

As my last message says, the file is NOT dbase, it is foxpro. Or whatever
esri uses. These modules will not read the dbf files. I am talking about the
dbf files that are produced with the shp files.

-Jim
----- Original Message -----
From: <woodbri at swoodbridge.com>
To: "Puneet Kishor" <pkishor at geoanalytics.com>;
<mapserver-users at lists.gis.umn.edu>; "Jim Burnett" <r000t at adelphia.net>
Sent: Wednesday, March 26, 2003 8:52 AM
Subject: Re: [Mapserver-users] Re: Query data PHP/Mapscript


> In PHP look at the dbase module and in Perl look at the xbase module.
> Both of these will allow you to open and read dbf files.
>
> -Steve W.
>
> On 26 Mar 2003 at 8:36, Jim Burnett wrote:
>
> > I am pretty sure the are NOT dbase files, however mapserver reads them
> > just fine when querying the map. What I want to do is query these
> > files without displaying a map, but show the results of thedata found.
> > Currently I put the data in mysql, but I want to make my application
> > 100% mapserver driven. Then I just search on the mysql database  using
> > sql. So thats what I want to do with mapserver.
> >
> > -Jim
> >
> > ----- Original Message -----
> > From: "Puneet Kishor" <pkishor at geoanalytics.com>
> > To: "'Jim Burnett'" <r000t at adelphia.net>;
> > <mapserver-users at lists.gis.umn.edu>
> > Sent: Tuesday, March 25, 2003 5:08 PM
> > Subject: RE: [Mapserver-users] Re: Query data PHP/Mapscript
> >
> >
> > > please reply to the email list... others may have better ideas than
> > > me.
> > >
> > >
> > > > -----Original Message-----
> > > > From: Jim Burnett [mailto:r000t at adelphia.net]
> > > > Sent: Tuesday, March 25, 2003 3:58 PM
> > > > To: pkishor_98
> > > > Subject: Re: [Mapserver-users] Re: Query data PHP/Mapscript
> > > >
> > > >
> > > > I was hoping to not have to use odbc. Is there anyway to access
> > > > the information via mapserver? I could do a query, show the query
> > > > on the map and in templates.
> > >
> > > when you say "I could do a query" do you mean that you are able to
> > > do so,
> > or
> > > you would like to do so?
> > >
> > > I am not sure of the capabilities of the dbase methods that have
> > > been recently built in mapserver, but my sense is that they also
> > > access only
> > dbf
> > > files that are actually dbase compatible. The problem is, dbf files
> > created
> > > by foxpro are not really true dbf files... they just happen to have
> > > the
> > .dbf
> > > extension. If that is what you have, odbc may be the only way out,
> > > unless you can find a foxpro driver for php (I seriously doubt
> > > that).
> > >
> > > So, first determine what exactly these dbf files are. Then use the
> > > appropriate way to access them.
> > >
> > > Hope this helps.
> > >
> > > Puneet.
> > >
> > >
> > >
> > >
> > > >
> > > > ----- Original Message -----
> > > > From: "pkishor_98" <pkishor at geoanalytics.com>
> > > > To: <mapserver-users at lists.gis.umn.edu>
> > > > Sent: Tuesday, March 25, 2003 4:37 PM
> > > > Subject: [Mapserver-users] Re: Query data PHP/Mapscript
> > > >
> > > >
> > > > > --- In mapserver-users at yahoogroups.com, "Jim Burnett"
> > > > <r000t at a...> wrote:
> > > > > > Yeah I looked in the dbase methods but they dont work
> > > > > > with any of the dbf
> > > > > > files I have. Actually Excel and Access can even read
> > > > > > them.  Any clues?
> > > > >
> > > > > I am assuming you meant to write "Actually Excel and Access
> > > > > _can't_ even read..."
> > > > >
> > > > >
> > > > > Since neither Excel nor Access can read these dbf files, they
> > > > > are probably not dbf files created by dbase, or compatible with
> > > > the dbase
> > > > > format. In all likelihood, these are foxpro files. In which
> > > > case, your
> > > > > best bet would be to use the foxpro odbc driver, and access
> > > > the files
> > > > > as odbc datasources.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: "pkishor_98" <pkishor at g...>
> > > > > > To: <mapserver-users at l...>
> > > > > > Sent: Tuesday, March 25, 2003 3:57 PM
> > > > > > Subject: [Mapserver-users] Re: Query data PHP/Mapscript
> > > > > >
> > > > > >
> > > > > > > --- In mapserver-users at yahoogroups.com, "Jim Burnett"
> > > > <r000t at a...>
> > > > > wrote:
> > > > > > > > Hey all, looks like spring is here at last!
> > > > > > > >
> > > > > > > > Anywho, I want to search a dbf file for some data (
> > > > not map ). For
> > > > > > > example I have a parcel layer that I want to search on.
> > > > I want to get
> > > > > > > all the "smiths" or whatever I want to search on. Can
> > > > this be done?
> > > > > > >
> > > > > > >
> > > > > > > sure... check out the dbase methods in php. make sure
> > > > php is compiled
> > > > > > > with dbase.
> > > > > > >
> > > > > > > since dbf is a crummy format, you will have to loop
> > > > through each row,
> > > > > > > and within each row, loop through each field, unless
> > > > you know which
> > > > > > > field you are searching for, until you find what you
> > > > are looking for.
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > > Mapserver-users mailing list
> > > > > > > Mapserver-users at l...
> > > > > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > > > >
> > > > > > _______________________________________________
> > > > > > Mapserver-users mailing list
> > > > > > Mapserver-users at l...
> > > > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > > >
> > > > > _______________________________________________
> > > > > Mapserver-users mailing list
> > > > > Mapserver-users at lists.gis.umn.edu
> > > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > >
> > > _______________________________________________
> > > Mapserver-users mailing list
> > > Mapserver-users at lists.gis.umn.edu
> > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > >
> >
> > _______________________________________________
> > Mapserver-users mailing list
> > Mapserver-users at lists.gis.umn.edu
> > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> >
>
>