Re: select where clause question with replace subquestion

2003-03-25 Thread Wiggins d'Anconia
Jattie van der Linde wrote: I'm trying to build a dynamic piece of code that generates a HTML view like a year planner for all employees in the company all on one page. My appraoch is to use 2 Quesries, the first getting all the active employee names and the second then determines the dates of abse

Re: select where clause question with replace subquestion

2003-03-25 Thread Jason Archer
than it solves. Jason - Original Message - From: "Jattie van der Linde" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 4:19 PM Subject: select where clause question with replace subquestion I'm trying to build a dynamic piece of c

select where clause question with replace subquestion

2003-03-25 Thread Jattie van der Linde
I'm trying to build a dynamic piece of code that generates a HTML view like a year planner for all employees in the company all on one page. My appraoch is to use 2 Quesries, the first getting all the active employee names and the second then determines the dates of absence and plot that on a 36