I have problem in ASP search code

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

I have problem in ASP search code

Logged in as: Guest

arrSession:exec spGetSession 2,2,713

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

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> I have problem in 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 >>

I have problem in ASP search code - 10/29/2002 3:41:07 AM

rkh

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

here is the code

this is namesearch.html

this is name_search.asp
<%Dim ConnectionString
Dim ADO

ConnectionString="provider=SQLOLEDB.1;persist security info=false;User ID=Rkhatib;password=khero;initial catalog=new;Data Source=RKHATIB "

Set ADO=Server.CreateObject("ADODB.Connection")
ADO.ConnectionString =ConnectionString
ADO.Open
%>
<%
keyword=request.querystring("keyword")

SelectSQL="select * from tech_news where subject like '%"&keyword&"%'� "

Set rs=ADO.execute(SelectSQL) 'line 26

ADO.close

%>

the error is Error Type:
(0x80040E14)
/myweb/name_search.asp, line 26

rkh