Instead, try using a regular SQL-string to get the information you want to
use.
--
MVH, Martin Johansson
CEO & Project Supervisor
SD-Studios, Squaremedia HB
+46 (0)70-3003320
http://www.sd-studios.com
http://www.swehost.com
-----Ursprungligt meddelande-----
Från: Shabbir [mailto:jamali_s@y...]
Skickat: den 12 juli 2002 17:37
Till: ASP Databases
Ämne: [asp_databases] I cant move backword thru the records
My name is shabbir and i am a learning ASP . i have a problem with my
code..
my aim of this code is i want to find a record in my recordset using find
mthod. now the problem is that it says that i cannot move to the record
in backward directiona dn it displays the following message on the browser
i would be really obliged ifyou could help me inthis regard
my code is
<% @language="vbscript" %>
</HEAD>
<BODY>
<%
dim rec_set,conn,search_var,str
set conn=server.createobject("adodb.connection")
set rec_set=server.createobject("adodb.recordset")
search_var=request.form("dir")
conn.open "dsn=shabs"
rec_set.open "movie",conn,0,1,2
str= "director='" & search_var &"'"
rec_set.find str '********the error is in this line
if rec_set.eof then
response.write "there is no record"
else
response.write rec_set("movid") & "<BR>" & rec_set("title") &rec_set
("director")
end if
rec_set.close
set rec_set=nothing
%>
</BODY>
</HTML>
thanking you
shabbir hussain
View Cart
