Professional Web Applications Themes

sql select case statement - Coldfusion Database Access

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...

  1. #1

    Default sql select case statement

    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

    Anderson11983 Guest

  2. #2

    Default Re: sql select case statement

    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

    paross1 Guest

Similar Threads

  1. Select Case SQL recordset help
    By -D- in forum Dreamweaver AppDev
    Replies: 2
    Last Post: February 22nd, 10:22 PM
  2. List in case statement
    By lingo smith in forum Macromedia Director Basics
    Replies: 2
    Last Post: April 17th, 02:05 AM
  3. Case Statement
    By tsetliff webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 9
    Last Post: February 5th, 11:26 PM
  4. Problems with CASE statement
    By Sean C. in forum IBM DB2
    Replies: 9
    Last Post: October 15th, 06:03 AM
  5. CASE statement and CONTAINS
    By steve in forum Macromedia Director Lingo
    Replies: 2
    Last Post: July 31st, 12:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139