Hi All,
Been working on a recursion output for several days now without success.
Using a single category table with ID, Name, ParentID. The nesting is up
to four layers deep. Problem is, I want to tie the results set to documents
that have been posted, with the categoryID referencing the
Did you look at this:
http://nstree.riaforge.org/
On Thu, Jul 24, 2008 at 1:36 PM, Mark Leder [EMAIL PROTECTED] wrote:
Hi All,
Been working on a recursion output for several days now without success.
Using a single category table with ID, Name, ParentID. The nesting is up
to four layers
: Recursion Output Help
Did you look at this:
http://nstree.riaforge.org/
On Thu, Jul 24, 2008 at 1:36 PM, Mark Leder [EMAIL PROTECTED] wrote:
Hi All,
Been working on a recursion output for several days now without success.
Using a single category table with ID, Name, ParentID. The nesting is
up
and levels that correspond with documents/db listings on the
server.
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2008 2:09 PM
To: CF-Talk
Subject: Re: Recursion Output Help
Did you look at this:
http://nstree.riaforge.org/
On Thu, Jul 24
Query Statement
/cfquery
/cfloop
-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 08, 2008 2:41 PM
To: CF-Talk
Subject: Array Read / Output Help
I'm creating an array. It's a list of record numbers to be
looked up later
I'm creating an array. It's a list of record numbers to be looked up later.
This is the code.
cfset DiscArray = ArrayNew(1)
cfset disnum=1
cfloop query=cur_disclaimers
cfset DiscArray[disnum]=#id#
cfset disnum=#disnum# +1
/cfloop
After the array is built it will be a list of
You've got the wrong data structure. If you want to look up a value
and get it's key, you need a data structure that matches that use
case: a CF struct.
cfset s = structNew() /
cfloop query=cur_disclaimers
cfset s[value] = currentRow /
/cfloop
cheers,
barneyb
On Jan 8, 2008 11:41 AM, Robert
I'm creating an array. It's a list of record numbers to be looked up
later.
Is the order of the items important?
Rich Kroll
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free
On Jan 8, 2008 11:41 AM, Robert Harrison [EMAIL PROTECTED] wrote:
I'm creating an array. It's a list of record numbers to be looked up later.
This is the code.
cfset DiscArray = ArrayNew(1)
cfset disnum=1
cfloop query=cur_disclaimers
cfset DiscArray[disnum]=#id#
cfset
couldn't you just do a query of queries on cur_disclaimers? what are
you gaining by creating an array out of a query variable (just
curious) ?
There are about 60 fields in each record that may have disclaimers. The same
disclaimer could be used on many fields and in many records. What I'm
Okay I fell stupid asking this because I have accomplished this many
times I just cant rememeber tonight.
cfquery name=qry_STATES datasource=CaptekLab
SELECT PK_tblSTATEID, State
FROM dbo.tblSTATE
/cfquery
table
cfloop query=qry_states
cfquery name=qry_labs
=qr_states group=CaptekLab.state
#qr_states.state#br
cfoutput#qr_states.lab_name#/cfoutput
/cfoutput
Good Luck
Paul Giesenhagen
QuillDesign
- Original Message -
From: Joshua Tipton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 9:10 PM
Subject: Output
48 : /body
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 10:17 PM
To: CF-Talk
Subject: Re: Output Help
Try this... I didn't do the caps thing like you are doing but you should
get
the jist!
cfquery name=qr_states datasource
: RE: Output Help
Output one record then bombed with this error
The Error Occurred in
C:\Inetpub\wwwroot\captek\apps\LabList\showlablist.cfm: line 46
44 : cfoutput query=qr_states group=CaptekLab.state
45 : #qr_states.state#br
46 : cfoutput#qr_states.lab_name#/cfoutput THIS LINE
14 matches
Mail list logo