<!--- Query for top level vendors. --->
<cfquery name="qTopLevelVendor" dbtype="query">
		(
			SELECT
				id,
				name,
				has_children
			FROM
				qVendor
			WHERE
				parent_id = 0
		)

	UNION

		(
			SELECT
				parent_id,
				parent_name,
				CAST( 0 AS INTEGER ) AS has_children
			FROM
				qVendor
			WHERE
				parent_id != 0
		)
</cfquery>