I run this query on a VIEW and I get a list of the column_name's with a data_type of
bit.
SELECT DATA_TYPE, TABLE_NAME, ORDINAL_POSITION,
COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME = N'defaultview') AND (DATA_TYPE = N'bit')
ORDER BY ORDINAL_POSITION
I change the query to get the data_type of a column_name and all the column names that
were
just listed as bit come back as data_type int..
SELECT DATA_TYPE, ORDINAL_POSITION, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME = N'defaultview')
AND (COLUMN_NAME = N'status')
ORDER BY ORDINAL_POSITION
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
