apparently you do not need the first set of struct ure definitions... i took
your code and modified to work with a table i had... worked just fine...
here's the code...
<cfquery name="thequery" datasource="facilitador" dbtype="ODBC"
username="sa" password="">
select *
from courses</cfquery>
CourseTitle
<!---
NOTICE I JUST COMMENTED THIS SECTION OUT!!
<cfscript>
stads = StructNew();
stads.courseid="#thequery.courseid#";
stads.datecreated="#thequery.datecreated#";
stads.title="#thequery.CourseTitle#";
stads.active="#thequery.active#";
</cfscript>
--->
<cfloop query="thequery">
<CFSCRIPT>
stads=StructNew();
StructInsert(stads, "courseid", "#thequery.courseid#");
StructInsert(stads, "datecreated", "#thequery.datecreated#");
StructInsert(stads, "title", "#thequery.CourseTitle#");
StructInsert(stads, "active", "#thequery.active#");
</CFSCRIPT>
</cfloop>
<cfloop index="ii" list="#StructKeyList(stads, ',')#" delimiters=",">
<CFOUTPUT>
courseid is #StructFind(stads, "courseid")#<br>
datecreated is #StructFind(stads, "datecreated")#<br>
title is #StructFind(stads, "title")#<br>
active is #StructFind(stads, "active")#<br>
<hr>
</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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
