It could be related to the strange behaviour of Postgres with regard to
upper case names of fields. If they contain upper case characters a
query has to put column names in double quotes. But in this case the PHP
error log should spit out a warning that the column SUBNAME does not exist.
The attribute search makes a direct connection to Postgres, without
quoting field names when upper case characters might appear. I would
therefore recommend using only lower case field names and then it should
work. To make things more confusing, if columns are only lower case you
can specify them in the query in upper case (or arbitrary mixed case)
and it works...
armin
shailesh gavathe wrote:
> Hi list,
>
>
> I am having some trouble with querying the attribute from postgis layer
> types.
>
> I was able to do query search working for me, when i tried with the
> shapefile dataset.
>
> But when i try with postgis layer types, it says "no record found"
>
> the codes from js_custom.php are
>
> searchList['counties'] = new Array('<?php echo _p("County")?>',
> '#SUBNAME', 'Counties','<?php echo _p("County") ?>','');
>
> 'counties' = postgis layer name
> 'County' = names appear on a template for search
> 'Counties' = postgis table
>
> Where would i be wrong ?
>
> thanking you,
>
>
> shail ,
>
> URL http://people.emich.edu/sgavathe
>
>
>
>
> ------------------------------------------------------------------------
> With MSN Spaces email straight to your blog. Upload jokes, photos and
> more. It's free! It's free!
> <http://clk.atdmt.com/MSN/go/msnnksac0030000001msn/direct/01/?href=http://www.imagine-msn.com/spaces>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pmapper-users mailing list
> Pmapper-users at faunalia.it
> http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users
