DW dynamic form problem (Full Version)

All Forums >> [Web Development] >> General Web Development



Message


socks -> DW dynamic form problem (9/1/2009 19:47:16)

Not sure if this is the right forum, but here goes:

I'm trying to create database-driven search and result pages in Dreamweaver using ASP and Access. The search page consists of a single dropdown menu of employee names. When submitted, the user goes to a results page that displays the selected employee info. All info is in the same db table. Should be simple. But for some reason I'm unable to pass form parameters from search page to result page. Have tried everything I can think of. Other dynamic site forms work fine (input, update pages) but they use URL parameters.

This is the first time I've done this. Suggestions much appreciated.




ou812 -> RE: DW dynamic form problem (9/2/2009 0:07:36)

Can you post what you have? Different ways you could be doing this and hard to say how to fix without seeing.




socks -> RE: DW dynamic form problem (9/2/2009 7:40:43)

Thanks for the reply. I'm building the pages with the DW application panel, not writing code directly. The resulting code is below. (This is a test run, not the final product.) Also, if it makes any difference, I'm running this locally on IIS:

SEARCH PAGE:
<form action="results.asp" method="post" name="form1" id="form1">
<select name="select" id="select">
<%
While (NOT Recordset1.EOF)
%><option value="<%=(Recordset1.Fields.Item("MemberID").Value)%>"><%=(Recordset1.Fields.Item("FirstName").Value)%></option>
<%
Recordset1.MoveNext()
Wend
If (Recordset1.CursorType > 0) Then
Recordset1.MoveFirst
Else
Recordset1.Requery
End If
%>
</select>
<input type="submit" name="Submit" id="button" value="Submit" />
</form>


RESULTS PAGE:
<p><%= Request.Form("MemberID") %></p>


<table border="1" cellpadding="2">
<tr>
<td>MemberID</td>
<td>FirstName</td>
<td>LastName</td>
</tr>
<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %>
<tr>
<td><%=(Recordset1.Fields.Item("MemberID").Value)%></td>
<td><%=(Recordset1.Fields.Item("FirstName").Value)%></td>
<td><%=(Recordset1.Fields.Item("LastName").Value)%></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</table>




socks -> RE: DW dynamic form problem (9/2/2009 9:51:48)

OK, I figured it out. As usual the solution is embarrassingly simple. I had neglected to add the form element name on the search page to the recordset filter on the results page. Dumb.

Thanks to all.




ou812 -> RE: DW dynamic form problem (9/2/2009 12:07:27)

Glad I could help [:D]




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625