problem with ASP search code

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

problem with ASP search code

Logged in as: Guest

arrSession:exec spGetSession 2,3,715

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> problem with ASP search code
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

problem with ASP search code - 10/31/2002 12:37:35 AM

rkh

Posts: 5
Score: 0
Joined: 10/29/2002
From: Jordan
Status: offline

I have problem when i try to search the
database in ASP page

the error line 30
Error Type:
(0x80040E14)

this is the code

Dim ConnectionString
Dim rs
Dim SQL
Dim Conn
'get the variable from queystring
typedname = Request.QueryString("thebox")

set Conn=Server.CreateObject("ADODB.Connection")
set rs = server.createObject("ADODB.Recordset")
Conn.ConnectionString="provider=SQLOLEDB.1;persist security info=false;User ID=Rkh;password=kh;initial catalog=new;Data Source=RKH "

Conn.open
SQL="select * from member where name= '"& typedname & "';"

'creat record set

set rs = Conn.execute(SQL) 'the error here
response.write rs(subject)
rs.open SQL,Conn
Do while not rs.EOF
loop

set rs = nothing
rs.close
Conn.lose
set Conn = nothing

rkh