|
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?
------------- If anything takes long to do its worth doing.
|