[FX.php List] Problem with checkbox set validation

[Dale Bengston]

I'm recalling that FileMaker stores checked checkbox items as return- 
separated text. If you are not submitting your web-selected checkbox  
values separated by \n, they'll fail validation. One way to test this  
is to momentarily shut off your field validation in FMP, submit a web  
entry and see what ends up in that field. (Formatted to display as  
text, not as check boxes.)

Dale

On May 20, 2007, at 7:40 PM, Edward L. Ford wrote:

> I did look at a copy of $_SESSION (the data is stored there), and  
> the values are exactly as they are expected.  There's nothing  
> outside of the ASCII character set used.  What's weirder is that  
> through PHP, this works fine, no error, on NEW records, and only  
> sometimes.  But when editing a record, it never works.
>
> On May 20, 2007, at 8:17 PM, Kevin Futter wrote:
>
>> On 21/5/07 10:01 AM, "Edward L. Ford" <elford at cs.bu.edu> wrote:
>>
>>> Hello,
>>> I'm facing a really annoying problem right now.  I have a field  
>>> in a FM database that is a set of checkboxes, derived from a  
>>> value list.  I can check and uncheck different boxes without a  
>>> problem.
>>>
>>> In my PHP pages, I present the same set of checkboxes by  
>>> extracting them from FM through FMView -- and I set the "value"  
>>> field of the HTML element to be values from the FM value list.   
>>> I've made sure that this value list is used on the layout that my  
>>> PHP pages call.  The problem is that when I attempt to submit  
>>> FORM data back to FM, I get the error code 506, Value in field is  
>>> not listed on the value list specified in validation entry option.
>>>
>>> I have several other checkbox sets on the same FM layout, as well  
>>> as the same PHP page, and none of the others are giving me a  
>>> problem -- they all are using the same sort of code that is  
>>> modified for each set of checkboxes.
>>>
>>> I'm stuck -- it's been two days and I haven't been able to  
>>> identify the problems.  Can anyone here suggest what I might be  
>>> missing, especially with that error code in particular?
>>>
>>> Thanks,
>>
>> Just an educated guess, but I would look for encoding issues – do  
>> you have any non-ASCII characters in the value list that could be  
>> encoded on the way back to the database? This would most likely  
>> cause a mismatch between the incoming value and the value list  
>> entry it’s supposed to represent. Try printing the POST array to  
>> see exactly what it contains.
>>
>> -- 
>> Kevin Futter
>> Webmaster, St. Bernard's College
>> http://www.sbc.melb.catholic.edu.au/
>> This e-mail message has been scanned for Viruses and Content and  
>> cleared by MailMarshal
>>
>> This e-mail and any attachments may be confidential. You must not  
>> disclose or use the information in this e-mail if you are not the  
>> intended recipient. If you have received this e-mail in error,  
>> please notify us immediately and delete the e-mail and all copies.  
>> The College does not guarantee that this e-mail is virus or error  
>> free.  The attached files are provided and may only be used on the  
>> basis that the user assumes all responsibility for any loss,  
>> damage or consequence resulting directly or indirectly from the  
>> use of the attached files, whether caused by the negligence of the  
>> sender or not. The content and opinions in this e-mail are not  
>> necessarily those of the College.
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070520/e3292ba7/attachment-0001.html