Thanks for the reply.....I realize this is crappy dreamweaver code but it's the only way I know how to do this stuff sorry.....
Landname is the dropdown field I have and I select one of those and then click submit to get the detail for that Landname. I need to send over the ID that's in the same table for that selection in the URL Parameter on the detail page.
Thanks
Code:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/Landmarks.asp" -->
<%
Dim RSLandmarks
Dim RSLandmarks_cmd
Dim RSLandmarks_numRows
Set RSLandmarks_cmd = Server.CreateObject ("ADODB.Command")
RSLandmarks_cmd.ActiveConnection = MM_Landmarks_STRING
RSLandmarks_cmd.CommandText = "SELECT * FROM dbo.tblLandmark ORDER BY LandName ASC"
RSLandmarks_cmd.Prepared = true
Set RSLandmarks = RSLandmarks_cmd.Execute
RSLandmarks_numRows = 0
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
body,td,th {
color: #0FF;
}
body {
background-color: #000;
}
.Fonts {
font-family: Trebuchet MS, Arial, Helvetica, sans-serif;
}
.Fonts2 {
color: #FFF;
}
</style>
</head>
<body class="Fonts">
<h2>Landmark Search
</h2>
<p class="Fonts2">Landmark Name:</p>
<form id="form1" name="form1" method="get" action="LandmarkInfo.asp">
<p>
<label for="Landname"></label>
<select name="Landname" id="Landname">
<option value=""></option>
<%
While (NOT RSLandmarks.EOF)
%>
<option value="<%=(RSLandmarks.Fields.Item("LandName").Value)%>"><%=(RSLandmarks.Fields.Item("LandName").Value)%></option>
<%
RSLandmarks.MoveNext()
Wend
If (RSLandmarks.CursorType > 0) Then
RSLandmarks.MoveFirst
Else
RSLandmarks.Requery
End If
%>
</select>
</p>
<p>
<input type="submit" />
<input type="reset" name="Reset" id="Reset" value="Reset" />
</p>
</form>
</body>
</html>
<%
RSLandmarks.Close()
Set RSLandmarks = Nothing
%>