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

[Puneet Kishor]

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
>