|
| |
|
|
socks
Posts: 20
Joined: 3/7/2002
From:
Status: offline
 |
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
Posts: 1705
Joined: 1/5/2002
From: San Diego
Status: offline
|
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.
_____________________________
-brian
Black Holes suck.
EnterpriseDB: Enterprise-class relational database management system
PostgreSQL: The world's most advanced open source database
| |
|
|
|
socks
Posts: 20
Joined: 3/7/2002
From:
Status: offline
|
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
Posts: 20
Joined: 3/7/2002
From:
Status: offline
|
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.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
