[Core-lan-org-devel] Bugreport

[Dennis F. <de...@co...>]

Hi,

Just came in, a new bugreport about a wack query. I don't understand the
problem. Can anyone confirm this ?

Cheers,
Dennis

----- Original Message -----
From: "Bill Forgette" <for...@en...>
To: <de...@co...>
Sent: Friday, February 07, 2003 4:09 PM


Greetings Dennis!

We have just installed the APM to see if it will meet the needs of our
team's project management.  We really enjoy what we have seen so far.

We think we found a glitch or an end-user error though, and we are not sure
how to solve.

So far, we can add/edit/delete users, projects, and tasks.  However when a
user goes to to the Time Register, the Task drop down is not populated.  It
is staying at the default of "None", as if it is not capable to bring in the
tasks from the user (task_id?). Furthermore, if the user just leaves it as
"None", and changes the values to see if it does store to the database, it
produces the following error:

The following query :

INSERT INTO time_account( tasks_id, users_id, created, spend ,note ) VALUES
( 0, , now() - interval '2 day', 5 ,'test time reg' );

Had the following error:
ERROR: parser: parse error at or near ","


Any assistance would be appreciated!
Cheers,
Bill

---
Bill Forgette