duane
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 5:19 PM
To: CF-Talk
Subject: Re: Help with A Query
Jochem van Dieten wrote:
>
> In SQL it would be:
>
> SELECT
> ID,
> CASE
> WHEN ImageURL6 IS NOT NULL
> THEN numPhotos = 6
> WHEN ImageURL5 IS NOT NULL
> THEN numPhotos = 5
> WHEN ImageURL4 IS NOT NULL
> THEN numPhotos = 4
> WHEN ImageURL3 IS NOT NULL
> THEN numPhotos = 3
> WHEN ImageURL2 IS NOT NULL
> THEN numPhotos = 2
> WHEN ImageURL1 IS NOT NULL
> THEN numPhotos = 1
> ELSE
> THEN numPhotos = 0
This last one should be without the THEN.
Jochem
> END AS numPhotos
> FROM
> cdmdatafeed
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
