multiple field query

[Blaise]

Works great. Thanks a lot, Steve.
Blaise

Le Lundi 17 Juillet 2006 23:51, Steve Lime a écrit :
> You can create multiple field queries, it's just a matter of getting the
> query string right, much like getting SQL right I guess except that might
> be easier ;-)...
>
> Two things to remember:
>
>   - in MapServer ' = ", you can quote strings with either (in pairs)
>   - strings *must* be quoted on both sides of the operand
>
> So:
>
>   $qstring="([CARF_T]=$acarf OR '[CARF_A]'=$acarf)" ;
>
> should probably be:
>
>   $qstring = "('[CARF_T]'='$acarf' OR '[CARF_A]'='$acarf')" ;
>
> Steve
>
> Stephen Lime
> Data & Applications Manager
>
> Minnesota DNR
> 500 Lafayette Road
> St. Paul, MN 55155
> 651-259-5473
>
> >>> Blaise <bpicinbono at WORLDONLINE.FR> 7/17/2006 3:38:53 PM >>>
>
> hi there
> I've searched a bit in the archives but I can't figure it out.
> I am able to query an single field of a dbf table this way :
>
> $amteacarf=42;
> $qLayer=$zeMap->getLayerByName("metacarflink");
> $result=@$qLayer->queryByAttributes("METACARF",$ametacarf,MS_MULTIPLE);
> $res_count = $qLayer->getnumresults();
>
> Now I would like to query a layer for (one field = something) OR (another
> field = something)
> I tryed this way :
>
> $qLayer=$zeMap->getLayerByName("tron");
> $qstring="([CARF_T]=$acarf OR '[CARF_A]'=$acarf)" ;
> $result=@$qLayer->queryByAttributes('CARF_T',$qstring,MS_MULTIPLE);
> $res_count = $qLayer->getnumresults();
>
> I tryed different syntaxes but I am a bit lost with single and double quote
> and the right syntax.
> For now, I am stuck with processing a double query, which might be more
> time consuming.
> Anyone can help, please ?
> Thanks
> Blaise