[OpenLayers-Users] include quesry in data source in map file

[S.Reena]

hey Paul.......I will take care about this from the next time ...n Thanks 4
the solution ...it worked :)

Regards,
Reena.



Paul Spencer-5 wrote:
> 
> this is definitely the wrong list for this question, you should be  
> asking on mapserver-users or even the postgis list.
> 
> In any case, the correct way to specify a sub-select for postgis is:
> 
> DATA "the_geom from (select * from my_table WHERE name like 'abc') as  
> foo using unique gid using srid=-1"
> 
> Things to note:
> 
> your sub-select must return the_geom, gid and any other attributes  
> that you are using elsewhere (for labelitem, classitem, etc).
> 
> gid might be called something else, it just needs to be a unique value  
> such as the primary key of your table.
> 
> Cheers
> 
> Paul
> 
> On 28-Jun-08, at 7:14 AM, Reena Singh wrote:
> 
>> I want to use query in the map file like ........
>>
>> DATA "the_geom FROM my_table WHERE name like 'abc' "
>>
>> but this is not working accr to the format.
>>
>> Can ne1 hlp?
>>
>> --
>> Be Yourself @ mail.com!
>> Choose From 200+ Email Addresses
>> Get a Free Account at www.mail.com!
>> _______________________________________________
>> Users mailing list
>> Users at openlayers.org
>> http://openlayers.org/mailman/listinfo/users
> 
> _______________________________________________
> Users mailing list
> Users at openlayers.org
> http://openlayers.org/mailman/listinfo/users
> 
> 

-- 
View this message in context: http://www.nabble.com/include-quesry-in-data-source-in-map-file-tp18169693p18189663.html
Sent from the OpenLayers Users mailing list archive at Nabble.com.