[Mapserver-users] PB with mapinfo table query

Fri Mar 26 01:08:17 PST 2004

Salut Xavier,

I think the templates are case sensitive, i.e. [id] must be [ID].

One guess for the others would be that the names in the MapInfo data 
file (actually a dbase file) are different than the ones in the TAB file 
(OGR or mitab maintainers will know exactly).  I had a similar problem 
after I renamed column names in MapInfo or after copying mapinfo tables. 
  Try to create a new table (with short column names) and fill it with 
the data of your original table.

Regards,	Frank

Xavier Mauclaire wrote:

> Definition Table
>   Type NATIVE Charset "WindowsLatin1"
>   Fields 10
>     ID Integer Index 1 ;
>     TYPE Char (3) ;
>     ORIENTATIO Decimal (16, 3) ;
>     NODE_ Decimal (11, 0) ;
>     SYMBOL Decimal (5, 0) ;
>     NETSTAT Decimal (3, 0) ;
>     IDENT Decimal (6, 0) ;
>     OBSERV Char (128) ;
>     BITNUM Decimal (5, 0) ;
>     BITCAN Char (254) ;
>  
>  
> my template file is
>  
>  
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>  
> <html>
> <head>
>  <title>Interrogation PPR</title>
>  <link rel="stylesheet" type="text/css" href="[web_cheminsite]style.css">
> </head>
>  
> 
> <body onBlur="window.focus()">
> <table>
> <tr><td><b> ORGANE : </b> </td></tr>
> <tr><td><b> ID : </b> [id] </td></tr>
> <tr><td><b> TYPE : </b> [TYPE] </td></tr>
> <tr><td><b> NODE : </b> [NODE_] </td></tr>
> <tr><td><b> Orientation : </b> [ORIENTATIO] </td></tr>
> <tr><td><b> Observations : </b> [OBSERV] </td></tr>
> <tr><td><b> bitnum : </b> [BITNUM] </td></tr>
> <tr><td><b> bitcan : </b> [BITCAN] </td></tr>
>  
> </table>
> </body>
>  
> </html>
>  
>  
> In this sample :
> [ID] value is replace with a very big number but not the good value
> [NODE_], [ORIENTATIO]and [BITCAN] are not replaced.
>  
> the result is
>  
> *ORGANE : *
> *ID : *10802878981808
> *TYPE : *1
> *NODE : *[NODE_]
> *Orientation : *[ORIENTATIO]
> *Observations : *SIGVD
> *bitnum : *370
> *bitcan : *[BITCAN]
> 