close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Radio button problems and code errors

Thread began 11/22/2010 4:51 pm by mrs | Last modified 3/17/2011 9:52 am by Jason Byrnes | 1951 views | 11 replies |

mrs

Radio button problems and code errors

Hi, I have been using data assist for a number of years now, and not once have I been able to get radio buttons to work for me.

What I am trying to is create a yes or no situation in order to show a record and I am trying to pass values of yes or no into the DB.

Data assist only allows me to create the radio buttons, it doesn't allow me to bind any data to them. With regards to the insert page this is fine because I can amend the code to be able to insert the correct choice of yes or no, however, when it comes to the update page, I cannot for the life of me get the radios to pull in the data or in turn submit the correct data. In fact, what is happening is that the database field is being emptied of any content even if I select one of the blank radios!

I have tried selecting the radio button and then clicking on the 'Bind to Dynamic source' button in the properties panel, I bind it to the 'show' field of the WADA recordset and then the page gets a code error. I have tried binding it manually but to no avail.

Could you please advise as I have now been at this for seven hours! And that's just today!!

An image of the error I am getting is attached.

Also, every time I run this now, I am getting a blank panel appear which has the title of properties. I have to close it every time! Why is this happening?

Sign in to reply to this post

Jason ByrnesWebAssist

can you send a copy of the page in a zip archive so i can see the code, it's impossible to read the code in the image that us attached.

Sign in to reply to this post

mrs

Thanks Jason, but I have just within the last few minutes figured out a way to get it to work.

What I have to do is take the radios provided remove any binding, then add the value="XX" to each radio button, then from the server behaviours panel + button I choose Dynamic Form Elements -> Dynamic Radio Group and select the show data from the WADA recordset.

It's a shame it doesn't work straight from the wizard for either the radios or the menu. Is this always meant to be the case? The update page for radios and menus always fails to pull the correct data from existing records.

I now have a big problem with updating a file upload. The initial insert page works great, but the update will not. I'll post in that forum for that.

Sign in to reply to this post

Jason ByrnesWebAssist

it should work from within the wizard as you are expecting.

What is your version of DataAssist?

What version of Dreamweaver"

What is your OS

What other extensions do you have installed.

I just ran through a quick test and the code was generated correctly.

Sign in to reply to this post

mrs

I downloaded the latest version last night due to the errors I was receiving. I have 2.0.7.

I am not able to bind the radios to any data in the same way that I can with a menu. I have no option to be able to control anything that the radios do. I never have done since I bought Super Suite three or four years ago.

I'd expect it to work like the menu selection... I get to choose a table that populates the radio group, and as a result it should receive more than two radio buttons, however, I only ever get two radios that have a rudimentary data connection, but none that pertains to the content that I need it to.

Currently, I only need two buttons which are yes and no, however, there has been situations that I might need something like a maybe option too. Basically, what I have got is a static set of buttons with no values attributed to them that I have to recode in order to get them to submit data.

I'm running Mac (10.6 now, but have used since 10.4 or less, and I have also used on WinXP). I'm using up-to-date CS5 but have used with all earlier versions. As far as extensions, I have pretty much every extension you have made, and I have them latest versions of them, and I have also removed any that are duplicated in newer versions such as the likes of digital file upload which is now in form builder 2.

For this to have been consistent throughout all versions I have had, and across several computers, what do you think is wrong? Is the radio option meant to allow me to select the data via the lightening bolt? Currently it greys out. Am I expecting this to do something that it hasn't been designed to do?

Sign in to reply to this post

mrs

I'm also still getting the blank properties panel appear for some reason!

See the image attached

Sign in to reply to this post

Jason ByrnesWebAssist

Radio buttons do not work the same as a menu, you will not be able to bind them to a table in the wizard, this is not the intent for the radio button form type.

once the page has been created by the wizard, you should be able to give the radio buttons a dynamic value, but this cannot be accomplished in the wizard.



when the proprety panel is blank, it is because something was selected in design view that does not have properties.


make sure you are selecting the radio button itself in design view and not another element on the page like the label.

with the radio button selected, the property panel should show a dynamic button, his is where you can select dynamic properties for the button.

Sign in to reply to this post

mrs

Hi Jason. This is an entirely new properties panel that appears, even though I already have the properties panel open and snapped to the bottom of the screen. In fact, I never close the properties panel because it is constantly used, so why a new one is appearing instantly after I run the wizard is new to me.

Is it a webassist properties panel? If so, that would explain it's blank appearance as I have never seen the dreamweaver properties panel empty... as you can see from the image I uploaded, one panel has contextual content visible, the other has nothing which I can't understand.

Sign in to reply to this post

Jason ByrnesWebAssist

No, it is not a webassist properties panel, i have never seen a blank properties panel show up after running the wizard, I cannot say what is causing it, probably wont effect anything though if you just close it.

Sign in to reply to this post

Russell CollinsBeta Tester

Hi mrs,

As Jason indicated, radio buttons are more like a number selector function.
1 would = yes
0 would = no
So if a buttons checked value was 1 it would mean yes
And if the second buttons checked value was 0 would mean no.

You can of course have as many buttons as you like to express other meaning such as colour
button1 checked value 1 = red
button2 checked value 2 = blue
button3 checked value 3 = yellow and so on.

This is why when you run the wizard you get only 2 radio buttons.
The wizard stitches the "functionality" of the buttons between the pages,
but it is up to you to add what sort of checked values you want and, how many.

So in the example above

step 1 would be to ensure your database set up correctly for this type of use.

Lets look at the most basic db.
Table name = yes_no
field1 IDyesno, INT(11), auto inc, pk
field2 decision, tinyint(1) - this data will be either 1 or 0 ( equating to yes or no)
field3 description, VARCHAR(64) - a persons name for example if your doing a survey

Step 2
on the search page
Select the button you labeled yes and put 1 as the checked value (by default it adds the word radio)

Step 3
on the search page
Select the button you labeled no and put 0 as the checked value (again it will have the word radio in it)

Your search functions will now work with field 2 of the database

Step 4
on the insert page
Repeat the same as in step 2 & 3

Step 5
on the update page
Select the yes button
remove the code that was placed in the "checked value" in the properties tab and replace it with the number 1

Step 6
Select the "bind to dynamic source" button on the properties tab and set the value to the field2 "decision" in the recordset from the above db

step 7
on the update page
select the no button
remove the code that was placed in the "checked value" in the properties tab and replace it with the number 0

Step 8
on the update page
Select the "bind to dynamic source" button on the properties tab and set the value to the field2 "decision" in the recordset from the above db

This will give you all the functionality of insert, update, search etc on the subject of yes/no
One point to take into consideration is that on the search results it will show 1 or 0 in the dynamic text of field2 column, the same will also apply to the details page.
If you wanted to have the name yes or no you could do an inner join from a 2 row db.
for example
table name = decision
field1 ID INT(11)
field2 Decision VARCHAR(10)
0===No
1===Yes

You could however just use a static menu to get the same results into a db as text.

Regards

Russ

Sign in to reply to this post
loading

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