Why cant I request id and lasttime in my programme

&lasttime=<%=lasttime%>&condition=<%=condition%>">


<%if buildingid <> "" and buildingid <> " " then%>



<%else
'response.write id%>





<%
if mode="Next" then
temp = trim(request("temp"))
id = trim(request("id"))
lasttime = trim(request("lasttime"))
response.write temp
response.write id
response.write lastime
order_value=0
set cn = server.createobject("adodb.connection")
set rs = server.createobject("adodb.recordset")
set rs_pre_next = server.createobject("adodb.recordset")
cn.open "driver={microsoft access driver (*.mdb)}; dbq=d:
nidhgc
ocbo
ocbo
ew1cost.mdb"
rs_pre_next.open "select * from [Temp] where [BuildingID] = '"&temp&"' ",cn,1,1,1

Present= rs_pre_next("Priority").value
'response.write Present
rs_pre_next.close
Next_Priority = Present + 1
'response.write Next_Priority
rs_pre_next.open "Select BuildingID from [temp] where [Priority]="&Next_Priority&"",cn,1,1,1
'response.write rs_pre_next("BuildingID").value
m=rs_pre_next("BuildingID").value
show="m"
mode=""
response.redirect "searching.asp"
rs_pre_next.close
end if
%>
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories