RE: Looping through a list, setting each listItem to a column

[Craig Dudley]

This works,


it's a bit of a fudge, but it does the job.


<cfset qTmp = QueryNew("DateTime,User,Document,Status")>
<cfloop list="#fOutput#" index="fileLine" delimiters="#Chr(10)#">
<cfif listLen(fileLine) gte 4>
  <cfset tmp = QueryAddRow(qTmp,1)>
  <cfif listLen(fileLine) gt 4>
   <cfscript>
   QuerySetCell(qTmp,"DateTime", listGetAt(fileLine,1));
   QuerySetCell(qTmp,"User", listGetAt(fileLine,2));
   QuerySetCell(qTmp,"Status", listlast(fileLine));
   
   x = listLen(fileLine) - 1;
   doc = "";
   for ( i = 3 ; i lte x ; i = i + 1 ){
    doc = doc & "," & listGetAt(fileLine,i);
   }
   
   QuerySetCell(qTmp,"Document", doc);
   </cfscript>   
  <cfelse>
   <cfscript>
   QuerySetCell(qTmp,"DateTime", listGetAt(fileLine,1));
   QuerySetCell(qTmp,"User", listGetAt(fileLine,2));
   QuerySetCell(qTmp,"Document", listGetAt(fileLine,3));
   QuerySetCell(qTmp,"Status", listGetAt(fileLine,4));
   </cfscript>  
  </cfif>
</cfif>
</cfloop>

-----Original Message-----
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]

Sent: 09 October 2003 10:43
To: CF-Talk
Subject: Re:Looping through a list, setting each listItem to a
column


I'm afraid it does not work. I replaced my script with yours and
it did'nt work. There is one column which contains commas in it, I want
to escape the comma, I have made an effort, but I can't get my head
round it which is why I'm asking for other people's help. Here is an
example

2003/09/09 14:49:05, "TestUser1",
"/Doc/News/Budgeting,Forecasting & Reporting.doc", "OK"

As you can see the string "/Doc/News/Budgeting,Forecasting &
Reporting.doc" has a comma in it, I want to escape it.

Thanks for your help

>The script wasn't meant to give you a regexp to replace the
commas. It
>does the entire job of creating the query and takes the " as a
>qualifier into consideration. Replace your script by mine and
it
>should work.
>
> -----Oorspronkelijk bericht-----
> Van: ColdFusion Programmer
[mailto:[EMAIL PROTECTED]
> Verzonden: wo 8/10/2003 17:32
> Aan: CF-Talk
> CC:
> Onderwerp: Re:Looping through a list, setting each listItem to
a
>column
>
>
> I've tried that and it does not work. Here is my code
>
> <cfscript>
> myList = '2003/09/09 14:49:05, "TestUser1",
"/Doc/News/Budgeting,
>Forecasting & Reporting.doc", "OK"';
> myList = REReplace(myList, '^[[:space:]]*([^,
>]*|"([^"]|"")*")[[:space:]]*(,|$)','');
> </cfscript>
> <cfoutput>#myList#</cfoutput>
>
> >This should do it in CF using regexp.
> >There are probably custom tags that will read logs more
efficiently
>
> >though.
>
>
  _____  

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---