[phorm] [Phorm:] Re: checkbox won't record in MySQL

  • From: webbbs@xxxxxxxxx
  • To: support@xxxxxxxxx
  • Date: 17 Jul 2004 21:45:41 -0000

The following new message has been posted on Phorm Support Forum at 
<http://www.phorm.com/support/>. 

*************************************************************************** 

  MESSAGE:  (#4191) Re: checkbox won't record in MySQL 
            <http://www.phorm.com/support/?rev=4191> 
  AUTHOR:   WGreyHawk 
  DATE:     July 17, 2004 at 5:45 p.m. EST 

  Reply To: (#4190) checkbox won't record in MySQL 
  Author:   WGreyHawk 
  Date:     July 17, 2004 at 4:27 p.m. EST 

Alright, part of it was a stupid mistake in the config file. I can now get it 
to record it to the database as long as I set a value="1" in the form, but 
shouldn't a boolean be recorded even without a value attribute being set??? I 
mean, it gets sent as "on" when put into the email... to me, it would make 
sense that there should be a way of having this passed to the database. Am I 
way off base here or what? 

> I'm new to databases and am having trouble getting a 
> checkbox to record anything in the database. I set it 
> tinyint(1), assuming that it gets sent as a simple 
> boolean value. But whether the checkbox is checked or 
> not, no matter what, it's always the default zero in 
> the database. I've even tried setting the columns as 
> text and using value="whatever" in the 
> form... but that wouldn't record in the database 
> either... 

> Meanwhile, the data does get sent via email - but not 
> recorded in the database... grrrrrrrrrrrrrrrrr! 

*************************************************************************** 

This is an automatically-generated notice.  If you'd like to be removed from 
the mailing list, please visit Phorm Support Forum at 
<http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx  If 
you wish to respond to this message, please post your response directly to the 
board.  Thank you! 
-------------------------------------------------
You are receiving this message because you are subscribed to the Phorm mailing 
list. To send messages to the mailing list, simply send email to 
phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe 
from the list by sending email to phorm-request@xxxxxxxxxxxxx with 
'unsubscribe' in the SUBJECT field.

Other related posts:

  • » [phorm] [Phorm:] Re: checkbox won't record in MySQL