In case you want the cflib reference: http://www.cflib.org/udf.cfm?ID=10
Enjoy Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] Quoting Barry Beattie <[EMAIL PROTECTED]>: > 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 > > > --- 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
