[GENERAL] DBI and placeholders question

2005-02-14 Thread mike
Is it possible to have a placeholder on the left side of a select criteria? eg: SELECT CASE WHEN date_part('dow',?::date)=5 this bit is fine THEN CASE WHEN ? = 2 OR ? =3 OR ?=6 OR ?=7 OR ?=8 OR ?=12 THEN '7:00' here the ? is being read as NULL ie, output from LOG SELECT CASE WHEN

Re: [GENERAL] DBI and placeholders question

2005-02-14 Thread Ragnar HafstaĆ°
On Mon, 2005-02-14 at 18:41 +, mike wrote: Is it possible to have a placeholder on the left side of a select criteria? yes eg: SELECT CASE WHEN date_part('dow',?::date)=5 this bit is fine THEN CASE WHEN ? = 2 OR ? =3 OR ?=6 OR ?=7 OR ?=8 OR ?=12 THEN '7:00' here the ? is