2. PHPRunner General questions
  3. [SOLVED]  Check box fields
This topic is locked
[SOLVED]

 Check box fields

 		7/8/2011 11:16:08 AM
PHPRunner General questions
A
 ant author

Can someone please assists, I converted my microsoft access database to MySQL and now am having some problems with some of the fields. The check box fields are now replaced by 1 & 0 and I am not sure how to change it back to check box fields.
F
 		FunkDaddy 7/8/2011

I'm not 100% clear on your question, but I am assuming you are referring to Access "Yes/No" field type right? By default those fields have values of 0 = No and -1 = Yes. In MySQL those are usually handled as field type (referred to as columns like most major db systems out there) of "tinyint", where PHPR assigns 0 = No, and 1 = Yes.
I hope this helps clarify how you should handle true/false or Yes/No fields in MySQL.
Best,
A
 		ant author 7/8/2011



I'm not 100% clear on your question, but I am assuming you are referring to Access "Yes/No" field type right? By default those fields have values of 0 = No and -1 = Yes. In MySQL those are usually handled as field type (referred to as columns like most major db systems out there) of "tinyint", where PHPR assigns 0 = No, and 1 = Yes.
I hope this helps clarify how you should handle true/false or Yes/No fields in MySQL.
Best,


Thanks, that is what i'm trying to set up that a tick box appears instead of 0 & 1's but i'm not sure how to set it using phprunner
F
 		FunkDaddy 7/8/2011

In visual editor you simply double click on the field then on choose "checkbox" in the edit box and it'll format it into the right html input control type for you.
A
 		ant author 7/8/2011



In visual editor you simply double click on the field then on choose "checkbox" in the edit box and it'll format it into the right html input control type for you.


Thanks FunkDaddy, working my way thru PHPRunner and learnt about the visual editor, great program...

Is there a a-z tutorial in getting started with PHPrunner as I am working by trial and error.