Advertisement

02.05.2008 at 11:13AM PST, ID: 23139029
[x]
Attachment Details

Open Recordset in a Recordset

Asked by IntercareSupport in Active Server Pages (ASP)

Tags: ASP 3.0, Internet Explorer

hello ee,

My problem is i have an update form that shoots the records informatiion to the form and makes it editable. Everything works fine now. On my add form i have dropboxes available. How can i make those dropdown boxes available on my update form even though i have a recordset open to fill in the update form?

example
<!-- #include file="../header.asp" -->
<!-- #include file="../connect.asp" -->
Recordset.Open strSQL, Connection
strSQL = "Select Last_Name, First_Name, Location, Description, Other from Main Where ID = '" & varID & "';"
strSQL = strSQL & "Select Location from Location;"
<form>
<input type=text name="lname" size='20' maxlength='20' value='<%=Trim(Server.HTMLEncode(Recordset("Patient_LName")))%>'/>
<input type=text name="fname" size='20' maxlength='20' value='<%=Trim(Server.HTMLEncode(Recordset("Patient_LName")))%>'/>
set Recordset = Recordset.NextRecordset
<select name='location' ID="Select3">
 Do While not Recordset.EOF
  Response.Write("<option>" & Recordset("Location") & "</option>")
  Recordset.MoveNext
 Loop
</select>
<input type=text name="description" size='20' maxlength='20' value='<%=Trim(Server.HTMLEncode(Recordset("Description")))%>'/>
<input type=text name="other" size='20' maxlength='20' value='<%=Trim(Server.HTMLEncode(Recordset("Other")))%>'/>
<form>
<!-- #include file="../disconnect.asp" -->
<!-- #include file="../footer.asp" -->

Then spit out something like this

<D>
<A>
<B>
<C>
<D>Start Free Trial
[+][-]02.06.2008 at 03:07AM PST, ID: 20830980

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Active Server Pages (ASP)
Tags: ASP 3.0, Internet Explorer
Sign Up Now!
Solution Provided By: ellandrd
Participating Experts: 1
Solution Grade: A
 
 
[+][-]02.06.2008 at 06:18AM PST, ID: 20832050

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.06.2008 at 06:47AM PST, ID: 20832298

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628