Professional Web Applications Themes

cfloop from query - Macromedia ColdFusion

Hi there! I need a little help here. I have to change 'TraveAgencyNumber' to 'TravelAgencyName' Through this query output (GetLog) I only get the TravelAgencyNumber but I have in another table both the names and the numbers. This is what I tried first: <cfoutput query='GetLog' group='LFTIME'> #Time# - #BookingNumber# - #Amount# - <cfloop query = 'TravelAgency' startrow='1'> <cfif TravelAgency.Number IS GetLog.TravelAgencyNumber> #TravelAgency.Name# </cfif> </cfloop> This is not working. I have tried to find a solution in this forum but no luck yet. Any suggestion?...

  1. #1

    Default cfloop from query

    Hi there! I need a little help here. I have to change 'TraveAgencyNumber' to
    'TravelAgencyName' Through this query output (GetLog) I only get the
    TravelAgencyNumber but I have in another table both the names and the numbers.
    This is what I tried first: <cfoutput query='GetLog' group='LFTIME'> #Time#
    - #BookingNumber# - #Amount# - <cfloop query = 'TravelAgency' startrow='1'>
    <cfif TravelAgency.Number IS GetLog.TravelAgencyNumber> #TravelAgency.Name#
    </cfif> </cfloop> This is not working. I have tried to find a solution in this
    forum but no luck yet. Any suggestion?

    EINN Guest

  2. #2

    Default Re: cfloop from query

    By using it like that it works: <cfset Slim = #GetLog.TravelAgencyNumber#>
    <cfoutput query='GetLog' group='LFTIME'> #Time# - #BookingNumber# - #Amount#
    - <cfloop query = 'TravelAgency' startrow='1'> <cfif TravelAgency.Number IS
    Slim> #TravelAgency.Name# </cfif> </cfloop>

    EINN Guest

Similar Threads

  1. Question Need help with MOD and cfloop
    By TheBorg in forum ColdFusion
    Replies: 0
    Last Post: May 30th, 07:18 AM
  2. cfloop
    By drmaves in forum Coldfusion - Getting Started
    Replies: 10
    Last Post: September 13th, 04:36 PM
  3. Cfloop..
    By Seth Buntin in forum Coldfusion - Advanced Techniques
    Replies: 4
    Last Post: June 29th, 05:17 PM
  4. to cfloop or not to cfloop?
    By chriskeeler2 in forum Macromedia ColdFusion
    Replies: 3
    Last Post: June 20th, 07:15 PM
  5. count cfloop query
    By CFMadness in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: April 4th, 06:43 PM

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