[snip]
That's up to you of course. Personally, I think some things are better
handled by the database and some are better handled by the programming
language. Things like conditional logic tend to be best handled by the
programming language in my view. Your mileage may vary ;-)
[/snip]
AT the risk
e pictures and music programs to create music.
Rhino
- Original Message -
From: "Luke Venediger" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, October 27, 2004 5:47 PM
Subject: Re: Select with an IF statem
]> wrote:
>
> - Original Message -
> From: "Luke Venediger" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, October 27, 2004 4:58 PM
> Subject: Select with an IF statements
>
> > Hi,
> >
> > I'm t
Thanks Paul!
Luke Venediger.
On Wed, 27 Oct 2004 16:17:51 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 22:58 +0200 10/27/04, Luke Venediger wrote:
> >Hi,
> >
> >I'm trying to do the following:
> >
> >SELECT
> > IF((ProductStatus IS NOT NULL), "Available", "Not Available") as
> >ProductSt
- Original Message -
From: "Luke Venediger" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 27, 2004 4:58 PM
Subject: Select with an IF statements
> Hi,
>
> I'm trying to do the following:
>
> SELECT
> IF((ProductSta
At 22:58 +0200 10/27/04, Luke Venediger wrote:
Hi,
I'm trying to do the following:
SELECT
IF((ProductStatus IS NOT NULL), "Available", "Not Available") as
ProductStatus
FROM
tb_Product
WHERE
ProductName = "MyProduct";
It works fine if the ProductName "MyProduct" works, and returns
"Availabl
Hi,
I'm trying to do the following:
SELECT
IF((ProductStatus IS NOT NULL), "Available", "Not Available") as ProductStatus
FROM
tb_Product
WHERE
ProductName = "MyProduct";
It works fine if the ProductName "MyProduct" works, and returns
"Available". However, if the product name doesn't work
