what should the datatypes be?

[fxm]

Hi, what would the datatypes will be if it the column is going to accept the data that is a checkbox and stores inside it?

 

[tlbroadbent]

You could use a Bit column which can hold 0 or 1. Or you could use tinyint which holds 0 to 255. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[fxm]

Can the data be stored when it is doing with ASP?

 

[tlbroadbent]

You can store data in a SQL table from ASP. What is your specific question? If you're asking if you can store the state a check box on a form in a SQL table using ASP then the answer is yes. If you want to know how to do that from ASP, I recommend asking the question in an ASP forum. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.