sql and coldfusion data types

[ice7899]

Hello

I have a column named Activated in a table defined in my .sql as follows

[Activated] [bit] NULL

I am looking to invoke a coldfusion component which updates the table with the following arguement definition

<cfargument name="RActivated" type="numeric" required="yes">

This function is then later called with the following arguement

RActivated = "True"

The Activated column is used to record whether an account has been activated or not

My question is what are the coldfusion types that go with [bit]

Is it right to use type="numeric" or should I use type = "boolean"

Should I set Activated = "True" or activated = "1"

Basically what are the best datatypes to use in a true / false column ?

 

[FALCONSEYE]

it can be 1/0 or y/n or t/f

so, you can set your RActivated = 'T' / 1 / 'F'

http://www.jetansolutions.com

 

[imstillatwork]

also any NON 0 integer is true.

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!