[Chameleon] problems joining shp file to database with OGR

[JBaum at townofbethlehem.org]

I did, and found that only the tables, not the views are available.  Its
the view I was after.

This leads me to a second question.  Is it possible in my SQL statement in
the .map file (or .ovf) to have a complex SQL query with joins and so on?

How would I construct that in order to be able to join to the key field in
the .shp file?

Thanks,
Jason


                                                                           
             Normand Savard                                                
             <nsavard at mapgears                                             
             .com>                                                      To 
                                       JBaum at townofbethlehem.org           
             01/15/2008 09:21                                           cc 
             AM                        chameleon at lists.maptools.org        
                                                                   Subject 
                                       Re: [Chameleon] problems joining    
                                       shp file to database with OGR       
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




JBaum at townofbethlehem.org wrote:

>I have a shape file of parcels with only a pimary key field in it (parcel
>ID).  I have a database with the parcel ID data as a foreign key, along
>with all other relevant data in Sybase 9, which is our RPS database.  I am
>trying to use an ODBC connection in OGR to connect the database, but I get
>an error in the Apache Log:
>Unable to load dynamic library '/ms4w/Apache/php/extensions/php_msql.dll'
-
>The specified module could not be found.
>
>I am using thre same code and procedure to connect to a MS Access databas
>successfully.  What could be wrong?
>
>Apache 2.0.55
>PHP 4.4.3-dev
>MapServer version 4.6.1
>
>
>
Jason,

Did you test your ODBC link with ogrinfo included in the ms4w package?

Norm