In the onSessionEnd function in application.cfc, I want to read the
SessionTimeout value from the application structure. I've tried this:
cfargument name=ApplicationScope required=true and then review the cfdump
of that structure, but I don't see sessiontimeout. Any thoughts?
The sessiontimeout value doesn't exist in the application structure.
If you set the value in the This scope, try getting it like that. That
should work.
On 8/23/06, Brian Burkett [EMAIL PROTECTED] wrote:
In the onSessionEnd function in application.cfc, I want to read the
SessionTimeout value
Thanks Ray, that works perfectly.
The sessiontimeout value doesn't exist in the application structure.
If you set the value in the This scope, try getting it like that.
That
should work.
On 8/23/06, Brian Burkett [EMAIL PROTECTED] wrote:
In the onSessionEnd function in application.cfc,
Is there a way to copy an entire record from a query into a structure. I can
reference the query like query[rowname][rownumber] but when you try to
reference it as query[rownumber] it errors out.
Bob
~|
Logware
into structure
Is there a way to copy an entire record from a query into a structure. I can
reference the query like query[rowname][rownumber] but when you try to
reference it as query[rownumber] it errors out.
Bob
~|
Logware
: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 16 August 2005 16:01
To: CF-Talk
Subject: RE: Copy record from query into structure
I think you will have to make it into an Array of Structs rather than a
Struct itself. Where each Array node is an equivalent row number
I wrote a little QueryTool cfc that does stuff like this a while back,
feel free to use/abuse it:
http://clearsoftware.net/client/queryTool.cfm
-Joe
On 8/16/05, Robert Everland III [EMAIL PROTECTED] wrote:
Is there a way to copy an entire record from a query into a structure. I can
reference
Try this function from cflib.org
http://www.cflib.org/udf.cfm?ID=358
On 8/16/05, Robert Everland III [EMAIL PROTECTED] wrote:
Is there a way to copy an entire record from a query into a structure. I can
reference the query like query[rowname][rownumber] but when you try to
reference
I found a solution, though I admit I'm not totally happy with it. I can
serialize a query into WDDX, then add it to my structure that is returned by
the web service. On the other side, I can pick up that WDDX object, and
de-serialize it back into a CF query object. That seems to work, but I
I would like to nest a query object inside of a structure that is returned by a
web service I'm building. The web service is to be consumed by CFMX. I
thought I had it working at one point, but now I get an ugly error that says
the QueryBean cannot be deserialized.
So, now I'm wondering if
In a web service, I've heard that there are issues with returning a CF
query to a language other than CF.Is there any kind of a function to
convert a query directly to a structure without having to loop over it
and manually transfer it?Any insight on the whole returning of
variables from a web
On Wed, 2004-03-10 at 11:51, Burns, John wrote:
In a web service, I've heard that there are issues with returning a CF
query to a language other than CF.Is there any kind of a function to
convert a query directly to a structure without having to loop over it
and manually transfer it?Any
: Wednesday, March 10, 2004 12:52 PM
To: CF-Talk
Subject: Query vs. structure
In a web service, I've heard that there are issues with returning a CF
query to a language other than CF.Is there any kind of a function to
convert a query directly to a structure without having to loop over it
and manually
On Wed, 2004-03-10 at 12:09, Nathan Strutz wrote:
QueryToXML
http://www.cflib.org/udf.cfm/QueryToXML
does this tag supress the ?xml ... ? part when you do
toString(xmlDoc)? That was killing me when trying to pass stuff around,
and build complex xml documents where the query is just one part of
If you are going to the XML route, might as well use WDDX.
-Adam
-Original Message-
From: Nathan Strutz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 08:09 PM
To: 'CF-Talk'
Subject: RE: Query vs. structure
QueryToStructOfArrays
http://www.cflib.org/udf.cfm
Hello
I have a query which returns one row with a lot of columns...
I want to take the query and convert it to a structure, with the key being
the column name and the value being the value of the column...
How do you do this?
Ryan
[Todays Threads]
[This Message]
[Subscription]
[Fast
]
Sent: Wednesday, November 19, 2003 12:42
To: CF-Talk
Subject: Query to structure
Hello
I have a query which returns one row with a lot of columns...
I want to take the query and convert it to a structure, with the key being
the column name and the value being the value of the column...
How do
Ryan,
I want to take the query and convert it to a structure, with
the key being the column name and the value being the value
of the column...
Simply loop over the column list:
cfset mystruct = structnew()
cfloop list=#myquery.columnList# index=col
cfset mystruct[col] = myquery[col]
Thanks :)
On 19/11/03 12:51 pm, Tim Blair [EMAIL PROTECTED] wrote:
Ryan,
I want to take the query and convert it to a structure, with
the key being the column name and the value being the value
of the column...
Simply loop over the column list:
cfset mystruct = structnew()
cfloop
There's also a UDF on cflib.org that does this.
-d
- Original Message -
From: Ryan Mitchell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 7:14 AM
Subject: Re: Query to structure
Thanks :)
On 19/11/03 12:51 pm, Tim Blair [EMAIL PROTECTED] wrote
to place this query into a structure. The keys need to come from the
Product_IDs
in the where clause of the query. Each key has as its value, the column
names that are returned.
Any ideas on how to do this??? cfscript based code samples would be
appreciated.
Ché Vilnonis
Application Developer
)
/cfquery
I would to place this query into a structure. The keys need to come from the
Product_IDs
in the where clause of the query. Each key has as its value, the column
names that are returned.
Any ideas on how to do this??? cfscript based code samples would be
appreciated.
Ché Vilnonis
you could use the valuelist(query.colname) function to do this with out the
loop
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:13 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...
First of all, if you want to use
Code examples would be great!!!
-Original Message-
From: Matthew Friedman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:24 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...
you could use the valuelist(query.colname) function to do this with out the
loop
If you are looking at moving a query to a structure there is a great UDF on
cflib that I use all the time.
Try this below (this is not my code!!!)
and then put the output into a cfdump to see the outcome.
For full documentation look at www.CFlib.org.
cfscript
/**
* Converts a query object
Thanks...you gotta love CFLIB.org!
I can't believe I forgot about that resource.
-Original Message-
From: Matthew Friedman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:37 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...
If you are looking at moving
I'm selecting a single record from SQL Server and want to pass the results
as a structured variable, rather than a query variable. How do I obtain the
list of fields in the query so that I can loop through them?
I know how to loop through a collection of fields in a structured variable
and I
the list of fields, but I'm not sure
why you would want to do this.
First off, you do understand that you can access a query as a structure
of arrays?
If you want to access the 10th record of a query, you can do this:
Queryname.Column[10]
If you leave out the array index, the first row
PROTECTED]]
Sent: Sunday, November 24, 2002 1:41 PM
To: CF-Talk
Subject: Re: How to convert 1-record query to structure (EBW)
At 10:15 AM 11/24/2002 -0500, you wrote:
I'm selecting a single record from SQL Server and want to pass the results
as a structured variable, rather than a query variable
to convert the 1-record query into a structure.
I did not understand that this is what you were trying to do from the
original post. I bet writing a function to return a single row of a query
might be good for these situations, because I can't think of a way off the
top of my head
30 matches
Mail list logo