True / False value in SQL so i can have a checkbox in my asp front end

Hi,

i want to be able to grant admin rights by using a simple checkbox in asp that when checked and submitted as part of a form, it passes a true value to the sql database.

my question is what is the data type should i use in sql and how might i implement it?

thanks
sweeting89Asked:
Who is Participating?
 
Lee SavidgeCommented:
Use a bit which is 1 or 0

Lee
0
 
Lee SavidgeCommented:
declare @b bit

select @b = 1 -- 1 is true

or select @b = 0 -- 0 is false

0
 
Alpesh PatelAssistant ConsultantCommented:
for True/False bit is best
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
sweeting89Author Commented:
thanks, where would i declare that 1 is true and 0 is false? and how exactly would it look?

thanks
0
 
Lee SavidgeCommented:
1 is true and 0 is false. This is normal behaviour. Historically -1 is true because it is a bit mask showing all bits as 1 including the sign.
0
 
Lee SavidgeCommented:
You could equally have a varchar field that says 'true' or 'false'. It depends how you represent the value in your database on the front end asp.net code. In this case though a bit field is your best choice of datatype.

0
 
sweeting89Author Commented:
short but to the point
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.