[Mapserver-users] PB with mapinfo table query
Xavier Mauclaire
xavier.mauclaire at strategis.fr
Fri Mar 26 00:10:04 PST 2004
This is a multi-part message in MIME format.
------=_NextPart_000_0018_01C41312.2055F5E0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0019_01C41312.2055F5E0"
------=_NextPart_001_0019_01C41312.2055F5E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
hi
i'v done a query using MapInfo attributes field. When the query is computed,
some fields are not replaced with their values.
the structure of my mapinfo tab file is :
!table
!version 300
!charset WindowsLatin1
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]
regards
Xavier MAUCLAIRE
Conseils et développements en SIG STRATEGIS S.A.
Parc 2000
19, rue Joe Dassin
34184 Montpellier Cedex 4
Tél. +33 (0) 4.67.40.75.40
Fax +33 (0) 4.67.40.75.41
www.strategis.fr
------=_NextPart_001_0019_01C41312.2055F5E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D130034407-26032004><FONT =
size=3D2>hi</FONT></SPAN></DIV>
<DIV><SPAN class=3D130034407-26032004><FONT size=3D2>i'v done a query =
using MapInfo=20
attributes field. When the query is computed, some fields are not =
replaced with=20
their values.</FONT></SPAN></DIV>
<DIV><SPAN class=3D130034407-26032004><FONT =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D130034407-26032004><FONT size=3D2>the structure of my =
mapinfo tab=20
file is : </FONT></SPAN></DIV>
<DIV><SPAN class=3D130034407-26032004><FONT =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D130034407-26032004><FONT =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D130034407-26032004><FONT size=3D2>!table<BR>!version=20
300<BR>!charset WindowsLatin1</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=3D130034407-26032004><FONT size=3D2>Definition =
Table<BR> Type=20
NATIVE Charset "WindowsLatin1"<BR> Fields 10<BR> =
ID=20
Integer Index 1 ;<BR> TYPE Char (3) =
;<BR> =20
ORIENTATIO Decimal (16, 3) ;<BR> NODE_ Decimal (11, 0) =
;<BR> SYMBOL Decimal (5, 0) ;<BR> =
NETSTAT=20
Decimal (3, 0) ;<BR> IDENT Decimal (6, 0)=20
;<BR> OBSERV Char (128) ;<BR> BITNUM =
Decimal=20
(5, 0) ;<BR> BITCAN Char (254) =
;<BR></FONT></SPAN></DIV>
<DIV><SPAN class=3D130034407-26032004><FONT =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D130034407-26032004><FONT =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D130034407-26032004><FONT size=3D2>my template file is =
</FONT></SPAN></DIV>
<DIV><SPAN class=3D130034407-26032004><FONT =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D130034407-26032004><FONT =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D130034407-26032004><FONT size=3D2><!DOCTYPE HTML =
PUBLIC=20
"-//W3C//DTD HTML 4.0 Transitional//EN"></FONT></SPAN></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><SPAN class=3D130034407-26032004><FONT=20
size=3D2><html><BR><head><BR> <title>Interrogation=
=20
PPR</title><BR> <link rel=3D"stylesheet" type=3D"text/css" =
href=3D"[web_cheminsite]style.css"><BR></head></FONT></SPAN></DI=
V>
<DIV><FONT size=3D2></FONT> </DIV><SPAN =
class=3D130034407-26032004><FONT=20
size=3D2>
<DIV><BR><body=20
onBlur=3D"window.focus()"><BR><table><BR><tr><td><=
;b>=20
ORGANE : </b> =
</td></tr><BR><tr><td><b> ID :=20
</b> [id] </td></tr><BR><tr><td><b> =
TYPE :=20
</b> [TYPE] =
</td></tr><BR><tr><td><b> NODE :=20
</b> [NODE_] =
</td></tr><BR><tr><td><b>=20
Orientation : </b> [ORIENTATIO]=20
</td></tr><BR><tr><td><b> Observations :=20
</b> [OBSERV] =
</td></tr><BR><tr><td><b>=20
bitnum : </b> [BITNUM]=20
</td></tr><BR><tr><td><b> bitcan : =
</b>=20
[BITCAN] </td></tr></DIV>
<DIV> </DIV>
<DIV></table><BR></body></DIV>
<DIV> </DIV>
<DIV></html></FONT></SPAN></DIV>
<DIV><SPAN class=3D130034407-26032004><FONT =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D130034407-26032004><FONT =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D130034407-26032004><FONT size=3D2>In this =
sample :=20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D130034407-26032004><FONT size=3D2>[ID] value is =
replace with a=20
very big number but not the good value</FONT></SPAN></DIV>
<DIV><SPAN class=3D130034407-26032004>
<DIV><SPAN class=3D130034407-26032004></SPAN><FONT size=3D2>[<SPAN=20
class=3D130034407-26032004>NODE_], </SPAN></FONT><FONT size=3D2><SPAN=20
class=3D130034407-26032004>[ORIENTATIO]and [BITCAN] are not=20
replaced.</SPAN></FONT></DIV>
<DIV><FONT size=3D2><SPAN =
class=3D130034407-26032004></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN class=3D130034407-26032004>the result=20
is</SPAN></FONT></DIV>
<DIV><FONT size=3D2><SPAN =
class=3D130034407-26032004></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN class=3D130034407-26032004>
<TABLE>
<TBODY>
<TR>
<TD><B>ORGANE : </B></TD></TR>
<TR>
<TD><B>ID : </B>10802878981808 </TD></TR>
<TR>
<TD><B>TYPE : </B>1 </TD></TR>
<TR>
<TD><B>NODE : </B>[NODE_] </TD></TR>
<TR>
<TD><B>Orientation : </B>[ORIENTATIO] </TD></TR>
<TR>
<TD><B>Observations : </B>SIGVD </TD></TR>
<TR>
<TD><B>bitnum : </B>370 </TD></TR>
<TR>
<TD><B>bitcan : </B>[BITCAN] =
</TD></TR></TBODY></TABLE></SPAN></FONT></DIV>
<DIV><FONT size=3D2><SPAN =
class=3D130034407-26032004></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN class=3D130034407-26032004></SPAN></FONT><FONT =
size=3D2><SPAN class=3D130034407-26032004></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN=20
class=3D130034407-26032004>regards</SPAN></FONT></DIV></SPAN></DIV>
<STYLE>BODY {
FONT-SIZE: 10px; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
TD {
FONT-SIZE: 10px; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
TH {
FONT-SIZE: 10px; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
SELECT {
FONT-SIZE: 10px; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
TABLE {
BORDER-RIGHT: black 0px solid; BORDER-TOP: black 1px solid; =
BORDER-LEFT: black 0px solid; BORDER-BOTTOM: black 1px solid; =
BACKGROUND-COLOR: white
}
.nom {
FONT-WEIGHT: bold; FONT-SIZE: 10px; COLOR: #0000cd; TEXT-ALIGN: center
}
.fonction {
FONT-WEIGHT: normal; FONT-SIZE: 10px; COLOR: black; TEXT-ALIGN: center
}
.nomsociete {
FONT-WEIGHT: bold; FONT-SIZE: 12px; COLOR: #000080; LETTER-SPACING: =
2px; TEXT-ALIGN: center
}
.adressesociete {
FONT-WEIGHT: normal; FONT-SIZE: 10px; COLOR: #0000cd; TEXT-ALIGN: =
center
}
.telfaxsociete {
FONT-WEIGHT: normal; FONT-SIZE: 10px; COLOR: #6699ff; TEXT-ALIGN: =
center
}
.liensite {
FONT-WEIGHT: normal; FONT-SIZE: 10px; TEXT-ALIGN: center
}
</STYLE>
<P></P><FONT size=3D2></FONT><FONT size=3D2></FONT>
<TABLE cellSpacing=3D0 width=3D400 border=3D0>
<TBODY>
<TR>
<TD width=3D"30%">
<DIV class=3Dnom><A =
href=3D"mailto:xavier.mauclaire at strategis.fr">Xavier=20
MAUCLAIRE</A><BR></DIV><BR>
<DIV class=3Dfonction>Conseils et d=E9veloppements en SIG =
</DIV></TD>
<TD width=3D"40%">
<DIV class=3Dnomsociete>STRATEGIS S.A.<BR></DIV>
<DIV class=3Dadressesociete>Parc 2000<BR>19, rue Joe =
Dassin<BR>34184=20
Montpellier Cedex 4<BR></DIV>
<DIV class=3Dtelfaxsociete>T=E9l. +33 (0) 4.67.40.75.40<BR>Fax +33 =
(0)=20
4.67.40.75.41 </DIV></TD>
<TD width=3D"30%">
<DIV class=3Dliensite><A href=3D"http://www.strategis.fr/"><IMG =
height=3D69=20
src=3D"cid:130034407 at 26032004-2103" width=3D79 border=3D0><BR><A=20
href=3D"http://www.strategis.fr/">www.strategis.fr</A>=20
</DIV></TD></TR></TBODY></TABLE>
<DIV> </DIV></BODY></HTML>
------=_NextPart_001_0019_01C41312.2055F5E0--
------=_NextPart_000_0018_01C41312.2055F5E0
Content-Type: image/jpeg;
name="logostrat.jpg"
Content-Transfer-Encoding: base64
Content-ID: <130034407 at 26032004-2103>
/9j/4AAQSkZJRgABAQEASABIAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsK
CwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUFBQU
FBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBT/wAARCABFAE8DASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD7w+Kn
/I1H/rgn9a8C/aQ/5I/rX+9B/wCjkrf/AGpv2g4/hl8Uf7HfQm1Emwhn85bvy/vFxjGw+nrXzv8A
Ev8AaSi+IPg290JfD72JuTGfPN4JNu1w33dgz0x1rny3hjN55tQzCND917SMr80fhUk72vfbyufn
+c5xgY08RhXU9+0laz3t6WPEKqanqtnotlJd39zFaW0Y+aWZgqj257+3eud+IHxFsPAdknmq13qU
/FtYxH55D0yfRc9/yzSaL8FZbu9i1/4xNLe6mvz2vgS2kaBLYHkfbZFO6LsDCh808h3iIAb98xmZ
+yqfVsND2lV9Oi85Pofm2Byn21L63i5+zorq95eUV1/rezKGh+Pdf+Jmqz6V8NfB2peLbmAAz3uw
xWlqpOBJK5wscf8AtytGB612Nr8PPiHFFG2seNPhdoV2y5fT5J9Rv2T6y2UNxCT/ALshroNR8S3u
oaXaaSnk6foVmSbTRtOhW2srYnqUhQBdx7uQXbqzMeay6xp4HHVXz4rEtPtBJJfNpt/M3qZjl1Be
zweETXeo22/kmkvkfdP/AATltrzQ7Hxvpupy6dczu9ncQX2kXDTWl3GVlBZC6JIjBlYNHIiuvBwQ
wJ+z6+AP2ANXYXviW0jb5re6spCB/wBNBKp/RK+/6/K85Uo5hVjKXM09/ku2lz9kyGUZZbRlCHKm
ttdNXtfW3YKKKK8U94/Nr9v/AP5L2v8A2CLb/wBCkr5J8eeNLXwL4en1K4xJJ9yCDPMsh6D6dyfQ
V9bft/8A/Je1/wCwRbf+hSV8U+Df+K3+KmoeJbpTLpPhOQW+lxH7kl+ScSn1CbS/HdYgeCc/sVDF
VKGV4enQ1qTSjH9W/JLU/DMRhKeJzjE1MQ7Uqbcpel9EvNvQ6X4aeCLj4fznxX4hAuviXfDzVaUZ
GhRkcIikYFzjHPWEYAxJuKbxOTk8k0ru0js7sXdjlmY5JPqaSvdwOBp4GnyQ1k9W3u33Z85mOYVc
xq889IrSMVtFdkFV9Qv4NLsZ7y6lENtAhkkkboqgZJqWWVIInkkdY40BZnc4CgdST2FeAePvGt98
XvE9j4K8KDzre5uFi80ttWd8/eJP3YlALEnjALHgVjmeZU8to88tZP4V3f8Al3N8oyqrmtdU46QW
spdEv8+3+R+hn/BIO8uPHlx8V/Ec8TpaHU7MQlxx8sUoVM9MqCpP1HrX6XV8Wf8ABMbQ9P8ACfgP
xToGkkPp+nTWsazhNhuZCshknYHnLtzg8hQi/wAIr7Tr8Vx1OtSxE41/j3fq1f8AU/fsvq0a2FhL
DfBsvRO36BRVS41W2t5BEZA85O0RJyxOM49vxxSqbqYgkJbr/dPzsR/IH864D0T85P2/v+S+J2/4
lNt/6FJXyD8LtLbRfBUFq/EzXd1PcDGP3pmZCfrtjQc+lfX37f8A/wAl7X/sEW3/AKFJXzVrfhPx
B4kMuqeB9V0GHWJE3X3h7xFcrZQ3EuQDcWty7pErOPmkjlkT59zJu8wqn7DhJKhg8LipRclGLWiu
1e2tu2jXzPw3GxeJx2MwcJqMpzT1dk+W+l++qav27jqxPFPjHSPB1ibrVbxLdSCUizmSUjsi9T29
hnkisTUfh5+0VqIa2TwtpGipk/8AEyOqWMVuw/2bia5MJB7EH6GqWlfsvaPot1Jq/wAVPGy6/drG
Hk0nw1d+cQQOVuNQkUxIF4/1AnDAEb04alVz6db93l9GUpd2rRXr/wAG3qOjw3TofvczrxhHsneT
9P8AgX9Dxv4i/FXWviBb3ItLeey8OwOqyLGpIYtnZ5zjjJ2khenHfGa9i+CHgGL4Y+DH8R6xts9d
1m23KbhlQWOnsAQST915hgnpiLaORKwBoi3/AO0B48tdJ8LeH7S3+HHg+aO4XQtOsZP7PLMdrXE7
tIkbZ2jdLd3URdF2+bkgV7BN4V8O6bfXF74m1eXxTrrSCURaPMrRwyfIT/pskSpHtdGI+x2ySANh
b1xzXyOCeIxGPliJxdecdrfDf12SXTvufbY9YbC5bHDU5rD05b3+K3klq2+re2x9b/8ABOXxKsPh
zxk0NldOl1NZzWs00DxRXMZEyiSIlcyplWG6MMvB54NfYaWur6uFa4k+yxHny+VH0KqdxH1Zf92v
mf8A4J7arb6vpXjqeDRtL0jN3bs/2CA+bMzLIWee4kZ57hycnfPJI3JwQOK+u68XOHWeOqPEJKel
7bbL9D38kWHWX0lhW3DW199328/wILSxgsYwkESRDAB2jGfrU9FFeOe4eO/FTSvgfd+MIl+IV34S
g8TS2LTxwa3qUMFy9rEHdpAjurGNAkjFsYAViTwa4Szt/wBkfUba9uLTXvhndW9jEJ7qWHxBautv
GXVA8hE2FUu6Lk4GWUdSKl+IevR+Av2nNJuNEXUb++8RtaW2uaBd6BcTWs8EKP5Oo2t+I/KhkgL7
HRnIYMAFRyrPyPi7wp4q1P4XePvs3n6JfXHxNtLqzM1k86xL/aNkRctGChkjUAscMMhT8y4NdccZ
iYJRjUkkvNnFPA4WpJznSi2+riv8j0K7+F/wH/sKHWLHw74au9InWN4tVFwv2NlkYLGwm37GDMyh
TuwxIAOTivMvGHw+/Zj1PxYPCeuah8O7fWEnFvPpdzrVvHJDKSAI/KaUMZMnAG0NzjmuOvPAvjL4
ofDTSPgrpfhxbu6stU1TVPFF/rV1PptheS+a7xSwzxW0gCSzXUdxHEqHaICjMChJ9o+Ea+INV+In
wu1DXdGnsNXsvCWsabrTiF/KF/Hd2cbkOyjIkMTuh43KQRxRPF4ma5Z1JNebYQwWFpyUoUop+UV/
kang7wj+zXqXhCfwz4cvvBOp+H/C6PdXWn6frMM0GnZLeZPMiSkRkndl3weMZwMCTw18Pf2a/Gdn
Hd+H08D67ay3P2NJ9N1OG4R59hk8oMkhBfYrNt64UnGBXz78O7vxFrnwi8P6FrM2o+KtD8LavYX+
seDovAmoWlxDYxzy70MspZNR2O0MpSFcsIThWyBXYa741n+O/i5nk0C51bwNb6/DHDqum+F9Q027
urR9L1NZYX88b5ni3IoZFUbpsAAnFKGLxFKPLCpJLybQ6mDw1WXPUpRb7tJn0d8FbT4XJpOpXPwt
uvD19pslwIbyfw7ex3UXnIM7HaNmAYB+mc4YetejV4d+yhrd3qXhHV7B5rnV9I0e7TTtJ8Q3+hT6
Pd6hapCgVZ4Jo4y0kJzEZFVUbZwqkMB7jWE5yqSc5u7fVnRTpwpRUKaSS6LRBRRRUGh5jbeLTDeS
3c1qLq/fiOWR/liHYBcf1/rXQ6NpzeKIY9Q1OdrhMnZaqNsa4J/P/PWiigDq441iRURQiKMBVGAB
TqKKACiiigAooooAKKKKAP/Z
------=_NextPart_000_0018_01C41312.2055F5E0--
More information about the MapServer-users
mailing list