Database driven Dynamic radio buttons :URGENT

srichary · October 28th, 2004, 08:41 AM

I am trying to make the radio button checked as the value is true
i am using the following code

<input name="occupation" type="radio" value="housewife" <%if occupation=rs("occupation") then response.write "checked" end if%>>

BUt actually the radio button is not getting selected even if the value from the database is true.I am using ASP and SQL7.0

bmains · October 29th, 2004, 02:32 PM

What type is occupation, and I am guessing you are using a bit?

<input name="occupation" type="radio" value="housewife"
<%
if (occupation = cbool(rs("occupation"))) then
Response.Write(" checked")
end if
%>
>

Brian

happygv · October 30th, 2004, 01:48 AM

srichary,

It would be better, if you could also post what the datatype that you use as OCCUPATION in the db, and may be post some sample data to be clear on that, before suggesting.

Cheers!

_________________________
- Vijay G
Strive for Perfection

srichary · October 30th, 2004, 02:43 AM

Hi,
I am using varchar(25) datatype for occupation.

thanks brian for the code.I tried ur code but gave me

type mismatch:'cbool'

cant get this right

Please somebod HElp

happygv · October 30th, 2004, 02:48 AM

I doubt if you store any value into "occupation" variable that is involved in the IF condition there.

Code:

Response.write "Occupation=" & occupation & "<br>"
Response.write "Recordset Occupation=" & rs("occupation")& <br>
Response.end

Try this code just above that radio button code and post the output here. Let see what comes in both the variable and Recordset.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

srichary · October 30th, 2004, 04:09 AM

This was the output based on the code By Vijay G

Occupation=
Recordset Occupation=service

My ACtual form code is

<input name="occupation" type="radio" value="service" <%if occupation=rs("occupation") then response.write "checked" end if%>>
    Service
      <input name="occupation" type="radio" value="retired" <%if (occupation=trim(rs("occupation"))) then response.write "checked" end if%>>
    Retired
    <input name="occupation" type="radio" value="housewife" <%if (occupation=trim(rs("occupation"))) then response.write "checked" end if%>>
    House wife

bmains · November 1st, 2004, 08:46 AM

Hey, Try:

<% if lower(occupation) = lower(rs("occupation")) then

Brian

srichary · November 1st, 2004, 09:18 AM

Hey brian ,
I tried your code but its giving me this error:

Type mismatch: 'lower'

thanks

happygv · November 1st, 2004, 02:23 PM

That should have been LCase(), instead of LOWER, in VBScript.

But as I doubted, Srichary, doesn't seem to assign any value to the OCCUPATION variable. So that doesn't always match with the rs("Occupation")'s value. I believe on top of this page, somwhere it should be written as

Code:

occupation = Request.Form("Occupation")

which seems to be missing. Can you confirm if and where you assign the value of OCCUPATION that is used on the left-hand-side in the IF statement?

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

srichary · November 2nd, 2004, 03:52 AM

THanks Vijay ,
   THis code worked really well .Its as if a dating virgin women and u are happy at the 10th day.Anyways thanks....

  I have a new problem catching the variables generated for the simple purchase list.
  Actualy i have a form with a check box(for selcting the product)
then i have a listbox containg language list for that produt and then a textbox for entering the quantity.
  All these are generated dynamically and are coming from database

My problem is during submit i cannot access the correct checkbox values and the corresponding listbox values.
  CAn you tell me the logic and the problem
thanks