[mapguide-users] Mapguide 3.0 Postgre view problem

[sebafr]

solution 1: (for programers people !) note: '' is two Single quotation marks 

guide_generic_search_table('CASE  when owner = 1 THEN ''one''  when  owner =
2 then ''TWO'' END ', 'piping.pipe', 'pipe.dp_oid=' || symg.dp_oid) AS owner

solution 2: (for normal people!)

create a view vw_pipe with the field CASE  when owner = 1 THEN 'one'  when 
owner = 2 then 'TWO' END and use then on fuction:

guide_generic_search_table('field_case', 'piping.vw_pipe', 'pipe.dp_oid=' ||
symg.dp_oid) AS owner





--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-3-0-Postgre-view-problem-tp5298765p5299224.html
Sent from the MapGuide Users mailing list archive at Nabble.com.