Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Table Not Indexable By...

Status
Not open for further replies.

sonnysavage

Programmer
May 29, 2002
130
US
This one is driving me nuts. I am accessing a query result like a struct, and getting this error:
Code:
[Table (rows 8 columns ROW_INDEX, ORD, GROUP_TYPE, ITEM, CARD_TYPE, CARD_SUBTYPE, AVERAGE, CARD_MONTH_CNT, CARD_MONTH_AMT, YTD_CNT, YTD_AMT):
	[ROW_INDEX: coldfusion.sql.QueryColumn@157ed14]
	[ORD: coldfusion.sql.QueryColumn@18debec]
	[GROUP_TYPE: coldfusion.sql.QueryColumn@7bef72]
	[ITEM: coldfusion.sql.QueryColumn@a54984]
	[CARD_TYPE: coldfusion.sql.QueryColumn@17db3e9]
	[CARD_SUBTYPE: coldfusion.sql.QueryColumn@1aea796]
	[AVERAGE: coldfusion.sql.QueryColumn@17c7b27]
	[CARD_MONTH_CNT: coldfusion.sql.QueryColumn@1794d97]
	[CARD_MONTH_AMT: coldfusion.sql.QueryColumn@d507b9]
	[YTD_CNT: coldfusion.sql.QueryColumn@1ee22e9]
	[YTD_AMT: coldfusion.sql.QueryColumn@135f937]
] is not indexable by YTD_Amt

'YTD_Amt' is clearly one of the columns, so why am I getting this error? Has anyone else gotten this error and figured it out?

This is the call that is erroring:
Code:
Report[ColAry[idx]][Report.CurrentRow]

Thanks!
 
Well, it seems the the List I was using to access the column had a special, non-printing character at the end.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top