[mapguide-users] Re: Choosing Column for Colour

[GordonL]

Ok, since the data is a string in SQL Server, I had to RTRIM before I used a
ToInt64

for example:

ToInt64(RTRIM(COLOUR))

And the COLOUR had to be in DECIMAL (429490176) for this to work.

I will have to convert the Hex to Decimal before posting into SQL.

Thanks for the help!


--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Choosing-Column-for-Colour-tp6953634p6957507.html
Sent from the MapGuide Users mailing list archive at Nabble.com.