You're overwriting the same structure with each row. Try this:
<cfquery name="thequery" datasource="datasource">
select *
from ads
</cfquery>
<Cfset stads = structnew()>
<cfoutput query="thequery">
<cfset structinsert(stads, thequery.adid, structnew())>
<Cfset stads[thequery.adid].CDate = thequery.cdate>
.. etc for other fields ...
</cfoutput>
<cfloop index="ii" list="#StructKeyList(stads)#" >
<CFOUTPUT>
AdID is #ii#
CDate is #stads[ii].cdate#
... etc for other fields ...
</CFOUTPUT>
</cfloop>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 3:55 PM
To: CF-Talk
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists