Hello,
I'm trying to set up a structure based on unique values in a flat SQL database
with unique id's. And then output values in the structure in a hierarchy kind
of like:
1
|
2 3 9
|
4 5 6
|
7 8
I believe can loop through and exhaust all the values based on a lookup list of
what structure has been outputted. But I'm having a problem thinking about the
natural flow of the output and joining up the parent with children in the
hierarchy.
Is this possible or very easy? I'm basically wanting a cfdump type output that
I can manipulate the HTML/javascript. The below code is how I want to set up
the structure. Any thoughts would be great.
<cffunction name="maketextform" access="public">
<cfargument name="id" required="Yes" type="numeric">
<cfargument name="value" required="no" default="">
<cfargument name="js" required="no" default="">
<cfset this.id = arguments.id>
<cfset this.value = arguments.value>
<cfset this.js = arguments.js>
<cfset starttag = '<input type="text" id = "#this.id#"
value="#this.value#" onclick="#this.js#">'>
<cfreturn starttag>
</cffunction>
<cfparam name="datacontainer" default="#arraynew(1)#">
<cfset container = structnew()>
<cfset tmp = arrayappend(datacontainer,container)>
<cfset aid = arraylen(datacontainer)>
<cfset datacontainer[aid].container.name = "IP">
<cfset scontainer1 = structnew()>
<cfset datacontainer[aid].container.1 = scontainer1>
<cfset datacontainer[aid].container.1.id = 1>
<cfset datacontainer[aid].container.1.value = "I could grab this from a
structure from query2structure ripper 1">
<cfset datacontainer[aid].container.1.name = 'Matter'>
<cfset datacontainer[aid].container.1.js= "alert('dog')">
<cfset datacontainer[aid].container.1.field =
#maketextform(datacontainer[aid].container.1.id,datacontainer[aid].container.1.value,datacontainer[aid].container.1.js)#>
<cfset scontainer2 = structnew()>
<cfset datacontainer[aid].container.1.2 = scontainer2>
<cfset datacontainer[aid].container.1.2.id = 2>
<cfset datacontainer[aid].container.1.2.value = "I could grab this from a
structure from query2structure ripper 2">
<cfset datacontainer[aid].container.1.2.name = 'Matter'>
<cfset datacontainer[aid].container.1.2.js= "alert('dog')">
<cfset datacontainer[aid].container.1.2.field =
#maketextform(datacontainer[aid].container.1.2.id,datacontainer[aid].container.1.2.value,datacontainer[aid].container.1.2.js)#>
<cfset scontainer3 = structnew()>
<cfset datacontainer[aid].container.1.2.3 = scontainer3>
<cfset datacontainer[aid].container.1.2.3.id = 3>
<cfset datacontainer[aid].container.1.2.3.value = "I could grab this from a
structure from query2structure ripper 3">
<cfset datacontainer[aid].container.1.2.3.name = 'Matter'>
<cfset datacontainer[aid].container.1.2.3.js= "alert('dog')">
<cfset datacontainer[aid].container.1.2.3.field =
#maketextform(datacontainer[aid].container.1.2.3.id,datacontainer[aid].container.1.2.3.value,datacontainer[aid].container.1.2.3.js)#>
<cfset scontainer5 = structnew()>
<cfset datacontainer[aid].container.1.2.5 = scontainer5>
<cfset datacontainer[aid].container.1.2.5.id = 5>
<cfset datacontainer[aid].container.1.2.5.value = "I could grab this from a
structure from query2structure ripper 5">
<cfset datacontainer[aid].container.1.2.5.name = 'Matter'>
<cfset datacontainer[aid].container.1.2.5.js= "alert('dog')">
<cfset datacontainer[aid].container.1.2.5.field =
#maketextform(datacontainer[aid].container.1.2.5.id,datacontainer[aid].container.1.2.5.value,datacontainer[aid].container.1.2.5.js)#>
<cfset scontainer4 = structnew()>
<cfset datacontainer[aid].container.1.4 = scontainer4>
<cfset datacontainer[aid].container.1.4.id = 4>
<cfset datacontainer[aid].container.1.4.value = "I could grab this from a
structure from query2structure ripper 4">
<cfset datacontainer[aid].container.1.4.name = 'Matter'>
<cfset datacontainer[aid].container.1.4.js= "alert('dog')">
<cfset datacontainer[aid].container.1.4.field =
#maketextform(datacontainer[aid].container.1.4.id,datacontainer[aid].container.1.4.value,datacontainer[aid].container.1.4.js)#>
<cfdump var="#datacontainer#">
Thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289431
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
