User Profile

Collapse

Profile Sidebar

Collapse
cymark
cymark
Last Activity: Apr 7 '09, 05:58 PM
Joined: Mar 9 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • cymark
    replied to How to I create blank columns using QueryAddColumn?
    in Coldfusion
    Hi,

    Sorry was a bit quick there.

    The following seems to work OK:

    Code:
    <cfset myQuery = QueryNew("")>

<cfset FastFoodArray = ArrayNew(1)>
<cfset FastFoodArray[1] = "French Fries">
<cfset FastFoodArray[2] = "Hot Dogs">
<cfset FastFoodArray[3] = "Fried Clams">
<cfset FastFoodArray[4] = "Thick
    ...
    See more | Go to post
    Last edited by acoder; Mar 11 '09, 04:35 PM. Reason: Added [code] tags

      Leave a comment:

    • cymark
      replied to How to I create blank columns using QueryAddColumn?
      in Coldfusion
      Try this:

      Code:
      <cfloop ....>
    
   <cfset col = "Detail"&#I#>
   <cfset temp = QueryAddColumn(#this.RecordSet#, "#col#", "VarChar", newArray) />

</cfloop>
      Or try dynamic variables - lookup Evaluate function.

      Good luck - CM
      See more | Go to post
      Last edited by acoder; Mar 10 '09, 01:11 PM. Reason: Added [code] tags

        Leave a comment:

      No activity results to display
      Show More
      Working...