Try searching Allaires tag gallery for the QueryToStruct tag :-)
jon
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 14, 2000 3:54 PM
Subject: Structures?????
> I'm getting frustrated with this. I want to build a structure from a query
with multiple fields in each record
> in the structure. Then query the structure for a particular row. In other
words use a structure like a DB
> table insert/edit/delete. I seem to be getting only one record in the
structure. Anyone see what is wrong
> with this code??
>
>
> <cfquery name="thequery" datasource="datasource">
> select *
> from ads
> </cfquery>
> <cfscript>
> stads = StructNew();
> stads.adID="#thequery.adID#";
> stads.CDate="#thequery.CDate#";
> stads.Email="#thequery.Email#";
> stads.Phone="#thequery.Phone#";
> stads.City="#thequery.City#";
> stads.AdDesc="#thequery.AdDesc#";
> </cfscript>
> <cfloop query="thequery">
> <CFSCRIPT>
> stads=StructNew();
> StructInsert(stads, "adID", "#thequery.adID#");
> StructInsert(stads, "CDate", "#thequery.CDate#");
> StructInsert(stads, "email", "#thequery.email#");
> StructInsert(stads, "phone", "#thequery.phone#");
> StructInsert(stads, "City", "#thequery.City#");
> StructInsert(stads, "AdDesc", "#thequery.AdDesc#");
> </CFSCRIPT>
> </cfloop>
> <cfloop index="ii" list="#StructKeyList(stads, ',')#" delimiters=",">
> <CFOUTPUT>
> AdID is #StructFind(stads, "AdID")#
> CDate is #StructFind(stads, "CDate")#
> EMail is #StructFind(stads, "email")#
> Phone is #StructFind(stads, "phone")#
> City is #StructFind(stads, "City")#
> AdDesc is #StructFind(stads, "AdDesc")#
> </CFOUTPUT>
> </cfloop>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
