Opps
as I said it was put together on the fly
ignore this at the end of the table creation: ;o)
Mytable = Mytable + endDiv;
-----Original Message-----
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 9:06 AM
To: CF-Talk
Subject: RE: Dynamic Array Help
Rodney:
I have created and array and I'm sending it back to my client page via
activeserver....
Now, I have this array 2 dimensional and I don't know how to take all
the data (which is just my query results) and read it so that I can
break it down into records and populate my form.
Basically we've been working with fusionscrtipt a little and we're
trying to see how powerful it is... I ahd this form working with 1
record per section however we want to be bale to return multiple records
for each category.
I will attach the code but it's a simple chart down the left side are
grades k,1,2,3,4,5 across the top are sciences Life, Earth, Physical.
Now underneath each area, we want the ability to have multip results.
For example. I would like 2 have 2 grade K life science events. Each
event consists of an Action (which is also a dorp down) and event (text
box) and when (text box of when it occurred). So, we need to have the
ability to read through the array, and break it up then have it display
all the data in the correct locations... I know this is kind of jumbled
but do you follow me at all??
Action page:
<cf_fs_activeserver action="getAttributes">
<cfquery name="getinfo" datasource="oll">
select *
from events
where did = '#activeserver.district#'
</cfquery>
<cfif getinfo.recordcount>
<!--- Declare the array --->
<CFSET DistData=ArrayNew(2)>
<!--- Populate the array row by row --->
<CFLOOP QUERY="getinfo">
<!---The item structure we are going to use to store the items
// is going to have seven parts...
// 1. PK ID
// 2. Actions ID
// 3. Title
// 4. Description
// 5. District ID
// 6. Grade
// 7. Science--->
<CFSET DistData[CurrentRow][1]=getinfo.id[CurrentRow]>
<CFSET DistData[CurrentRow][2]=getinfo.AID[CurrentRow]>
<CFSET DistData[CurrentRow][3]=getinfo.Title[CurrentRow]>
<CFSET DistData[CurrentRow][4]=getinfo.Description[CurrentRow]>
<CFSET DistData[CurrentRow][5]=getinfo.DID[CurrentRow]>
<CFSET DistData[CurrentRow][6]=getinfo.Grade[CurrentRow]>
<CFSET DistData[CurrentRow][7]=getinfo.Science[CurrentRow]>
</CFLOOP>
<!--- Return the Array --->
<cf_fs_activeServer action="return" type="ARRAY" name="DistData"
value="#DistData#">
Main Page: (minus html)
<cf_fusionscript action="code">
<cf_fusionscript action="libraries">
form.*
</cf_fusionscript>
<cf_fs_function name="adddist">
<cf_fs_activeserver action="call"
page="adddist.cfm"
district="form.new"
username="form.username"
password="form.password">
form.new = DIST;
form.username = PASS;
form.password = USER;
</cf_fs_function>
<cf_fs_function name="deldist">
<cf_fs_activeserver action="call"
page="deldist.cfm"
district="form.district">
dist = DIST;
</cf_fs_function>
<cf_fs_function name="getdist">
<cf_fs_activeserver action="call"
page="getdist.cfm"
district="form.district">
DistData = DistData;
<cfquery
</cf_fs_function>
</cf_fusionscript>
So, I don't know where to go form here....
-----Original Message-----
From: Bruce, Rodney S HQISEC/SIGNAL
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 11:23 AM
To: CF-Talk
Subject: RE: Dynamic Array Help
Kris
If you are using Fusionscript, which I think you mentioned.
There is a Fusionscript list as well.
You can go to www.fusionscript.com to join.
But here is how I am returning my query results from the server page to
the calling (client page)
<!-----Server Page----------->
<Query>
Get info
</Query>
<CFIF Query.recordcount>
<CFSCRIPT>
<!---returns one record--------------->
myarray =arraynew(1);
myarray [1] = Query.Value1;
myarray [2] = Query.Value2;
myarray [3] = Query.Value3;
myarray [4] = Query.Value4;
myarray [5] = Query.Value5;
<!---If you want all records--------------->
Myarray = arraynew(2);
control = query.recordcount +1;
start = 1;
while (start LT control){
myarray[start][1] = Query.value1[start];
myarray[start][2] = Query.value2[start];
start = start +1;
}
</CFSCRIPT>
<cf_fs_activeServer action="return" name="returnarray"
value="#myarray#" type="array">
<!----Client page, remember CF starts arrays at 1 , Javascript
at
-------->
<!-----inside the Fusionscript Funtion----------------->
<!---for 1D array---->
form.field1 = returnarray[0];
form.field2 = returnarray[1];
form.field3 = returnarray[2];
form.field4 = returnarray[3];
form.field5 = returnarray[4];
<!---for 2d array------->
<!---Normaly I use this for populating select lists---->
<cf_fs_loop from="0" to="arrayLen(returnarray)-1"
index="i">
<cf_fs_select action="addOption"
field="'selectfieldname'"
value="returnarray[i][0]"
text="returnarray[i][1]">
</cf_fs_loop>
Let me know if this is what you were looking or has my caffeine not
kicked in yet ;o)
Rodney
-----Original Message-----
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 7:53 AM
To: CF-Talk
Subject: RE: Dynamic Array Help
Ok.... I've got my array.... However.... Now, I sent it back to where it
needs to go... How do I take the data within the array and basically
query it so I can sort it so I can parse the records out to populate my
form???
-----Original Message-----
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 10:23 AM
To: CF-Talk
Subject: RE: Dynamic Array Help
As in
<cfset array.ID = ArrayNew(1)>
<cfset array.AID = ArrayNew(1)>
<cfset array.ID[count] = value>
-----Original Message-----
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Friday, 28 June 2002 12:16 AM
To: CF-Talk
Subject: Dynamic Array Help
Haven't written a dynamic array in a while and need some help..... I
think ive forgotten how to...
Heres the column names....
ID
AID
Title
Description
DID
Grade
Science
Can someone tell me how to create a dynamic array... I need to store my
query results in an array so I can ship it through my API...
Thanks.
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
