From: Andrew S. <and...@pa...> - 2003-02-10 02:19:39
|
Hi, Yes ... I think I remember this one. The problem is that the user_id is being set as 'no value'. Happens when you enter time registration screen from the main menu? Anyway, I am fairly sure I fixed it CVS a few months ago (there was a lot of bugs in time registration that I fixed about then). It's a while ago now - and I can't remember all the details... Regards Andrew On Fri, 7 Feb 2003 19:49:26 +0100 "Dennis Fleurbaaij" <de...@co...> wrote: > Hi, > > Just came in, a new bugreport about a wack query. I don't understand > the problem. Can anyone confirm this ? > > Cheers, > Dennis > > 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 "," > > |