PDA

View Full Version : field type help..


markc1822
06-12-2007, 02:41 PM
Hi, how are you guys.
I have a question; I created a little form all text fields which allow users to submit information into my database. The problem is that I want to be able to allow or deny certain submissions, before it goes to the main page. Is there a way I can add a yes/no field to my database? I looked through the field types in EMS but I do not see any yes/no fields.


Thanks
Mark

davidj
06-12-2007, 02:51 PM
just use a checkbox for this with a value of 1 if checked. You could then treat every 1 as a yes

markc1822
06-12-2007, 02:59 PM
The checkbox, i would have to do this from dreamweaver? There is no way to do this from the database by changing the "field type" ?

davidj
06-13-2007, 06:11 AM
your wanting a boolean response. i dont think Mysql has such a data type but why do you need that specific data type when a numeric type of 1 would do the job perfectly. This is how boleans work anyway. I think you may have your ACCESS head on.

markc1822
06-14-2007, 02:06 AM
k, thank you davidj. Is there some where i can go that explains all the field types and their purpose?

davidj
06-14-2007, 05:53 AM
http://dev.mysql.com/doc/refman/5.0/en/data-types.html