[rain0total-daysum=in.2:--] value always '0'

[gazn357]

My rain0total-daysum value uploaded to my SQL database is always zero. Rain rate and rain fall YTD is correct.

Any ideas anyone? My SQL Query is below. I have tried [rain0total-daysum=in.2:--] and [rain0total-sumday=in.2:--].

Thanks,
Danny


insert upload (DateUTC, TimeUTC, temp, wind, avgwind, winddir, rainrate, totalrain, rainYTD, hum, dew, heatindex, press) values ([UYYYY][UMM][UDD], [Uhh][Umm][Uss], [th0temp-act=F.1:--], [wind0wind-act=mph.1:--], [wind0avgwind-act=mph.1:--], [wind0dir-act.1:--], [rain0rate-act=in.1:--], [rain0total-daysum=in.2:--], [rain0total-yearsum=in.2:--], [th0hum-act.1:--], [th0dew-act=F.1:--], [th0heatindex-act=F.1:--], [thb0seapress-act=inHg.2:--])

[admin]

I have today 0.1 inch rain and when I use [rain0total-daysum=in.2:--] as template it reports "0.01"
I probed the template in a Meteobridge generated email to myself. Works fine.

May be there is a bug in your SQL statement?