Ah Ha! thank you James (and Mark S)
Taco: >>You can already refer to a query as an array, i.e. queryName.columnName[1] and as a structure. true, but it's not quite the same thing (datatype, etc). It's been recommended to me to use an arrOfStructs instead of a query for remoting - for performance reasons, etc. cheers barry.b -----Original Message----- From: James Silva [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 2:09 PM To: CFAussie Mailing List Subject: [cfaussie] RE: query to arrayOfStructs function? Enjoy. http://cflib.org/library.cfm?ID=5 ____________________________ James Silva Web Production Gruden Pty Ltd Tel: +61 02 9956 6388 Fax: +61 02 9956 8433 Email: [EMAIL PROTECTED] Web: http://www.gruden.com ____________________________ Having being so impressed with CF's built in listToArray(), arrayToList(), valueList() functions, I was hoping there was a "qryToArrOfStructs()" and "qryToArray()" to convert a query to other formats. I was so spoilt with ASP/ADO's "recordSet.GetRows()" (query to 2D array) and ".GetString()" (query to CSV string) that I was hoping there was something similar. anyone know of any? my Googling hasn't found a custom tag to do it either. thanx barry.b --- 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
