This is a multi-part message in MIME format.
----596e4d5276c53d5
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
(Hope I haven't missed a solution to this...)
I'm using a query to create records for building a CFTREE item. My
query goes thusly:
---===+++< Query begins >+++===---
<cfquery name="catAddCatSubSelect" datasource="#application.DSN#">
SELECT intra_categories.categoryID,
intra_categories.categoryTitle,
intra_subcategories.subcategoryID,
intra_subcategories.subcategoryTitle
FROM intra_categories, intra_subcategories
WHERE intra_categories.categoryID = intra_subcategories.categoryID
AND
intra_categories.intraID=#session.intraid# AND
intra_categories.tableID=#URL.tableid#
ORDER BY categoryTitle, subcategoryTitle
</cfquery>
---===+++< Query Ends >+++===---
When using "normal" CFOUTPUT the following output occurs:
---===+++< "Normal" CFOUTPUT begins >+++===---
IMT Newsletter(10)
---n/a(10)
JSCC Newsletter(13)
---n/a(13)
Standard Financial Instructions(12)
---n/a(12)
Standing Orders(14)
---n/a(14)
TRACY Lottery Results(16)
---n/a(16)
Team Briefings(11)
---n/a(11)
Test Category(112)
---Rename This(157)
---Subtest 1(159)
---===+++< "Normal" CFOUTPUT ends >+++===---
---===+++< Code for above begins >+++===---
<cfoutput query="catAddCatSubSelect" group="categoryTitle">
<a href="dsp_cat-sub-add.cfm?
categoryID=#categoryID#&tableid=#URL.tableID#"
target="catAddRight">#categoryTitle#(#categoryID#)</a><br>
<cfoutput>---#subcategoryTitle#(#subcategoryid#)<br></cfoutput>
</cfoutput>
---===+++< Code for above ends >+++===---
However, when I run it through CFTREE I get the following:
---===+++< CFTREE Output Begins >+++===---
IMT Newsletter
--- n/a
JSCC Newsletter
--- n/a
Standard Financial Instructions
--- n/a
Standing Orders
--- n/a
------ TRACY Lottery Results
---------- n/a
------ Team Briefings
---------- n/a
------ Test Category
---------- Rename This
---------- Subtest1
---===+++< CFTREE Output Ends >+++===---
The CF code I use to get this (unexpected) result is below:
---===+++< Code for CFTREE output begins >+++===---
<cfform action="bing" method="POST" enablecab="Yes">
<cftree name="treeTest" font="Arial" fontsize="10" bold="No"
italic="No" border="Yes" hscroll="Yes" vscroll="Yes" required="Yes"
completepath="No" appendkey="No" highlighthref="Yes" width="200"
height="300">
<cftreeitem value="#session.intraid#" display="Add Categories
(#UCase(Left(gettablesuffix.tabletitle,1))##Right
(gettablesuffix.tabletitle,(Len(gettablesuffix.tabletitle)-1))#)"
img="fixed" expand="Yes" parent="treeTest" href="dsp_cat-add.cfm?
tableid=#URL.tableid#" target="catAddRight">
<cfoutput query="catAddCatSubSelect" group="categoryTitle">
<cftreeitem value="#categoryID#" parent="#session.intraid#"
display="#categoryTitle# (#categoryID#)" expand="No" queryasroot="No"
img="folder" href="dsp_cat-sub-add.cfm?
categoryID=#categoryID#&tableid=#URL.tableID#" target="catAddRight">
<cfoutput>
<cftreeitem value="#subCategoryID#" parent="#categoryID#"
display="#subcategoryTitle# (#subcategoryID#)" expand="No"
queryasroot="No" img="folder">
</cfoutput>
</cfoutput>
</cftree>
</cfform>
---===+++< Code for CFTREE output ends >+++===---
The problem is that TRACY Lottery Results, Team Briefings & Test
Category should be on the same level as Standing Orders is the CFTREE,
like they are with the "normal" CFOUTPUT.
The tables I use to build the item are intact/non-corrupted. In fact,
the CFTREE item works for other values of #URL.tableid#.
Does anyone have any idea why I might be getting this problem with the
CFTREE?
Many thanks in advance.
- Alan Willis
----596e4d5276c53d5
Content-Type: text/x-vcard; name="AWillis.vcf"; charset=us-ascii
Content-Disposition: attachment; filename="AWillis.vcf
Content-Description: Card for Alan Willis <[EMAIL PROTECTED]>
Content-Transfer-Encoding: 7bit
begin:vcard
n:Willis;Alan
fn:Alan Willis
tel;fax:01382-424466
tel;work:01382-561818, x70277
url:http://www.tayside.scot.nhs.uk/finix/
org:Tayside Health Board;FINIX
adr:;;Maryfield House, 30 Mains Loan;Dundee;Tayside;DD4 7BT;SCOTLAND
version:2.1
email;internet:[EMAIL PROTECTED]
end:vcard
----596e4d5276c53d5--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
