This is the syntax for doing it with an array of structures:
SELECT * FROM Tablename
What would be the syntax for using a structure of structures?
> > 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
> resultI
> 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 return
>>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
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.
http://www.fus
> 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
>
> could someone possibly provide a simple
You can reference a query in cfscript:
select
col1, col2
from
rownum = 0;
while (row lt qryName.RecordCount)
{
rownum = IncrementValue(rownum);
col1= qryName.col1[rownum];
col2 = qryName.col2[rownum];
}
On 10/19/06, Richard White <[EMAIL PROTECTED]> wrote:
>
> Hi, i hope this i
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: cf
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
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 ma
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 som
10 matches
Mail list logo
