>- see footer for list info -<
> <cfscript>
> Spacer = chr(127);
>
> aColumn = createObject("java",
> "java.lang.String").init(trim(Audit.ColumnDetail)).split(Spacer);
> aEdit = createObject("java",
> "java.lang.String").init(trim(Audit.EditDetail)).split(Spacer);
>
> qCombined = queryNew("");
> queryAddColumn(qCombined, "column", aColumn);
> queryAddColumn(qCombined, "edit", aEdit);
> </cfscript>
> <cfdump var="#qCombined#">
No need to recreate the wheel/string.
This works fine:
aColumn = Audit.ColumnDetail.split(Spacer);
aEdit = Audit.EditDetail.split(Spacer);
That aside, as a reference for anyone wondering about this method vs
Adrians suggestion, there are two main differences:
The Java split function includes blank elements, whilst CF's standard
list handling excludes blank elements.
For aligning two lists, blank elements are likely to be important.
The split function produces an array, which - when you get into long
lists - could be a performance improvement. It depends how long this
list will actually be and if it is a one-off or frequent thing for if
this is significant.
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
