Forums :: Dynamic Chart :: DwZone Forum

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Dynamic Chart

DwZone Forum Index -> Dynamic Chart

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 31 to 40 of 74 (Total: 31)

First | Prev | Next | Last

Subject

Author

Date

Re:Chart error

[email protected]

6:18 9 Mar 2007

Re:Chart error

gianluigi

5:38 13 Mar 2007

Re:Chart error

[email protected]

8:18 2 Dec 2008

Re:Chart error

gianluigi

10:19 2 Dec 2008

Re:Chart error

[email protected]

0:05 4 Dec 2008

The SQL statement is

SELECT Consumption_DateTime, Consumption FROM Meter_Consumption WHERE Meter_ID = ?

where ? is a valid Meter_ID number obtained from a HTML form. I can get the recordset to display in a table.

The column schema for the table Meter_Consumption is

Meter_ID (int, not null)
Consumption_DateTime (datetme, not null)
Consumption (decimal(16,5), not null)
Target (decimal(16,5), not null)
Interpolated (bit, not null)
Meter_Consumption_ID (PK, int, not null)

Therefore the column it's having problem with is DECIMAL. Is this not numeric? Can I only use integer values in my graphs?

The operating system is Vista Home Premium and all regional settings are set to UK. That means using decimal point for decimals and comma for thousands. The application MUST be run under UK settings for other reasons like recognising dates.

The actual SQL database is 50MB in size. How / where should I post it?

thanks

Julian