declaring checkboxes in mysql 
Author Message
 declaring checkboxes in mysql
hello all,

I hope someone can help me. I have a form and within it i have two check
boxes. i am sending this information into a database. my question how do i
store the checkboxes names into the database. do i just store one name
as"checkbox" and which field will that be, a varchar or a char.

help please!!



Tue, 29 Mar 2005 00:09:23 GMT
 declaring checkboxes in mysql

Quote:

> I hope someone can help me. I have a form and within it i have two check
> boxes. i am sending this information into a database. my question how do i
> store the checkboxes names into the database. do i just store one name
> as"checkbox" and which field will that be, a varchar or a char.

How the GUI maps to the database is up to the specification for the
application. There could be a one-to-one mapping between GUI and table
columns, and there often is, but there is no requirement for this.

A checkbox would typically map to a column of the datatype bit in MS SQL
Server, and the name of the column would be the same as the text for
the checkbox. But you wouldn't store the name when the users access the
checkbox; you would already have created the table.

I don't know if this makes any sense to you. If you feel you need more
help, you should provide code samples, and tells in which evironment
these forms exists, and how you communicate with MS SQL Server. Ahum,
your subject line contains the name of another database engine, and
if this is not a typo, but you are really using MySQL, then you should
probably ask in a formum devoted to that product.

--

I support PASS - the definitive global community for SQL Server
professionals - http://www.sqlpass.org
The PASS Community Summit is in Seattle Nov 19-22, I'll be there. And you?



Tue, 29 Mar 2005 06:22:08 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Declaring cursors for mysql

2. Checkbox format in datagrid not showing checkboxes

3. jdbc/mysql/mm.mysql

4. getLastID with mySQL; MM.MySQL API

5. MySQL Memo Fields Returned (D5e, BDE5.11, MySQL on Linux Server, MyODBC)

6. ANN: ImportER MySQL-reverse engineer MySQL databases

7. Problem with passwords (MySQL, mm.mysql.jdbc driver)

8. tips on ASP-MySQL port to VB-MySQL

9. MySQL OLE DB v3.0 for Win9x and MySql 3.23.30 on Linux 2.4.9

10. MySQL max query length via mm.mysql-2.0

11. jdbc/mysql/mm.mysql

12. How to declare variable longer than 255 chars?


 
Powered by phpBB® Forum Software