<DIV>Hi Alberto,</DIV>
<DIV>Thank you very much! I tried it and it works fine.</DIV>
<DIV>Charlie<BR><BR><B><I>Alberto Cavalli <alberto.cavalli@sintranet.it></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<DIV><SPAN class=862552312-19082004><FONT face=Arial> Hi Charlie,</FONT></SPAN></DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial>the code is very simple and it is only a starting point for building a custom query:</FONT></SPAN></DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial>INFO, NUM_FOGLIO, NUM_PART, AREA, INFO_ID and ESPR1 are the fields of dbf of one layer. </FONT></SPAN></DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial></FONT></SPAN> </DIV><FONT size=+0><SPAN class=862552312-19082004><I>
<P><FONT face=Arial><SPAN class=862552312-19082004>//</SPAN>loop and use key for titles## <SPAN class=862552312-19082004>field from dbf that you want to display when you make a query</SPAN></FONT></P>
<P></I><FONT face=Arial><B>foreach</B> (<B>$aRows</B>[0] <B>as</B> <B>$key</B> => <B>$value</B>)<BR>{<BR><B>if</B> (<B>strcasecmp</B>(<B>$key</B>, <I>"INFO"</I>) == <I>"INFO"</I> ||<BR><B>strcasecmp</B>(<B>$key</B>, <I>"NUM_FOGLIO"</I>) == <I>"NUM_FOGLIO"</I> ||<BR><B>strcasecmp</B>(<B>$key</B>, <I>"NUM_PART"</I>) == <I>"NUM_PART"</I> ||<BR><B>strcasecmp</B>(<B>$key</B>, <I>"AREA"</I>) == <I>"AREA"</I> )</FONT></P>
<P><SPAN class=862552312-19082004></SPAN><FONT face=Arial>T<SPAN class=862552312-19082004>his part of code generate the titels of field that appear when you make a query</SPAN><BR></FONT></P>
<P><I><FONT face=Arial></FONT></I> </P>
<P><FONT face=Arial><I>// loop and add a cell for each result## <SPAN class=862552312-19082004>field that you don't want to display when you make a query</SPAN><BR></I><B>foreach</B> ( <B>$aRow</B> <B>as</B> <B>$key</B> => <B>$xCell</B> )<BR>{<BR><B>if</B> (<B>strcasecmp</B>(<B>$key</B>, <I>"INFO_ID"</I>) == 0 ||<BR><B>strcasecmp</B>(<B>$key</B>, <I>"<SPAN class=862552312-19082004>ESPR1</SPAN>"</I>) == 0)</FONT></P>
<DIV><SPAN class=862552312-19082004><FONT face=Arial>This part of code remove the value of field thath you don't want to display</FONT></SPAN></DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial>use the same way to customize a query for multiple layer</FONT></SPAN></DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial>for example:</FONT></SPAN></DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial>first layer dbf: 3 field (id, area perimeter)</FONT></SPAN></DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial>second layer dbf: 2 layer (name, dimension)</FONT></SPAN></DIV>
<DIV><FONT face=Arial><SPAN class=862552312-19082004>If you want to display only id, area and dimension use </SPAN><SPAN class=862552312-19082004>this is the code</SPAN></FONT></DIV>
<DIV><SPAN class=862552312-19082004><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=862552312-19082004><I>
<P><FONT face=Arial>// loop and use key for titles## CAMPI DA INCLUDERE<BR></FONT></I><FONT face=Arial><B>foreach</B> (<B>$aRows</B>[0] <B>as</B> <B>$key</B> => <B>$value</B>)<BR>{<BR><B>if</B> (<B>strcasecmp</B>(<B>$key</B>, <I>"I<SPAN class=862552312-19082004>D</SPAN>"</I>) == <I>"I<SPAN class=862552312-19082004>D</SPAN>"</I> ||<BR><B>strcasecmp</B>(<B>$key</B>, <I>"<SPAN class=862552312-19082004>AREA</SPAN>"</I>) == <I>"<SPAN class=862552312-19082004>AREA</SPAN>"</I> ||<BR><B>strcasecmp</B>(<B>$key</B>, <I>"<SPAN class=862552312-19082004>DIMENSION</SPAN>"</I>) == <I>"<SPAN class=862552312-19082004>DIMENSION</SPAN>"</I> )<BR><BR><B>$szReturnValue</B> .= <I>"<td bgcolor=\"E2EFF5\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">"</I>.<B>$key</B>.<I>"</font></td>\n"</I>;<BR>}<BR><B>$szReturnValue</B> .= <I>"</tr>\n"</I>;<BR><BR></FONT><FONT face=Arial><I>// loop through the results and format each row<BR></I><B>foreach</B> ( <B>$aRows</B>
<B>as</B> <B>$aRow</B> )<BR>{<BR></FONT><FONT face=Arial><I>// add a row for each<BR></I><B>$szReturnValue</B> .= <I>"</tr>\n"</I>;<BR><BR></FONT><FONT face=Arial><I>// loop and add a cell for each result## CAMPI DA ESCLUDERE<BR></I><B>foreach</B> ( <B>$aRow</B> <B>as</B> <B>$key</B> => <B>$xCell</B> )<BR>{<BR><B>if</B> (<B>strcasecmp</B>(<B>$key</B>, <I>"<SPAN class=862552312-19082004>NAME</SPAN>"</I>) == 0 ||<BR><B>strcasecmp</B>(<B>$key</B>, <I>"PERIMETER"</I>) == 0)<BR><B>continue</B>;<BR><B>$szReturnValue</B> .= <I>"<td bgcolor=\"E2EFF5\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">"</I>.<B>$xCell</B>.<I>"</font></td>\n"</I>;<BR>}<BR><BR><B>$szReturnValue</B> .= <I>"</tr>\n"</I>;<BR>}</FONT><BR><BR><SPAN class=862552312-19082004><FONT face=Arial>Very important: be careful, use the righr sequency of field!!!!!!!!</FONT></SPAN></P>
<P><SPAN class=862552312-19082004><FONT face=Arial></FONT></SPAN> </P>
<P><SPAN class=862552312-19082004><FONT face=Arial></FONT></SPAN> </P>
<P><SPAN class=862552312-19082004><FONT face=Arial>Have a good work</FONT></SPAN></P>
<P><FONT size=1><SPAN class=862552312-19082004><FONT face=Arial size=3>Alberto</FONT></SPAN></P></FONT></SPAN></DIV>
<DIV><FONT color=#008000 size=1></FONT> </DIV>
<DIV></SPAN></FONT><SPAN class=862552312-19082004><FONT color=#008000 size=1></FONT></SPAN> </DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Messaggio originale-----<BR><B>Da:</B> charley cheng [mailto:chengcharlie2003@yahoo.ca]<BR><B>Inviato:</B> gioved?19 agosto 2004 6.31<BR><B>A:</B> Alberto Cavalli<BR><B>Cc:</B> maplab help<BR><B>Oggetto:</B> Re: [maplab-users] code for custom query (Sorry for previous mail)<BR><BR></FONT></DIV>
<DIV>Hi! Alberto,</DIV>
<DIV>For unknown reasons, my previous mail has been cut. I am terrible sorry for it! I have to send again.</DIV>
<DIV> </DIV>
<DIV>Thank you very much for you code! I really need the code to display the only attributes in shapefile I want display.</DIV>
<DIV> </DIV>
<DIV>Could you give me a little more explaination about your code?</DIV>
<DIV>INFO, NUM_FOGLIO, NUM_PART, AREA are the attributes in shapefile you want to display.</DIV>
<DIV>What is INFO_ID and ESPR1?</DIV>
<DIV> </DIV>
<DIV>Thank you very much!</DIV>
<DIV> </DIV>
<DIV>Charlie<BR><BR></DIV></BLOCKQUOTE></BLOCKQUOTE><p><br><hr size=1>Post your free ad now! <a href="http://ca.personals.yahoo.com/"><b>Yahoo! Canada Personals</b></a><br>