Edit/Update and Radio Buttons

[paul mancuso]

Guys,

When using .dbEditUpdateFlds with radio buttons I can't get the radio buttons to reflect the records data.

here's an example of my code:

Dim eugFlds as string = ""

eugFlds = "fi=ObligateSW|type=radio|val={{0-1}}|tex=Approvalx"

.dbEditUpdateFlds=eugFlds

What am I doing wrong?

[Frank]

sounds like your field data is boolean and you want to use "radio"? or should it be "checkbox" instead ?

Frank

[paul mancuso]

Frank,

Thanks!

The data type is MS SQL's "Bit". I changed from radio to checkbox and it works. Can you explain why this works with checkbox and not with radio. I'm having a hard time distinguishing between the two...

[Frank]

Paul,

You can have many radios for a field like one,two,three.... but you can have only one checkbox for a field which is 1/0.
In the checkbox, asp-db automatcally output the right type of boolean value for the field type. For radio, you have to put in exact type which is different for MS-SQL and Access and some others.



Frank

[paul mancuso]

Frank,

In this case I'm only using 2 radio buttons (yes/no)which is binary. In the Tornado manual I found that I needed to use the .dbBoolText parameters droptrue|dropfalse as well as displaytrue|displayfalse which when used corrected the problem.

thanks for you help, Paul