sql select case statement

[Anderson11983]

Hi,

Im trying to put together a sql select case statement for coldfusion - can
anyone please check over my code and see if i am going along the right lines
syntax wise etc.


<cfquery name="getClassifiedResource" datasource="#caller.nimoirdb#">
SELECT dtn.id, dtn.name, dtn.status, dtn.site, 'true' as fsg, dtn.title,
dtn.approvalstate, dtn.found, dtn.lowest_node, 0 as child_of, -23 as replaces,
0 as languageID, dtn.iFilesize
FROM
(SELECT dtn.id, dtn.name, dtn.status, dtn.site, dtn.lowest_node, dtn.title,
dtn.approvalstate, dtn.iFileSize)
(SELECT CASE
WHEN dtx.content = 0 and dtx.approvalstate = 0 AND (appOffContext0 like
'%|' + dtx.status + '|%') THEN 1

</cfquery>

Thanks for yor help

Andy

[paross1]

I don't see any tables referenced in the FROM clause anywhere, nor can I can't
tell what you are trying to do from what you presented. Perhaps if you
explained what you were trying to do, it would help to see if you were even on
the right track, but your SQL makes no sense to me as written. Sorry.

Phil