Thanks for the quick reply Bruce, your advice is really appreciated!
I'm trying to learn as much as possible about ASP, VBScript and getting and posting info from a DB,
so I really need some help and advice on doing thing the "Hard Way" so I can take pleasure in knowing that if I'm ever in a similar situation, I can just read from the DB from the start.
I tried your idea and when I went back to the DB, I noticed that Private, Male and Female had been
put in again. Weird, eh? So now I have 5 records in there, (Male, Female, Private, Male, Female)
I'll have to take a look at that and make sire that no redundancies occur again, LoL!!
Any advice as to how to GET the info from the MS Access DB for several dropdown menus on the same form? Here's the code for what DOES work right now for ONE dropdown box, but like I said, when I try to get the info for more than one, my browser goes haywire, LoL~!
__________________________________________________________________________
<%
' Connection object
Dim adoConn
' Recordset object
Dim rsGender
' SQL String
Dim strSQLGender
' Create the Connection object
Set adoConn = Server.CreateObject("ADODB.Connection")
' Open the Connection
adoConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("mydatabase-Name_taken_out.mdb")
' Creates the recordset object
Set rsGender = Server.CreateObject("ADODB.Recordset")
' SQL String for query
strSQLGender = "SELECT tblGender.fldGenderID, tblGender.fldGender FROM tblGender;"
' I execute the SQL the statement that I want
' The query should return all the data I'll need in my combo box(s)
rsGender.Open strSQLGender, adoConn
%> <html>
<head>
<title>Add Member Info</title>
</head>
<body>
<!-- Begin form code -->
<form name="form" method="post" action="addmember.asp">
<table width="500" border="1" align="center">
<tr>
<td colspan="2"><div align="center">MEMBER'S PERSONAL INFO</div></td>
</tr>
<tr>
<td width="250">First Name:</td>
<td width="250">Last Name:</td>
</tr>
<tr>
<td width="250"><input type="text" name="txtFname" id="txtFname"></td>
<td width="250"><input type="text" name="txtLname" id="txtLname"></td>
</tr>
<tr>
<td width="250">D.O.B.:</td>
<td width="250">Gender:</td>
</tr>
<tr>
<td width="250"><input type="text" name="txtDOB" id="txtDOB"></td>
<td width="250">
<%
' This code seems to work the way it's set up between the <td></td> tags
though you obviously won't see it without the DB, but it does populate
properly
%>
<SELECT NAME = "GENDER" id = "GENDER">
<%
' While I don't get the end of DB
Do While Not rsGender.EOF
'Put the ID at Value
' Value is important to linked tables
%>
<OPTION VALUE="<%=rsGender("fldGenderID")%>"> <%=rsGender("fldGender")%></OPTION>
<%
' Move to the next record...
rsGender.MoveNext
' Keep the loop
Loop
%>
</SELECT>
</td> </tr>
<tr>
<td width="250">Address:</td>
<td width="250">City:</td>
</tr>
<tr>
<td width="250"><input type="text" name="txtAddress" id="txtAddress"></td>
<td width="250"><input type="text" name="txtCity" id="txtCity"></td>
</tr>
<tr>
<td width="250">Prov:</td>
<td width="250">Postal Code:</td>
</tr>
<tr>
<td><input type="text" name="txtProv" id="txtProv"></td>
<td><input type="text" name="txtPcode" id="txtPcode"></td>
</tr>
<tr>
<td>Phone:</td>
<td>Email:</td>
</tr>
<tr>
<td width="250"><input type="text" name="txtPnum" id="txtPnum"></td>
<td width="250"><input type="text" name="txtEmail" id="txtEmail"></td>
</tr>
<tr>
<td colspan="2"><div align="center">STAT INFO</div></td>
</tr>
<tr>
<td width="250">1st Martial Art:</td>
<td width="250">2nd Martial Art</td>
</tr>
<tr>
<td width="250"><select name="select" id="select">
</select></td>
<td width="250"><select name="select2" id="select2">
Topic Options
Post Options
Thanks(0)
