return query resultset from custom tag

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

  1. #1

    Default return query resultset from custom tag

    Hi,

    How to return an entire query resultset from custom tag to the calling page ?

    Thanks for your help.
    vmrao
    vayumahesh Guest

  2. Similar Questions and Discussions

    1. Access a specific resultset (Query) row
      I am iterating over a CF Query and want to implement a generic function which takes the query and the rownumber as a parameter. How can I access a...
    2. #6503 [Opn->Asn]: no support for multiple resultset query?
      ID: 6503 Updated by: bjori@php.net Reported By: alonso at computacionlegal dot com -Status: Open +Status: Assigned Bug Type:...
    3. output parameters not working in if return resultset
      I am calling a stored procedure in SQL Server to return resultset to fill a datagrid in ASP.NET (using C#). I also want to return error code in...
    4. Getting recordcount from resultset of 'union' query
      Hi, I need to find out the number of records in the resultset of a union of 2 queries. E.g. "select ID from Pages where numPageCatID = " &...
    5. How to return a resultset/table from a sql function?
      Hi, Is it possible to return the following (parameterized) qyery from a sql or plpsql function, and if so, what is the syntax? SELECT{ (SELECT...
  3. #2

    Default Re: return query resultset from custom tag

    ColdFusion treats a result set like any complex variable.

    You can name the query result Request.MyQueryName and then it will be
    available on the caller page as Request.MyQueryName, or you can call it
    Caller.MyQueryName and it will be available on the caller page as MyQueryName.

    TA-Selene Guest

  4. #3

    Default Re: return query resultset from custom tag

    I tried naming the query with Prefixes "Caller." , "Request.".

    <CFLDAP NAME="Caller.qryLdapData"
    .... >

    <CFLDAP NAME="Request..qryLdapData"
    .... >

    I am getting exception with both.

    Am I doing something wrong here ?

    Thanks,
    vmrao

    vayumahesh Guest

  5. #4

    Default Re: return query resultset from custom tag

    I don't have much knowledge on this, since I don't know if CFLDAP behaves
    differently from CFQUERY, but what about trying not to rename the query, and
    just copying the resultset to a caller variable?

    <cfldap name="qryLdapData" .....>
    <cfset caller.qryLdapData = qryLdapData>



    Fernis 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