Home Automation Domotica Forum Europe, Bwired Forum

Yup, i have that, it's stored in a field called Time that is setup as Time

Morten

seems that my problem was the Count field, i was storing them devided by 250 (250 counts pr Kwh) so the results in the sql fiels alwas included a " , ", mysql dosen seem to like that :) all is looking good now. i am not very good at this sql stuff, so can somone help me out with a quary th...

Thansk for you help Willem, i read in the mysql doc about that, and even tryed with Now(), but when i check my sql db afterwards, it still shows the data in the order as : dd mm yyyy, maybe this is just win xp fooling me ? i will delete the whole db and start from scratch, and only use Now() for sto...

Ok, will try with sql manager when i get back from work.

my fields are set up like this Time = time, Date = date, Count = char and is typical like : 0,026

this should be correct ?

Regards
Morten

Still having problem here Pieter, hope you have som time to help me out :) i get this chart after 5 days of loging: http://www.domoticaforum.eu/uploaded/Spawn32/2006121292628_myimage.GIF as you see it only shows 3 bars for 5 days, very odd, in the DB there is correct data for all days :/ i use this ...

Ok, thanks after i wrote my last reply, that chart updated to a new scale from 0 to 3 and showing a width bar going from 0 to 2, so that must be the current day (yes i know, using to mutch Kw's here :) but i thout with that sql setup that i would show more than just the current day ? strSQL = "...

That fixed it, HS2 can't handle the Session stuff, IIS works, chartdirecor demos works as well, tested your asp with my DB but in only makes a chart going from 0 and up to 150, with no data :( i save the my data 1 timepr min and divide the count with 250 before saving to "Count" in my DB (...

Hi, diden help :( your chartimage.asp dosen exist in Chard. 3.1 or 4.1, but found out from the demos that you probaly mean getchart.asp ? anyway, i am now trying to get the aspdemo : dbdemo3 to work, but get the same error in that one : Script error: Type mismatch chart1URL = c.makeSession(Session, ...

Thanks for you help :) but i am having some problems, i get this error on the asp code you gave me, and on most / all of the examples in the chartdirector as well: Script error: Type mismatchchart1URL = c.makeSession(Session, "chart11") 'Create an image map for the chart imageMap = c.getHT...

Hi Pieter, I have managed to get my own Electricity logger ruining and storing everything to a sql DB, works very nice, the setup i very similar to yours, but could you help me out with with one of you nice Chardirector / asp setups ? i am not very good with asp, try-ed you phone asp example but tha...