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

[Jon Shorie]

It is possible that what you are dealing with are actually .db files from a 
boorland product such as delphi or paradox.  They are very similar to .dbf 
files except that they do not have a record number as the first field in 
them.  This breaks the .dbf standard (and probably the ms excel and ms 
access) .dbf filters, but I do not think that it would be a problem for 
mapserver (perhaps someone else can shed some light on this).  If the .db 
files are renamed .dbf then it may be possible to still make use of them.  A 
good way to check is to see if (after renaming to .db) the file can be opened 
in quattro pro, paradox, or delphi.

On Wednesday 26 March 2003 08: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