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

[Tumasgiu Rossini]

Hi,
this is not really a postgis question.
According to npgsql website, the best way to get answers
is to post questions on stackoverflow.net with the npgsql tag.

However, to answer your question, you can use the Environement.Newline
property
to create a string value containing line feeds.
Note that this property will output \r\n
or \n depending of the platform running your code (NT \ linux).
Note that the interpretation of the sequence will depend of your platform
too.

If you just want to lay an instruction over mutliple line,
you can add a _ at the end of each line (except the last one).

2016-12-28 21:57 GMT+01:00 Liglio Cavalcante <liglio.pessoal at nexxa.com.br>:

> 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.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161228/1e17134e/attachment.html>