Try using QueryNew() its more easy to use. Its like querying in the database.
>Hi all
>
>I am building a few arrays on one template using the data from one
>query. I made the arrays with no problem, but CF is giving me a "not a
>valid variable name" error. I need to call and add to an array name
>Dynamically.
>
>// Check to see if it is an array
>writeoutput(IsArray(Evaluate("EmployeAry_#EmployeeNumber#"),2));
>
>This works, but I do not know the Employee Number everytime.
> EmployeAry_116["#RowNu_#"][8] = CalendarInfo.EmployeeNumber[CurRow];
>
>This does not work, But I need to call the Dynamic array names
> "EmployeAry_#EmployeeNumber#[#RowNu_#][1]" =
>CalendarInfo.EmployeeNumber[CurRow];
>
>
>Can someone give my the right syntax.
>
>TIA
>Mike Hughes
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208327
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
