Axelology
Posted At : November 4, 2006 7:14 PM
| Posted By : Axel Jensen
Submit a cfgrid to the session!
The challenge with using cfgrid, is that it doesnt exist in the form in nothing was changed.... here is a script that runs through the grid, and gets the values and puts them in the form scope...
You can use this to submit to the session, or another scope of some sort. The code is based on another great site! asfusion, fantastic examples, and they are how i got knowledgable of the subject.
asfusion Looping over records of a large gridI slightly modified thier code
<cfif isDefined('form')>
<cfdump var="#form#">
</cfif>
<!--- replace this cfscript by your query: <cfquery name="products"> --->
<cfscript>
//generate a large query
products = queryNew("");
names = "";
prices = "";
for (i = 1; i LTE 25; i = i + 1){
names = listappend(names,"Product " & i,",");
prices = listappend(prices,100 + i,",");
}
queryaddcolumn(products,"name",listtoarray(names));
queryaddcolumn(products,"price",listtoarray(prices));
</cfscript>
<cfsavecontent variable="changePrice">
var i = 0;
updateBtn.enabled = false;
//make the loop with onEnterFrame instead of a "for"
_root.onEnterFrame = function ()
{
if(i < productsGrid.length) {
//do one iteration of the loop
_root.updatePrice(i);
i++;
}
else {
//end the loop
_root.onEnterFrame = undefined;
updateBtn.enabled = true;
}
}
//the function that does whatever we need in each iteration
_root.updatePrice = function (index){
productsGrid.editField(index, 'price', Number(productsGrid.getItemAt(index)['price']));
productsGrid.setPropertiesAt(index, {backgroundColor:0xF7FFB7});
}
</cfsavecontent>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Looping over a large cfgrid</title>
</head>
<body >
<cfform name="myForm" format="flash" width="350" height="250">
<cfformitem type="text">Click Update then submit the form.</cfformitem>
<cfformgroup type="vBox">
<cfgrid name= "productsGrid" query="products" height="150" rowheaders="false">
<cfgridcolumn name="name" header="Product">
<cfgridcolumn name="price" header="Price" type="numeric">
</cfgrid>
<cfformgroup type="horizontal" style="horizontalAlign:right;">
<cfinput type="button" name="updateBtn" value="Update" onclick="#changePrice#">
<cfinput type="submit" name="submit" value="submit">
</cfformgroup>
</cfformgroup>
</cfform>
</body>
</html>
<cfdump var="#form#">
</cfif>
<!--- replace this cfscript by your query: <cfquery name="products"> --->
<cfscript>
//generate a large query
products = queryNew("");
names = "";
prices = "";
for (i = 1; i LTE 25; i = i + 1){
names = listappend(names,"Product " & i,",");
prices = listappend(prices,100 + i,",");
}
queryaddcolumn(products,"name",listtoarray(names));
queryaddcolumn(products,"price",listtoarray(prices));
</cfscript>
<cfsavecontent variable="changePrice">
var i = 0;
updateBtn.enabled = false;
//make the loop with onEnterFrame instead of a "for"
_root.onEnterFrame = function ()
{
if(i < productsGrid.length) {
//do one iteration of the loop
_root.updatePrice(i);
i++;
}
else {
//end the loop
_root.onEnterFrame = undefined;
updateBtn.enabled = true;
}
}
//the function that does whatever we need in each iteration
_root.updatePrice = function (index){
productsGrid.editField(index, 'price', Number(productsGrid.getItemAt(index)['price']));
productsGrid.setPropertiesAt(index, {backgroundColor:0xF7FFB7});
}
</cfsavecontent>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Looping over a large cfgrid</title>
</head>
<body >
<cfform name="myForm" format="flash" width="350" height="250">
<cfformitem type="text">Click Update then submit the form.</cfformitem>
<cfformgroup type="vBox">
<cfgrid name= "productsGrid" query="products" height="150" rowheaders="false">
<cfgridcolumn name="name" header="Product">
<cfgridcolumn name="price" header="Price" type="numeric">
</cfgrid>
<cfformgroup type="horizontal" style="horizontalAlign:right;">
<cfinput type="button" name="updateBtn" value="Update" onclick="#changePrice#">
<cfinput type="submit" name="submit" value="submit">
</cfformgroup>
</cfformgroup>
</cfform>
</body>
</html>
Keep in mind it's a work around so the code probably won't work with the next version
THIS WILL SUCK IF YOU ARE ENTERING OR UPDATING MORE THAN A FEW HUNDRED RECORDS or updating a lot of columns...
Blog provided and hosted by CF Webtools. Blog Sofware by Ray Camden.
http://www.onlineflashgames.org
http://benvarim.blogspot.com
http://www.mmo-games.in
http://www.yourhumorpoint.com
I thank you for continuing excellence
Thank you
=========================================================================
<a href="http://www.libyanyouths.com">?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/">???? ????? </a>
<a href="http://www.libyanyouths.com">libya</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/">???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f13.html">????? ??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f183.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f183.html">?????? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f7.html">????? ??????? ??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f117.html">?????? ????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f111.html">???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f116.html">?????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f7.html">??? ??????? </a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html">?????? ??????? </a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f198.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f198.html">????? ??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f61.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f61.html">????? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f208.html">?? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f62.html">??? ?? ????? ?????? </a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f64.html">????? ????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f206.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f206.html">????? ????? ??????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f207.html">????? ????? ????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f65.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f65.html"> ???? ??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f195.html">??????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f150.html">????? ? ????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f154.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f154.html">????? ????? </a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f153.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f153.html">?????? ?????? </a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f134.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f134.html">????? ??? ???</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f72.html">???????? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f134.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f134.html">????? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f50.html">?????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f22.html">???? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f191.html">?????? ??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html">??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f72.html">???????? </a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f69.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f69.html">???? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f67.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f67.html">??? ??? ??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f138.html">?????? ????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f139.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f139.html">?????? ????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f140.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f140.html">?????? ?????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f148.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f148.html">??? ????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f154.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f154.html">????? ???????? </a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f105.html">????? ???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f102.html">???? ???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f102.html">?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f24.html">???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f102.html">????? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html">?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f22.html">??? ????? ??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f105.html">????? ????? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html">????? ???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html">????? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html">????? ??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f22.html">????? ???</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html">????? ???? ???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f47.html">?????? </a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html">?????? ???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f22.html">????? ????? ???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f148.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f148.html">????? ????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f102.html">???? ??????? ???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f98.html">????? ????? ???</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f94.html">????? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f117.html">???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f22.html">????? ????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html">????? ??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html">?????</a>
<a href="http://www.libyanyouths.com/jeux" target="_blank">http://www.libyanyouths.com/jeux">games</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html">????? </a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html">??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f22.html">????? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f28.html">????? ???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html">?????? ????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f29.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f29.html"> ????????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f33.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f33.html">?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f33.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f33.html">????? ???????</a>
<a href="http://www.libyanyouths.com/jeux" target="_blank">http://www.libyanyouths.com/jeux">games</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f117.html">?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f19.html">????? ?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html">?????? ????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html">??? ???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f50.html">?????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html">?????? ????? </a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f29.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f29.html">????????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f50.html">?????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f82.html">????? ????????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f48.html">??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f57.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f57.html">??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f58.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f58.html">??????? ???????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f77.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f77.html">????? ??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f87.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f87.html">????? ??????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f82.html">????? ????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f91.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f91.html">?????</a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f110.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f110.html">?????? ??????? </a>
<a href="http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f83.html" target="_blank">http://www.libyanyouths.com/vb/" target="_blank">http://www.libyanyouths.com/vb/f83.html">?????</a>