Hello,
Ive assigned a value to a link
<form action="next.asp" method="post">
<a href="next.asp" value="one" Name="Holiday">Click here</a>
</form>
And on the "Next.asp" page...
<!--#include file="Top.asp" -->
<%
objFlorida = Request.Form("Holiday")
%>
<%
Dim Conn, dbPath
dbPath = Server.MapPath("/Database/photolibary.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA SOURCE=" & dbPath
Set UserRecordset = Server.CreateObject("ADODB.Recordset")
sqlstring = "select * from Photo where SubCat = '" & objFlorida & "'"
UserRecordset.Open sqlstring, conn
Set objid = UserRecordset("ID")
set objLargeImage = UserRecordset("LargeImage")
Set objSmallImage = UserRecordSet("SmallImage")
While NOT UserRecordset.EOF
%>
<TABLE>
<%
Response.write "<tr><td><img src='Florida/" & objsmallImage & "'></td>"
UserRecordset.MoveNext
Response.write "<td><img src='Florida/" & objsmallImage & "'></td>"
UserRecordset.MoveNext
Response.write "<td><img src='Florida/" & objsmallImage & "'></td>"
UserRecordset.MoveNext
Response.write "<td><img src='Florida/" & objsmallImage & "'></td>"
UserRecordset.MoveNext
Response.write "<td><img src='Florida/" & objsmallImage & "'></td>"
UserRecordset.MoveNext
Response.write "<td><img src='Florida/" & objsmallImage & "'></td></tr>"
UserRecordset.MoveNext
wend
%>
</TABLE>
<%
conn.close
%>
<!--#include file="bottom.asp" -->
So the out come is nothing, i dont get any errors and i dont get images i told it to pull out if value ="florida"
any ideas?