<--- --------------------------------------------------------------------------------------- ----
	
	Blog Entry:
	Why My Queries Hate Application Service Layers
	
	Author:
	Ben Nadel / Kinky Solutions
	
	Link:
	http://www.bennadel.com/index.cfm?dax=blog:1614.view
	
	Date Posted:
	Jun 18, 2009 at 10:02 AM
	
---- --------------------------------------------------------------------------------------- --->


qProject >>
SELECT
	p.id,
	p.name
FROM
	project p
WHERE
	p.id = #project_id#
 
qAsset >>
SELECT
	a.id,
	a.name,
	a.filename,
	a.project_id
FROM
	asset a
WHERE
	a.id = #asset_id#
 
Validation >>
if
	(NOT qProject.RecordCount) OR
	(NOT qAsset.RecordCount) OR
	(qProject.id NEQ qAsset.project_id)
then
	// Throw error that data was not valid.