close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Checkbox Values?

Thread began 6/08/2009 4:14 pm by chad341774 | Last modified 9/09/2009 12:26 pm by tom92909 | 1652 views | 4 replies |

chad341774

Checkbox Values?

Hi,

I have a comment approval system for one of my clients and I am using a Checkbox to approve (ie: Yes ) the comments. The problem is that it Data Assist only allows you to give a value if the Checkbox is checked. How do i give it a value if the box is not checked or unchecked (ie: No) ?

Sign in to reply to this post

Ray BorduinWebAssist

It should allow you to set the type of that field to "Checkbox Yes, No" which will insert the negative value when unchecked.

Sign in to reply to this post

tom92909Beta Tester

So a checkbox field (logical field) should always be numeric? Either a '1' or a '0' ?
Could you make a checkbox function correctly with updating records with that field being a CHAR(1)?

php:
<?php 
if ($row_WADAgallery['status'] == 'Y') {
?>
<td>Disable</td><td><input name="status" type="checkbox" value="N"></td>
<?php
} else {
?>
<td>Make Live!</td><td><input name="status" type="checkbox" value="Y"></td>
<?php
}
?>



The above isn't working correctly. The value already stored is getting changed to the opposite on every update save. This requires an additional separate update to change the original setting back to the correct state.

What am I doing wrong here?

Thanks!

Sign in to reply to this post

Ray BorduinWebAssist

What is the field type you have set up in DataAssist.

Here is the problem, when you don't check a checkbox it doesn't return a value, when you do it returns the value specified.

Your technique to have a checkbox to disable or to enable depending on the start value just doesn't fit the paradigm very well. It would be much easier to have a single checkbox "check to enable or uncheck to disable".

Trying to get what you are doing to work would require more hand coding where the field is updated in the server code as well.

Sign in to reply to this post

tom92909Beta Tester

Ray,

As always thank you for your assistance. From your comments, I was able to successfully alter my technique by removing the 2nd checkbox entry and produce a functional solution.

php:
<td>Make Live!</td><td><input <?php if (!(strcmp($row_WADARecordset1['status'],"Y"))) {echo "checked=\"checked\"";} ?> name="status" type="checkbox" value="Y"></td>



This was a case of over thinking the process. The above solution provides exactly what I needed!

Thanks again!

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...