How can I create a blank/hardcoded column in a sql query?

sql coldfusion
tylercomp picture tylercomp · Mar 3, 2011 · Viewed 161.2k times · Source

I want have a query with a column that is a hardcoded value not from a table, can this be done? I need it basically as a placeholder that I am going to come back to later and fill in.

example:

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. I have tried the space() function but have been unable to get it to work.

Thanks.

Answer

Galz picture Galz · Mar 3, 2011 
SELECT
    hat,
    shoe,
    boat,
    0 as placeholder
FROM
    objects

And '' as placeholder for strings.

Related questions

Select one column DISTINCT SQL

Added: Working with SQL Server 2000 and 2005, so has to work on both. Also, value_rk is not a number/integer (Error: Operand data type uniqueidentifier is invalid for min operator) Is there a way to do a single column "DISTINCT" …

Read More
Best approach to remove special characters using ColdFusion and Microsoft SQL?

I want to remove all special characters (",/{}etc.) from an input field being saved as a string to the DB. What is the best approach? Should this check be tackled with JS, ColdFusion or Microsoft SQL - Maybe all three? …

Read More
Using BETWEEN on a varchar field not a numeric field?

I am using ColdFusion 8 and SQL Server 2008 R2. I am trying to query a column of values to get rows with a value within a range. The column SHOULD be numeric, but it's not. It's setup as a varchar (by …

Read More