Added: July/02/2004 at 9:49am | IP Logged

Hello Hypa,

Yes, when the form is populated by the db table, tbl_peernominees, we will have a list of peer names with a radio button to the left of each name. To the far right of each name is the 'reason' this person was nominated. So, you have:

(0) < radio button :: Peer Name ::  Reason peer was nominated
(0) < radio button :: Peer Name ::  Reason this peer was nominated
(0) < radio button :: Peer Name ::  Reason this one was nominated......

[submit button]

So, one votes for a peer by clicking the radio button next to their name and then clicking the submit button. This is a vote - and this vote will populate a new table, tbl_peervotes. Problem is, I can capture that peer name in the table, but not the 'reason' for the peer voted for. I capture every bloody 'reason' for every peer nominated separated by commas. So when you look at the db table for peers voted for, you get this::

id         &nbs p;     date         &n bsp;          peer         &n bsp;         &n bsp;      reason
------------------------------------------------------------ ------------------------------
1           ;    07/01/04        &nbs p;  Joe Maze         &n bsp;      reason for Joe Maze, reason for Chris Blue, reason for Suzy Que, reason for Jay Mack, reason for Quicy Jones, reason for Bobby Post.........

I'm trying to figure out how I can caputure the one 'reason' that goes with the peer nominated which is fed from the tbl_peernominees table.

Thanks for your efforts,

Chris 

Added: July/02/2004 at 7:13pm | IP Logged

Ok here is my first thought without going to deeply into the logic. In order for you to pass the information along you need to send it with the value of the radio button selected.

In this section (yours)

<input type = "radio" name="fullname" value="<%= RS("firstname") &" "& RS("lastname") %>">

Change it to something like this. (Mine)

<input type = "radio" name="fullname" value="<%= RS("firstname") &" "& RS("lastname") & "|" & RS("REASON") %>">

Im example you would add string manipulation to find the "|" (more) symbol and cut that section off then you would have your reason string.  then take the | off and the remaining part of the string is your name.  There are many other ways I'm sure to do this but I think I would give this a shot.  Let me know if this makes any sense.  Another thought would be to implement a counter and concatinate the number with the name of reason and match it with the index number of the radio item... Ok I hope this helps.

Added: July/06/2004 at 9:01am | IP Logged

Hypa,

Just wanted to get back to you before too many days pass. I just got back to work and I will give this a try.
Thanks for your advise and imparting some of your knowledge.

Chris