Hi Guys, I guess I missed it. I have been off the list for a while. I am running CF Studio 4.5 and CF 4.5. About to upgrade one of our servers to MX.(CF 5) I see on the MM site that there is a CF Studio MX, but the doc says it includes dreamweaver. Am I to assume that I will be forced fed dreamweaver, or does the studio MX still have my beloved CF Studio? What's the scoop? Regards, Joe Hansen
----- Original Message ----- From: "Kris Pilles" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 12:06 PM Subject: RE: Dynamic Array Help ould I assume that they are gooing to force feed us > 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
