I want to get rid of my evaluate too
Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I want to get rid of my evaluate too
why do you need evaluate in the first place? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:44 PM To: CF-Talk Subject: I want to get rid of my evaluate too Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I want to get rid of my evaluate too
Because if it is removed I get the column NAMES not the VALUES contained in the columns. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:57 PM To: CF-Talk Subject: RE: I want to get rid of my evaluate too why do you need evaluate in the first place? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:44 PM To: CF-Talk Subject: I want to get rid of my evaluate too Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I want to get rid of my evaluate too
It's a bit ugly but this should work: TD#Dynamic[LIndex][currentrow]#/TD Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 7:43 AM Subject: I want to get rid of my evaluate too Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I want to get rid of my evaluate too
Without it, you'd just get the name of each column. - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 7:56 AM Subject: RE: I want to get rid of my evaluate too why do you need evaluate in the first place? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:44 PM To: CF-Talk Subject: I want to get rid of my evaluate too Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I want to get rid of my evaluate too
Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#Dynamic[LIndex][Dynamic.CurrentRow]#/TD /CFLOOP /TR /CFLOOP /TABLE --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 11:44 AM To: CF-Talk Subject: I want to get rid of my evaluate too Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I want to get rid of my evaluate too
and this doesn't work, I assume...? Table cfoutput CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#Dynamic.LIndex#/TD /CFLOOP /TR /CFLOOP /cfoutput /TABLE ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:50 PM To: CF-Talk Subject: RE: I want to get rid of my evaluate too Because if it is removed I get the column NAMES not the VALUES contained in the columns. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:57 PM To: CF-Talk Subject: RE: I want to get rid of my evaluate too why do you need evaluate in the first place? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:44 PM To: CF-Talk Subject: I want to get rid of my evaluate too Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I want to get rid of my evaluate too
Then use #queryname[colname][rownum]# instead. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 1:50 PM To: CF-Talk Subject: RE: I want to get rid of my evaluate too Because if it is removed I get the column NAMES not the VALUES contained in the columns. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:57 PM To: CF-Talk Subject: RE: I want to get rid of my evaluate too why do you need evaluate in the first place? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:44 PM To: CF-Talk Subject: I want to get rid of my evaluate too Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I want to get rid of my evaluate too
try... TD#session.DisplayCols[#LIndex#]#/TD ...mind your locks! Doug -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:44 PM To: CF-Talk Subject: I want to get rid of my evaluate too Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I want to get rid of my evaluate too
ooops! DOH! you are trying to output your query! something like this then TD#Dynamic[LIndex][currentrow]#/TD *crawls back in his coffee cup* Doug -Original Message- From: Knudsen, Douglas Sent: Wednesday, March 26, 2003 3:06 PM To: '[EMAIL PROTECTED]' Subject: RE: I want to get rid of my evaluate too try... TD#session.DisplayCols[#LIndex#]#/TD ...mind your locks! Doug -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:44 PM To: CF-Talk Subject: I want to get rid of my evaluate too Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I want to get rid of my evaluate too
Just to be anal - you don't need the # #session.displayCols[lIndex]# :) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:06 PM To: CF-Talk Subject: RE: I want to get rid of my evaluate too try... TD#session.DisplayCols[#LIndex#]#/TD ...mind your locks! Doug -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:44 PM To: CF-Talk Subject: I want to get rid of my evaluate too Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I want to get rid of my evaluate too - RESOLVED
This suggestion worked. Thanks. -Original Message- From: James Ang [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 3:04 PM To: CF-Talk Subject: RE: I want to get rid of my evaluate too Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#Dynamic[LIndex][Dynamic.CurrentRow]#/TD /CFLOOP /TR /CFLOOP /TABLE --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 11:44 AM To: CF-Talk Subject: I want to get rid of my evaluate too Hello All, I have a list of column names that I use in a cfloop of a query. I can't quite figure out how to eliminate the need to use evaluate. Any help would be much appreciated. TIA DavidB This is the code I'm trying to fix. Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#evaluate(LIndex)#/TD /CFLOOP /TR /CFLOOP /TABLE David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I want to get rid of my evaluate too
-blush- And of course, it won't work w/o a row #... #session.displayCols[lIndex][x]# === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:20 PM To: CF-Talk Subject: RE: I want to get rid of my evaluate too Just to be anal - you don't need the # #session.displayCols[lIndex]# :) ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
