cfif not giving expected results

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default cfif not giving expected results

    Hi, I am firing Query & comparing Name with string1

    even Name is equal to string1 statements inside cfif is not executed

    Code:


    <CFQUERY name="SearchS" datasource="t1">
    SELECT Name
    FROM MyTable
    WHERE id = 1
    </CFQUERY>

    <cfoutput query=" SearchS ">
    Name # Name #<br>

    <cfif # Name # IS "somestring">
    # Name # inside if
    </cfif>

    Thank you

    sh100 Guest

  2. Similar Questions and Discussions

    1. Query results don't display properly in results table.IGNORE PREVIOUS
      :disgust; I need to display the results of a query. The query runs properly. My problem is having specific results display in specific locations in...
    2. Using <CFIF> on query results
      I'm using Coldfusion with SQL databases to develop a dynamic calendar. The issue I have is how to get it to know if a particular day is a Holiday. ...
    3. loadMovie is not giving me the results I want.
      I have created a movie that contains a dynamic text box with a linked .txt file. there are two buttons for scrolling the text. I published the...
    4. XML::Twig print to file gives expected results except for failure return value
      (I had some conversation in c.l.p.m about this originally but it's no longer a Perl coding problem so I'm moving it here.) Using XML::Twig I'm...
    5. Collision modifier giving incorrect results?
      Does anyone know of any reason the Collision modifier would report a false collision on models, type #box, with scale different than vector(1,1,1)?
  3. #2

    Default Re: cfif not giving expected results

    I got it I Have to trim white spaces in Name string
    sh100 Guest

Posting Permissions

  • You may not post new threads
  • You may 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