Community Member Profile

Recent Blog Comments By nath

• Calling Array Functions on ColdFusion Query Columns

  Posted on Dec 4, 2008 at 1:30 PM

  Yep in CF 7 it fails - i ended up changing my code to do this: the_array=arraynew(1); for(i=1;i lte the_query.recordcount;i=i+1){ the_array[i]=the_query[column_name][i]; } not as neat, and probably slower - but it worked at the time and keeps the boss happy... If... read more »

• Calling Array Functions on ColdFusion Query Columns

  Posted on Jan 23, 2008 at 12:22 PM

  another line sorts it - the_array=duplicate(the_query['column_name']); ArrayPrepend(the_array,the_query['column_name'][1]); i've got it in a CFC function so i can call it when needed - i guess it could be a udf too. Keep up the good work your website has been a great sourc... read more »

• Calling Array Functions on ColdFusion Query Columns

  Posted on Jan 23, 2008 at 10:45 AM

  You can duplicate columns directly into arrays as well using this syntax: contents_array=duplicate(a_query["the_column"]); this will preseve the empty cells of a column that would otherwise be ignored using: contents_array=listtoarray("#valueList(a_query.the_column)#"); BU... read more »