query application structure onSessionEnd

2006-08-23 Thread Brian Burkett
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?

Re: query application structure onSessionEnd

2006-08-23 Thread Raymond Camden
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

Re: query application structure onSessionEnd

2006-08-23 Thread Brian Burkett
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,

Copy record from query into structure

2005-08-16 Thread Robert Everland III
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

RE: Copy record from query into structure

2005-08-16 Thread Robertson-Ravo, Neil (RX)
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

RE: Copy record from query into structure

2005-08-16 Thread Kerry
: 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

Re: Copy record from query into structure

2005-08-16 Thread Joe Rinehart
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

Re: Copy record from query into structure

2005-08-16 Thread Marlon Moyer
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

Nest query inside structure in CFMX web service?

2005-05-25 Thread Ben Mueller
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

Nest query inside structure in CFMX web service?

2005-05-24 Thread Ben Mueller
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

Query vs. structure

2004-03-10 Thread Burns, John
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

Re: Query vs. structure

2004-03-10 Thread Rob
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

RE: Query vs. structure

2004-03-10 Thread Nathan Strutz
: 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

RE: Query vs. structure

2004-03-10 Thread Rob
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

Re: Query vs. structure

2004-03-10 Thread Adrocknaphobia
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

Query to structure

2003-11-19 Thread Ryan Mitchell
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

RE: Query to structure

2003-11-19 Thread Mike Townend
] 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

RE: Query to structure

2003-11-19 Thread Tim Blair
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]

Re: Query to structure

2003-11-19 Thread Ryan Mitchell
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

Re: Query to structure

2003-11-19 Thread Deanna Schneider
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

Query to Structure with keys...

2002-12-11 Thread Che Vilnonis
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

RE: Query to Structure with keys...

2002-12-11 Thread Ian Skinner
) /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

RE: Query to Structure with keys...

2002-12-11 Thread Matthew Friedman
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

RE: Query to Structure with keys...

2002-12-11 Thread Che Vilnonis
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

RE: Query to Structure with keys...

2002-12-11 Thread Matthew Friedman
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

RE: Query to Structure with keys...

2002-12-11 Thread Che Vilnonis
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

How to convert 1-record query to structure (EBW)

2002-11-24 Thread Erik Britt-Webb
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

Re: How to convert 1-record query to structure (EBW)

2002-11-24 Thread Jeffry Houser
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

RE: How to convert 1-record query to structure (EBW)

2002-11-24 Thread Erik Britt-Webb
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

RE: How to convert 1-record query to structure (EBW)

2002-11-24 Thread Jeffry Houser
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