Why cant you just go altArray = duplicate(query[column])
? easier than looping over each record Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adam Chapman Sent: Friday, February 27, 2004 5:15 PM To: CFAussie Mailing List Subject: [cfaussie] Query Column to Array 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 --- 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
