Try this... I'm using your "adID" as the key to each structure row...
<cfquery name="thequery" datasource="datasource">
select *
from ads
</cfquery>
<cfscript>
stads = StructNew();
for (x = 1; x LTE thequery.recordcount; x = x + 1) {
curkey = thequery.adID[x];
stads.curkey.CDate="#thequery.CDate#";
stads.curkey.Email="#thequery.Email#";
stads.curkey.Phone="#thequery.Phone#";
stads.curkey.City="#thequery.City#";
stads.curkey.AdDesc="#thequery.AdDesc#";
}
</cfscript>
That should build up your structure so you have all the rows. Then you can say
"StructDelete(stats, x)" I believe, to nuke a particular row "x".
-----Original Message-----
From: [EMAIL PROTECTED]
Sent: Thu, 14 Dec 2000 14:54:50 -0600
To: [EMAIL PROTECTED]
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
