RE: Charting software for web use?

["Paul Smith" <ukha@xxxxxxxxxxxxx>]

Hi Paul,

What program language would you use.

This is a very simple bit of vb code that I did to connect to mysql,
serial port in vb is also very easy too, just note that there is no
error checking in this.


Dim MyConn As ADODB.Connection
Dim MyRecSet As ADODB.Recordset
Set MyRecSet = New ADODB.Recordset
Set MyConn = New ADODB.Connection

MyConn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=192.168.250.1;" _
& "DATABASE=meter-readings;" _
& "UID=*********;" _
& "PWD=*********;"

MyConn.Open


total = 0


Do Until MyRecSet.EOF

total = total + MyRecSet("Reading")

MyRecSet.MoveNext
Loop

MsgBox (total)

MyRecSet.Close


MyConn.Close



Very easy and to link to mysql on a server.


Regards,

Paul


-----Original Message-----
From: ukha_d@xxxxxxx [mailto:ukha_d@xxxxxxx] On Behalf
Of Paul Gale
Sent: 13 May 2005 11:27
To: ukha_d@xxxxxxx
Subject: RE: [ukha_d] Charting software for web use?

Just had a look at this software - very impressive.

Only trouble is, I now need to work out how to get the data into a dB
such as mySQL - not done too much in mySQL though :(

Paul.



> -----Original Message-----
> From: ukha_d@xxxxxxx [mailto:ukha_d@xxxxxxx] On Behalf
Of
> Paul Smith
> Sent: 13 May 2005 10:54
> To: ukha_d@xxxxxxx
> Subject: RE: [ukha_d] Charting software for web use?
>
> Hi Paul,
>
> 	I created a simple vb app which counted the number of pluses on
> the CD line on a com port. It then every minute dumps the count into a
> my sql database.
>
> Then using php and mysql, and this tool
> http://www.maani.us/charts/index.php
>   I generate bar charts to show the various totals, for hour, day,
month
> and year. This works well and free if you are happy for the click on
the
> chart to take you there website.
>
> If you however have the need to drill down into the data then you have
> to pay for it. But it's cheap.
>
> As an aside how are you measuring the PH and getting this into a pc.
>
>
> Regards,
>
> Paul
>
>
> -----Original Message-----
> From: ukha_d@xxxxxxx [mailto:ukha_d@xxxxxxx] On Behalf
> Of Paul Gale
> Sent: 13 May 2005 09:51
> To: ukha_d@xxxxxxx
> Subject: [ukha_d] Charting software for web use?
>
> I'm just about to link up my aquarium computer to my HA server. The
plan
> is to log the values of temp, pH etc that are sent every few seconds.
> Not sure yet how I will do this although there is already some
software
> that will write the values to an Excel doc. I'd probably be best
writing
> to a dB?
>
> Anyway, anyone know of a piece of software that will EASILY take these
> values on a pre-determined period and create a graph (user defined)
for
> viewing on an Intranet web page? Ideally, this software would be free!
> :-)
>
> Thanks,
>
> Paul.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>