Re: query application structure onSessionEnd
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 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? ~| 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.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query application structure onSessionEnd
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, 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? ~| 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.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250725 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query vs. structure
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 insight on the whole returning of variables from a web service would be appreciated as well. I have a custom tag that turns a query into xml http://www.rohanclan.com/index.cfm?mode=productproduct=cfxtoxml It's not free, but there is more then likely something similar out there if you need a free solution. -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query vs. structure
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 QueryToVars http://www.cflib.org/udf.cfm/QueryToVars QueryToXML http://www.cflib.org/udf.cfm/QueryToXML Although I encourage you to try the Query method. I know some bugs got worked out in the 6.1 release. -nathan strutz -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 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 transfer it?Any insight on the whole returning of variables from a web service would be appreciated as well. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query vs. structure
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 the doc. -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Query vs. structure
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/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 QueryToVars http://www.cflib.org/udf.cfm/QueryToVars QueryToXML http://www.cflib.org/udf.cfm/QueryToXML Although I encourage you to try the Query method. I know some bugs got worked out in the 6.1 release. -nathan strutz -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 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 transfer it?Any insight on the whole returning of variables from a web service would be appreciated as well. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query to structure
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 PROTECTED] 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 you do this? Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query to structure
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] /cfloop Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Query to structure
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 list=#myquery.columnList# index=col cfset mystruct[col] = myquery[col] /cfloop Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Query to structure
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: 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] /cfloop Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query to Structure with keys...
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 Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)
/cfquery
Then what I've done in the past is just loop over the query and create a
structure. I'd love to know if there are any more direct ways to do this.
cfscript
productStruct = newStruct();
for (i=1;i=getProductDetails.recordcount;i=i+1)
{
tempArray = newArray(1);
tempArray[1] = getProductDetails.PartNumber;
tempArray[2] = getProductDetails.ProductTitle;
productStruc[getProductDetails.Product_ID][i] = tempArray;
}
/cfscript
Then you should be able to play with your new structure something like this.
cfoutput
tdPartNumber/tdtdProductTitle/td
td#productStruct['9911'][1]#/tdtd#productStruct['9911'][2]#/td
/cfoutput
Please pardon in problem with my cfscript code. I just wrote that off the
top of my head, and I don't use cfscript all that often.
I hope this helps.
Ian Skinner
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:13 AM
To: CF-Talk
Subject: Query to Structure with keys...
Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart.
I have this query...
cfquery name=getProductDetails datasource=XXX
SELECT PartNumber, ProductTitle
FROM Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)
/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
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Query to Structure with keys...
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 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 Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)
/cfquery
Then what I've done in the past is just loop over the query and create a
structure. I'd love to know if there are any more direct ways to do this.
cfscript
productStruct = newStruct();
for (i=1;i=getProductDetails.recordcount;i=i+1)
{
tempArray = newArray(1);
tempArray[1] = getProductDetails.PartNumber;
tempArray[2] = getProductDetails.ProductTitle;
productStruc[getProductDetails.Product_ID][i] = tempArray;
}
/cfscript
Then you should be able to play with your new structure something like this.
cfoutput
tdPartNumber/tdtdProductTitle/td
td#productStruct['9911'][1]#/tdtd#productStruct['9911'][2]#/td
/cfoutput
Please pardon in problem with my cfscript code. I just wrote that off the
top of my head, and I don't use cfscript all that often.
I hope this helps.
Ian Skinner
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:13 AM
To: CF-Talk
Subject: Query to Structure with keys...
Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart.
I have this query...
cfquery name=getProductDetails datasource=XXX
SELECT PartNumber, ProductTitle
FROM Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)
/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
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
RE: Query to Structure with keys...
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
-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 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 Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)
/cfquery
Then what I've done in the past is just loop over the query and create a
structure. I'd love to know if there are any more direct ways to do this.
cfscript
productStruct = newStruct();
for (i=1;i=getProductDetails.recordcount;i=i+1)
{
tempArray = newArray(1);
tempArray[1] = getProductDetails.PartNumber;
tempArray[2] = getProductDetails.ProductTitle;
productStruc[getProductDetails.Product_ID][i] = tempArray;
}
/cfscript
Then you should be able to play with your new structure something like this.
cfoutput
tdPartNumber/tdtdProductTitle/td
td#productStruct['9911'][1]#/tdtd#productStruct['9911'][2]#/td
/cfoutput
Please pardon in problem with my cfscript code. I just wrote that off the
top of my head, and I don't use cfscript all that often.
I hope this helps.
Ian Skinner
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:13 AM
To: CF-Talk
Subject: Query to Structure with keys...
Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart.
I have this query...
cfquery name=getProductDetails datasource=XXX
SELECT PartNumber, ProductTitle
FROM Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)
/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
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Query to Structure with keys...
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 into a structure of structures accessible by its
primary key.
*
* @param theQuery The query you want to convert to a structure of
structures.
* @param primaryKey Query column to use as the primary key.
* @return Returns a structure.
* @author Shawn Seley ([EMAIL PROTECTED])
* @version 1, March 27, 2002
*/
function QueryToStructOfStructures(theQuery, primaryKey){
var theStructure = structnew();
// remove primary key from cols listing
var cols = ListToArray(ListDeleteAt(theQuery.columnlist,
ListFindNoCase(theQuery.columnlist, primaryKey)));
var row = 1;
var thisRow = ;
var col = 1;
for(row = 1; row LTE theQuery.recordcount; row = row + 1){
thisRow = structnew();
for(col = 1; col LTE arraylen(cols); col = col + 1){
thisRow[cols[col]] = theQuery[cols[col]][row];
}
theStructure[theQuery[primaryKey][row]] = 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-
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
-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 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 Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)
/cfquery
Then what I've done in the past is just loop over the query and create a
structure. I'd love to know if there are any more direct ways to do this.
cfscript
productStruct = newStruct();
for (i=1;i=getProductDetails.recordcount;i=i+1)
{
tempArray = newArray(1);
tempArray[1] = getProductDetails.PartNumber;
tempArray[2] = getProductDetails.ProductTitle;
productStruc[getProductDetails.Product_ID][i] = tempArray;
}
/cfscript
Then you should be able to play with your new structure something like this.
cfoutput
tdPartNumber/tdtdProductTitle/td
td#productStruct['9911'][1]#/tdtd#productStruct['9911'][2]#/td
/cfoutput
Please pardon in problem with my cfscript code. I just wrote that off the
top of my head, and I don't use cfscript all that often.
I hope this helps.
Ian Skinner
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:13 AM
To: CF-Talk
Subject: Query to Structure with keys...
Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart.
I have this query...
cfquery name=getProductDetails datasource=XXX
SELECT PartNumber, ProductTitle
FROM Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)
/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
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Query to Structure with keys...
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 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 into a structure of structures accessible by its
primary key.
*
* @param theQuery The query you want to convert to a structure of
structures.
* @param primaryKey Query column to use as the primary key.
* @return Returns a structure.
* @author Shawn Seley ([EMAIL PROTECTED])
* @version 1, March 27, 2002
*/
function QueryToStructOfStructures(theQuery, primaryKey){
var theStructure = structnew();
// remove primary key from cols listing
var cols = ListToArray(ListDeleteAt(theQuery.columnlist,
ListFindNoCase(theQuery.columnlist, primaryKey)));
var row = 1;
var thisRow = ;
var col = 1;
for(row = 1; row LTE theQuery.recordcount; row = row + 1){
thisRow = structnew();
for(col = 1; col LTE arraylen(cols); col = col + 1){
thisRow[cols[col]] = theQuery[cols[col]][row];
}
theStructure[theQuery[primaryKey][row]] = 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-
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
-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 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 Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)
/cfquery
Then what I've done in the past is just loop over the query and create a
structure. I'd love to know if there are any more direct ways to do this.
cfscript
productStruct = newStruct();
for (i=1;i=getProductDetails.recordcount;i=i+1)
{
tempArray = newArray(1);
tempArray[1] = getProductDetails.PartNumber;
tempArray[2] = getProductDetails.ProductTitle;
productStruc[getProductDetails.Product_ID][i] = tempArray;
}
/cfscript
Then you should be able to play with your new structure something like this.
cfoutput
tdPartNumber/tdtdProductTitle/td
td#productStruct['9911'][1]#/tdtd#productStruct['9911'][2]#/td
/cfoutput
Please pardon in problem with my cfscript code. I just wrote that off the
top of my head, and I don't use cfscript all that often.
I hope this helps.
Ian Skinner
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:13 AM
To: CF-Talk
Subject: Query to Structure with keys...
Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart.
I have this query...
cfquery name=getProductDetails datasource=XXX
SELECT PartNumber, ProductTitle
FROM Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)
/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
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
