Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
vayumahesh #1
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
-
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... -
#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:... -
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... -
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 = " &... -
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... -
TA-Selene #2
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
-
vayumahesh #3
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
-
Fernis #4
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



Reply With Quote

