close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Checkbox unchecked in update.php

Thread began 1/20/2012 4:51 am by gary.brett434358 | Last modified 1/21/2012 10:56 am by Nico | 1137 views | 5 replies |

gary.brett434358

Checkbox unchecked in update.php

Good morning,
Running DA wizard to create my pages I formatted a field to use check box, if I check this box in update or insert page it adds a '1' to the database field. However when I next view this record in update page the check has been removed even though the database still has the record set as '1'. If a user then forgets to recheck the box and updates the form it removes the check from the record?

Its a simple 'UserActive' check box that tells us if a user is live on our DB.

I have run DA wizard on 3 occasions to check I haven't missed anything, am I doing something wrong?

Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

send a copy of the page please.

Sign in to reply to this post

gary.brett434358

Originally Said By: Jason Byrnes
  send a copy of the page please.  



Hi Jason, page is attached, I have run wizard 5 times now just to double check I am not missing something [I probably am!].

On 4 occasions it created this code:
<input type="checkbox" name="ContactActive" id="ContactActive" value="1" />

On 1 occasion it created this code:
<input type="checkbox" name="ContactActive" id="ContactActive" value="<?php echo(str_replace('"', '&quot;', $row_WADAtblcontacts['ContactActive'])); ?>" />

I am using the top line at present, once checked in insert or update pages it writes '1' to db field and appears as '1' on results & detail pages, not a check box. If a user then updates that record the update page opens with check box unchecked, once record is saved it removes the check.

Regards

Gary

Attached Files
tblcontacts_Detail.zip
Sign in to reply to this post

Jason ByrnesWebAssist

leave the value set to 1.

then in the property inspector, click the Dynamic button. Click the lightning bolt next to Check If and select the ContactActive column from the WADAtblcontacts recordset. In the Equal To section, enter 1.

Sign in to reply to this post

gary.brett434358

Originally Said By: Jason Byrnes
  leave the value set to 1.

then in the property inspector, click the Dynamic button. Click the lightning bolt next to Check If and select the ContactActive column from the WADAtblcontacts recordset. In the Equal To section, enter 1.  



That's brilliant Jason, you have sorted again, much appreciated.

regards

Gary

Sign in to reply to this post

Nico

Great

Originally Said By: gary.brett434358
  That's brilliant Jason, you have sorted again, much appreciated.

regards

Gary  




Works perfect.

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...