Hello Emir,
sorry for the first solution. It worked only in mySQL but not in PostgreSQL.
The better one that works on both is the following query:
$this->sql="SELECT $elems FROM $this->tb_dpoc WHERE role_nr=$role_nr AND
dept_nr=$dept_nr AND year=$year AND month IN
('$month','".(int)$month."',".(int)$month.")" ;
Regards,
elpidio
On Tuesday 25 May 2004 17:41, Elpidio Latorilla wrote:
> $this->sql="SELECT $elems FROM $this->tb_dpoc WHERE role_nr=$role_nr AND
> dept_nr=$dept_nr AND year=$year AND month=$month" ;
>
> Note the difference, in the corrrected query the single qoutes previously
> enclosing the $role_nr, $dept_nr, $year and $month are now removed.
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id149&alloc_id�66&op=click
_______________________________________________
Care2002-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/care2002-developers
