[postgis-users] problem using st_colormap in a command string

[Liglio Cavalcante]

Hi,

I have a problem to separate lines in the argument "colormap". I am using a
npgsql driver, and concatenating a command string to use the function
st_colormap. What can I use to break lines ?

-- This is not working: Chr(10) = ASCII LineFeed
strColorMap &= "nv 0 0 0 0" & Chr(10)
strCores &= val_nivel1 & " 255 0 145 255" & Chr(10)
strCores &= val_nivel2 & " 181 19 111 255" & Chr(10)
strCores &= val_nivel3 & " 19 0 104 255" & Chr(10)
strCommand = "SELECT ST_ColorMap( rast, '" + strColorMap + "') as rast FROM
tb_rasterdensity"

To look like this:
ST_ColorMap( rast, 
'nv 0 0 0 0
0.5 255 0 145 255
1 181 19 111 255
3 19 0 104 255
') as rast FROM tb_rasterdensity)




--
View this message in context: http://postgis.17.x6.nabble.com/problem-using-st-colormap-in-a-command-string-tp5010778.html
Sent from the PostGIS - User mailing list archive at Nabble.com.