<cfquery name="Procedures" datasource="COSI" dbtype="ODBC">
SELECT Category, Sections, DocTitle, DocLink, DocID
FROM tblDocs, tblCategories, tblSections
WHERE tblCategories.CatID=tblSections.CatID
AND tblSections.SecID=tblDocs.SecID
</cfquery>
<cfform name="TreeForm" action="submit.cfm" method="POST">
<cfoutput query="Procedures">
<cftree name="ProceduresTree" hscroll="no" vscroll="yes"
border="no" height="1000" width="500" required="no" >
<cftreeitem value="Category, Sections,
DocTitle"
query="Procedures" queryasroot="Category"
img="cd,folder,folder,document">
</cftree>
</cfoutput>
</cfform>
This is what I want, but additionally I want it to make the DocTitle level
hyperlinks to the pages and I want only the first level expanded, not the
whole tree.
I started to play with looping through CFTREEITEM but did not have much
luck.
Thanks!
-----Original Message-----
From: Allen [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 27, 2000 11:27 AM
To: [EMAIL PROTECTED]
Subject: Re: Question - Multiple Records
Can you post the code that you currently have so we can better figure out
exactly what you're are doing right now?
thank you.
-Allen
----- Original Message -----
From: "Greg Edmonds" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 27, 2000 9:34 AM
Subject: Question - Multiple Records
> I'm inserting several records into one field of an Access dB. The field
> looks like this: record1,record2,record3... etc. The problem I am having
> is displaying these records. If a person chooses several records they
> string across the page. Is there any way to put a <br> in between these
> records? I have tried to put a break after the #fieldname#, but it thinks
> this record is one long sentence. I know this is probably a real stupid
> question, but it has me baffled right now.
>
> Thanks,
> Greg
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
