SELECT hat, shoe, boat, somevalue = 0 as placeholder FROM objects then I would loop through this query later and fill in the placeholder. in this example someValue is not a field in objects, I need to fake it. I am doing this in coldfusion and using two datasources to complete one query.
https://stackoverflow.com/questions/5185743/how-can-i-create-a-blank-hardcoded-column-in-a-sql-query

