Hi,
This time I'm trying to use Query of Queries to pull some info.
I'm building a forum, so the idea is to pull forumname, then in the
output pull the name of subforums (By pulling forums whose parentforum
id is the same as the one being output.)
But when I try, I get "Expression Error" and "The following error was
produced: PermGen space" in the same error message.
The code causing the error is of course the showsub query:
<cfoutput query="listforums">
<h3>#title#</h3>
<cfquery dbtype="query" name="showsub">
SELECT title FROM listforums WHERE parent_id =
'#forum_id#'
</cfquery>
<cfoutput query="showsub">#title#</cfoutput>
</cfoutput>
I could make another table called subforums and simply run that query,
but I'd like to find out what I'm doing wrong with this one.
Maybe I should just make a list out of the query and use the list
instead? It would also cut down on the number of queries.
--
online documentation: http://openbd.org/manual/
google+ hints/tips: https://plus.google.com/115990347459711259462
http://groups.google.com/group/openbd?hl=en
