Check for End of Recordset ?????

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Check for End of Recordset ?????

    Remember RS.EOF in ASP? How do you test for the end of a recordset to return
    true in CFML?
    For example this never returns false and the else statement never executes:
    cfoutput query="RS"
    cfif isDefined("RS.RecordID")
    ...gimme all you got...
    cfelse
    ...tell me you ain't got none...
    /ctif
    /cfoutput

    tybowman Guest

  2. Similar Questions and Discussions

    1. Spell Check and Grammer Check
      Hello, Does anybody know about some good spell checker/grammer checker for html/asp pages? Thank you, Regards, Raj.
    2. Turning off Check in / Check out feature
      How can I turn off the check in / check out feature? Can't seem to find it in the Contribute HELP. Thanks!
    3. check if a recordset exists
      in asp is there a way to determine wether a recordset exists or not . the problem is i have On Error Resume Next on my page and if duff data is...
    4. Check to see if Check Boxes are Checked
      How do I check to see if a checked box is check on the following page? This is what I have. What am I doing wrong? <%If...
    5. RecordSet.Move or RecordSet.AbsolutePosition??
      Hi, I'm trying to use either one of these methods to position the cursor in a specific position inside a recordset, but neither one seems to...
  3. #2

    Default Re: Check for End of Recordset ?????

    You don't need to check

    cfoutput query="RS"
    ...gimme all you got...
    /cfoutput
    cfif RS.RecordCount Is 0
    ...tell me you ain't got none...
    /cfif

    if there are records the cfoutput will be executed and the following cfif will
    not and visa versa.

    Ken

    The ScareCrow Guest

  4. #3

    Default Re: Check for End of Recordset ?????

    Hmmm thats good if it dosent retuns any values, but if the query does... you can use this.. (this is what I use)

    <cfif query-CurrentRow IS query.RecordCount>
    raulriera 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