Hey Everybody,
Anyone got any ideas about grabbing a
Query column and turning it into an array?
But heres the catch/es..
1) The column may have empty strings. (There goes valuelist()?)
2) The column I want to convert is determined dynamically..
Hence the evaluate() function..
=========================================================
// create array to hold our alt values. then loop thru the
// query and add each row or the column to it
altArray = arrayNew(1);
for (i=1; i lte thisQuery.recordCount; i=i+1) {
arrayAppend(altArray,evaluate("thisQuery.#columnToUse#[#i#]"));
}
=========================================================
Regards,
Adam Chapman
Virtualtours.com.au
mailto:[EMAIL PROTECTED]
Phone: 1300 366 122
Int: +61 3 9720 5733
Fax: +61 3 9720 6377
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
