>- see footer for list info -<
Show-off! :O.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Simon Baynes
Sent: 14 May 2008 14:05
To: Coldfusion Development
Subject: Re: [CF-Dev] Converting ascii(127) seperated data to a list or
array?
>- 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#">
On Wed, May 14, 2008 at 12:06 PM, Nick Middleweek
<[EMAIL PROTECTED]> wrote:
> >- see footer for list info -<
> Hello,
>
> I've got some data in records in two 'parallel' text fields that is an
> ASCII(127) seperated list.
>
> What is the best approach to converting the data into two 'parallel'
lists
> or arrays?
>
> e.g.
>
> Audit.ColumnDetail = "estimatedProductionPrice actualProductionCost "
> Audit.EditDetail = "0.0000 0.0000 "
>
> I want to be able to look up the value for actualProductionCost so it
> returns 0.0000.
>
>
> Thanks,
> Nick
> _______________________________________________
>
> 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 -<
>
--
Simon Baynes
www.simonbaynes.com
LinkedIn profile:- http://www.linkedin.com/in/simonbaynes
_______________________________________________
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 -<
_______________________________________________
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 -<