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?

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.

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.

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.

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?

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

See the image attached

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.

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.

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.

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