Re: [Phpgroupware-developers] Timecard recording

[Tina Messmann]

Hello Bob,

Bob Schader wrote:
...[snip]

> Though I think the PostgreSQL issues might be due to the version as I have
>
> been testing it on Postgres 7.2 under Windows. It could also have 
> something
>
> to do with (since I see it was a German language install) date 
> encoding in use
>
> at the site, but this would all need to be verified. If nothing else, 
> I may have to
>
> seriously look at the possibility of converting the date fields to 
> regular text fields
>
> but I am not sure some of my current date based queries would work 
> with that
>
> field type.
I don't think that you need the date in a regular text field.
The error messages are clear : the format of the date field is not correct
For example in this error message:

- in Area 'View Job Entry' clicking on 'Generate' for the Activity Report:
Database error: Invalid SQL: SELECT  
j.work_date,e.lid,w.catagory_desc,j.num_hours,j.comments FROM  
phpgw_ttrack_job_details as j LEFT JOIN phpgw_ttrack_emplyprof as e on  
j.account_id = e.id left join phpgw_ttrack_wk_cat as w on  
j.work_catagory_id = w.work_catagory_id WHERE j.job_id='5' AND 
j.work_date >= '20-0--2-02' AND j.work_date <= '2002-03-21' ORDER by  
work_date
PostgreSQL Error: 1 (ERROR: Bad date external representation '20-0--2-02' )

there we have j.work_date >= '20-0--2-02'  and PostgreSQL cannot deal 
with wrong date formats in date fields.
I didn't have the time to look where this wrong format is produced. 
Maybe i can look at it the next week.
If i find something out about it, i'll post it here.

Regards
Tina     aka zordaz

>  
>
> Bob Schader