Hi guys
I am new to ASP (traditional ASP not the .NET). I want to design a Form based on the user table something like this tUser(UniqueName, F_NAme, L_Name, MI)
When the page loads the user will see a combobox/list to pick the name from that table and after picking the name then should see on the same form the name of all the users in the tUSer table except the one who was selected in the combobox and names should be shown in the check boxes.
Thanks & Regards
Azimi

Hello,

  After selecting the table name in the combo box, submit the form to
same page. Then check the condition like...

<%
  if request.servervariables("HTTP_METHOD")="POST" 'or GET
    ...
   'retrieve all the data from the table

  end if
%>

If this is not your requirements, let me know


---------
Rajani

Mazimi,

You have the bombo box as a reply to your other post?
http://p2p.wrox.com/topic.asp?TOPIC_ID=20029

To create this list all you need is an onChange event in the <select> tag. When a user makes a selection from the combo box it runs the onChange event, submits it's self then reloads the page creating the list.

1..Change your select tag to include:
<select name="userList" onChange="Javascript:updateForm.submit();">

2..Now put a condition up top somewhere, has the form been submited? if so it will run otherwise be ingorned
<%
   Dim showlist
   showList = false
   if request.form("userList") <> "" then
      'get all records where not = combo box selection
      sql = "SELECT id, UniqueName, F_NAme, L_Name, MI FROM tUser WHERE id <> " & request.form("userList") & ";"
      set getInfo = conn.execute(sql)
      'create show list variable
      showList = true
   end if

3..Now where ever in the body of your page you want to see the list; you say:
;;;names should be shown in the check boxes
I dont understand this part. I only know of one type of checkbox, you cant put a names in them.
Q..Do you want check boxes adjacent to each name?

Anyhow, to show your list

<% if not getInfo.EoF then
        response.write "<table>"
        do until getInfo.EoF
           response.write "<tR><td>" & getInfo(2) & "</td><td>&nbsp;</td><td>" & getInfo(3) & "</td></tr>"
           getInfo.moveNext
        loop
        response.write "</table>"
     else
        'do nothing
     end if
%>

this will give you a list in a table each row being' F_NAme' space 'L_Name'. If you want a checkbox adjacent to each name, throw a checkbox tag in the loop just before getInfo(2)






Wind is your friend
Matt

quick correction to the above post:

change this:
<% if not getInfo.EoF then
        response.write "<table>"
        do until getInfo.EoF
           response.write "<tR><td>" & getInfo(2) & "</td><td>&nbsp;</td><td>" & getInfo(3) & "</td></tr>"
           getInfo.moveNext
        loop
        response.write "</table>"
     else
        'do nothing
     end if
%>

To this:

<% if showList = true then
     if not getInfo.EoF then
        response.write "<table>"
        do until getInfo.EoF
           response.write "<tR><td>" & getInfo(2) & "</td><td>&nbsp;</td><td>" & getInfo(3) & "</td></tr>"
           getInfo.moveNext
        loop
        response.write "</table>"
     else
        'do nothing
     end if
  end if
%>



Wind is your friend
Matt

Thanks a lot for your help.
Regards & Thanks
:)
Azimi