I am new to vbscript (asp coding), I come from a php world and am learning lots.
I need to create a table of Labesl/Radio Buttons dynamically from a db table.

The data would look like this:

RecNo fruit_text1(nvarchar) fruit_choice2(bit) fruit_text2(nvarchar) fruit_choice2(bit)
1 apple 0 orange 1
2 grapes 1 melon 0



and so on.

What I need to do is to display the table data with the TEXTx as the Label and ChoiceX as the Radio button value.

I think I should also say that the data is in pairs. By this I mean RecNo1 data is displayed in the same TR as a pair, so that when a user clicks on Apple, Orange is deselected etc.

I've tried to convert some PHP code, but am just not well versed enuff in vbscript for asp pages.

Thanks.

Weird naming. If you're only storing fruit data, why do you need to name
every column fruit_? And RecNo? There are no records in a database, only
rows. It isn't a sequential text file:-)

For your question, try this link. It's a great site that helped me a lot:
http://classicasp.aspfaq.com/general...-from-asp.html

--
..::[ Hz ]::.

"Yasmin" <yasmin@xxxxxx> wrote in message
news:u8A1aBLqJHA.5880@xxxxxx

> I am new to vbscript (asp coding), I come from a php world and am learning
> lots.
> I need to create a table of Labesl/Radio Buttons dynamically from a db
> table.
>
> The data would look like this:
>
> RecNo fruit_text1(nvarchar) fruit_choice2(bit) fruit_text2(nvarchar)
> fruit_choice2(bit)
> 1 apple 0 orange
> 1
> 2 grapes 1 melon
> 0
>
> and so on.
>
> What I need to do is to display the table data with the TEXTx as the Label
> and ChoiceX as the Radio button value.
>
> I think I should also say that the data is in pairs. By this I mean RecNo1
> data is displayed in the same TR as a pair, so that when a user clicks on
> Apple, Orange is deselected etc.
>
> I've tried to convert some PHP code, but am just not well versed enuff in
> vbscript for asp pages.
>
> Thanks.
>
>

So where are you at the moment?
Have you read the table (using adodb)?
Have you iterated through the rows?
Have you created the required markup?

What I'm really asking is which part of this are you stuck on?

--

Joe Fawcett (MVP - XML)
http://joe.fawcett.name

Found a solution.

"Yasmin" <yasmin@xxxxxx> wrote in message news:u8A1aBLqJHA.5880@xxxxxx
I am new to vbscript (asp coding), I come from a php world and am learning lots.
I need to create a table of Labesl/Radio Buttons dynamically from a db table.

The data would look like this:

RecNo fruit_text1(nvarchar) fruit_choice2(bit) fruit_text2(nvarchar) fruit_choice2(bit)
1 apple 0 orange 1
2 grapes 1 melon 0

and so on.

What I need to do is to display the table data with the TEXTx as the Label and ChoiceX as the Radio button value.

I think I should also say that the data is in pairs. By this I mean RecNo1 data is displayed in the same TR as a pair, so that when a user clicks on Apple, Orange is deselected etc.

I've tried to convert some PHP code, but am just not well versed enuff in vbscript for asp pages.

Thanks.