home Links Articles Books Past Meetings Photos SiteMap
The MDCFUG is sponsored by TeraTech. Visit us at www.TeraTech.com

Please send
comments/questions to


PPT Slide

PPT Slide

    Example: Query Cell Containing an Array

    <CFSET Colors = ArrayNew(1)>
    <CFSET Colors[1]="Red">
    <CFSET Colors[2]="Silver">
    <CFSET Colors[3]="Blue">
    <CFSET Products = QueryNew("ProductName, Color, Price, Qty")>
    <CFSET NewRows = QueryAddRow(Products, 2)>
    <CFSET QuerySetCell(Products, "ProductName", "Widget", 1)>
    <CFSET QuerySetCell(Products, "Color", Colors, 1)>
    <CFSET QuerySetCell(Products, "Price", "19.99", 1)>
    <CFSET QuerySetCell(Products, "Qty", "46", 1)>
    <CFSET QuerySetCell(Products, "ProductName", "Thingy", 2)>
    <CFSET QuerySetCell(Products, "Color", Colors, 2)>
    <CFSET QuerySetCell(Products, "Price", "34.99", 2)>
    <CFSET QuerySetCell(Products, "Qty", "12", 2)>
    <CFDUMP VAR="#Products#">

Previous slide Next slide Back to first slide View graphic version

Home | Links | Articles | Past Meetings | Meeting Photos | Site Map
About MDCFUG | Join | Mailing List |Forums | Directions |Suggestions | Quotes | Newbie Tips

Copyright © 1997-2018, Maryland Cold Fusion User Group. All rights reserved.
< >