sconeek@xxxxxxxxx wrote:
hi all,
i am trying to fix this bug within my program. its a java, postgres and
jasper based program which generates charts. now i am generating a
chart which does not show any 0 data points if they exist, only
non-zero ones. obviously i am trying to do everything in just one sql
query, but i am not sure if its possible or not. i also need to
generate a temporary table and then delete it.
I have broken the tasks into,
1. create a temp table
2. create records for 0 data points
3. update with non 0 records
4. delete temp table.
now this is what i have and i would appreciate all help with fixing
this,
Two points:
1. If you quote your column-names when you create them, quote when you
access them too.
2. You don't actually say what the problem is.
--
Richard Huxton
Archonet Ltd
