CF_eConstruct ALERT!
Message: Attribute linkHREF is missing. Process aborted.
Consult your documentation for help.

CF_eConstruct ALERT!
Message: File eConstruct_appGlobals.cfm is missing. Process aborted.
Consult your documentation for help.

SELECT a.*, (select count(*) from categories b where b.parent = a.categoryID) as NoOfChild FROM Categories a WHERE a.type = 'MAIN' WHERE a.type = 'SUB' ORDER BY a.sortID

#name#

#name#

#name#

#name#

#title#

--Select a Category-- SELECT * FROM Categories WHERE Parent = #categoryID# ORDER BY sortid #ucase(left(name, 25))#...     #left(name, 25)#... #left(name, 25)#...