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,

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
QueryToStructOfArrays http://www.cflib.org/udf.cfm/QueryToStructOfArrays QueryToStructOfStructures http://www.cflib.org/udf.cfm/QueryToStructOfStructures QueryToArrayOfStructures http://www.cflib.org/udf.cfm/QueryToArrayOfStructures QueryToCSV http://www.cflib.org/udf.cfm/QueryToCSV

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

RE: Query to structure

2003-11-19 Thread Mike Townend
You could try something like... CFQUERY NAME=qry... /CFQUERY CFSET strQuery = StructNew() CFLOOP LIST=#qry.ColumnList# INDEX=idxColumn CFSET strQuery[idxColumn] = qry[idxColumn][1] /CFLOOP CFDUMP VAR=#strQuery# HTH -Original Message- From: Ryan Mitchell [mailto:[EMAIL

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

RE: Query to Structure with keys...

2002-12-11 Thread Ian Skinner
First of all, if you want to use the Product ID's you need to return them with the Select Clause. Just using a field in the where clause does not return them. cfquery name=getProductDetails datasource=XXX SELECT Product_ID, PartNumber, ProductTitle FROM

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
]] = duplicate(thisRow); } return(theStructure); } /cfscript -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 3:20 PM To: CF-Talk Subject: RE: Query to Structure with keys... Code examples would be great!!! -Original Message

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