and have already picked up a nugget.
A tasty one at that. Thanx for sharing.
Should I return an array of structures
I would say yes. From what I have been reading, arrays of structures is the
standard way to exchange data between platforms (Think web services). If you
do it that way (arrays of
Q: What's the best way to return two structures from a function?
Should I return an array of structures or can I return the resultInfo in one
of the arguments
from the calling program?
Well, strictly speaking, if you set the value of something within the
calling program that's not returning
This is the syntax for doing it with an array of structures:
cfset var result = ArrayNew(1)
cfquery name=qry datasource=myDatasource result=info
SELECT * FROM Tablename
/cfquery
cfset result[1] = qry
cfset result[2] = info
cfreturn result
What would be the syntax for using a structure of
Don't need to do that...as it's already a structure. Just loop through it, ie:
for (x=1; x LTE queryName.recordcount; x=x+1)
queryName.columnName[x]
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 19, 2006 4:50 PM
To: CF-Talk
Subject:
You can reference a query in cfscript:
cfquery name=qryName
select
col1, col2
from
/cfquery
cfscript
rownum = 0;
while (row lt qryName.RecordCount)
{
rownum = IncrementValue(rownum);
col1= qryName.col1[rownum];
col2 = qryName.col2[rownum];
}
/cfscript
On 10/19/06, Richard White
Hi, i hope this is a very simple question! but i want to be
able to call a query but i want the result of the query to be
stored in a structure format so that i can use in cfscript,
the only examples i can find is if the result is used in a
cfoutput queryqueryName/cfoutput tags.
could
thats brilliant, thanks for all your advice
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
It will fail in 6.1 - it is 7 only AFAIK.
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: 30 November 2005 14:11
To: CF-Talk
Subject: cfquery result=
This is probably a dumb question, but I'll ask just to make sure.
Does someone have a 6.1 box they can test
6.1 says:
Attribute validation error for tag CFQUERY.
The tag does not allow the attribute(s) RESULT
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: 30 November 2005 14:11
To: CF-Talk
Subject: cfquery result=
This is probably a dumb question, but I'll ask just to
Thats what I figured.
Thanks for checking for me though.
On 11/30/05, Kerry [EMAIL PROTECTED] wrote:
6.1 says:
Attribute validation error for tag CFQUERY.
The tag does not allow the attribute(s) RESULT
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: 30
10 matches
Mail list logo