search bar problem? - ASP / Active Server Pages

hey, I have just ventured into the fun world of creating a search bar, so far i have a page which you type in a name of a band or album you like, the next page is meant to connect to the sql database and find matches that are LIKE the text entered. However I get an error instead.

ERROR code

Expand|Select|Wrap|Line Numbers

 
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
 
[Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended 
 
page/basic search.asp, line 16

here is the results page

Expand|Select|Wrap|Line Numbers

 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<%@LANGUAGE="VBSCRIPT"%>
 
<%

Dim strSQL, objConn, objRs 
 
strbasicsearch = Request.QueryString ("basicsearch")
 
strsql = "select * from band and album where basicsearch like '"& strbasicsearch & "%'"
 
Set objConn = Server.CreateObject("ADODB.Connection")

objConn.open "dsn=Oracle;uid=username;pwd=password"

Set objRs=objConn.execute(strSQL)

%>
 
<HTML>

<HEAD>

<TITLE> band Results Page</TITLE>

<HEAD>

<BODY>

<TABLE>

<TR>

<TD>band name</TD>

<TD>location </TD>

<TD>genre</TD>

<td>album</td>

</TR>
 
<%

Do While Not (objRs.EOF)

%>

<TR>

<TD><%=objRs("band_name")%></TD>

<TD><%=objRs("location")%></TD>

<TD><%=objRs("genre")%></TD>

<TD><%=objRs("album_name")%></TD>
 
</TR>
 
<%

objRs.MoveNext

Loop

objRs.Close

Set objRs=Nothing

objConn.Close

Set objConn=Nothing

%>

</TABLE>
 
</BODY>

</HTML>

I have a feeling the strsql string is incorrect but im unsure

Jan 31 '08 #1

Subscribe Post Reply

1185

CroCrew

564

Expert 512MB

Microsoft SQL Server or Oracle?

Jan 31 '08 #2

j0rdanf1

Microsoft SQL Server or Oracle?

im using oracle mate

Jan 31 '08 #3

CroCrew

564

Expert 512MB

Hello j0rdanf1,

All you need to do is change the Database Provider to point to your Oracle DSN and all should work.

In the example below the relationship between the two tables is the BandID.

Example:

Expand|Select|Wrap|Line Numbers

 
<%

    LacalBandName = replace(Request.QueryString("BandName"),"'","''")

    Set Conn = Server.CreateObject("ADODB.Connection")

        Conn.Open("dsn=xxxxx;uid=xxxxx;pwd=xxxxx;")

        SQL = "SELECT a.*, b.* FROM band a Join album b ON (a.BandID = b.BandID) where a.BandName LIKE '%" & LacalBandName & "%'"

        Set myRS=Server.CreateObject("ADODB.Recordset")

        myRS.Open SQL, Conn
 
    Response.write(myRS("FirstName").value)

    Do Until (myRS.EOF)

        Response.write(myRS("AlbumName").value)

        myRS.MoveNext

    LOOP

%>

Hope that helps~

Jan 31 '08 #4

Similar topics

Search function

by: Andy Jacobs | last post by:

Hi all I have a search function on a site of mine. At the moment, the content is delivered using this: <?php echo $row_Recordset1; ?> The search function goes through the table and...

PHP

String question: Returning portion of string with words surrounding highlighted search term?

by: Ken Fine | last post by:

I'm looking to find or create an ASP script that will take a string, examine it for a search term, and if it finds the search term in the string, return the highlighted search term along with the...

ASP / Active Server Pages

how did they do their search algorithm - help anyone with advice, I've got impossible requirements

by: vic | last post by:

My manager wants me to develop a search program, that would work like they have it at edorado.com. She made up her requirements after having compared how search works at different websites, like...

HTML / CSS

Fastest way to handle the search

by: Zambo via SQLMonster.com | last post by:

Hi! We have Sql Server 2000 in our server (NT 4). Our database have now about +350.000 rows with information of images. Table have lot of columns including information about image name, keywords,...

Microsoft SQL Server

Reverse search in a singly-linked list

by: RAJASEKHAR KONDABALA | last post by:

Hi, Does anybody know what the fastest way is to "search for a value in a singly-linked list from its tail" as oposed to its head? I am talking about a non-circular singly-linked list, i.e.,...

C / C++

Search for multiple things in a string

by: tshad | last post by:

Can you do a search for more that one string in another string? Something like: someString.IndexOf("something1","something2","something3",0) or would you have to do something like: if...

C# / C Sharp

MySQL 5.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

by: jrs_14618 | last post by:

Hello All, This post is essentially a reply a previous post/thread here on this mailing.database.myodbc group titled: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode I was...

PHP

At last something interesing to discuss: What is the fastest way to search a client-side database?

by: Harry Haller | last post by:

What is the fastest way to search a client-side database? I have about 60-65 kb of data downloaded to the client which is present in 3 dynamically created list boxes. The boxes are filled from 3...

Javascript

Search for single, and multiple keywords (NO ACCESS PROBLEM!!)

by: Richard S | last post by:

CODE: ASP.NET with C# DATABASE: ACCES alright, im having a problem, probably a small thing, but i cant figure out, nor find it in any other post, or on the internet realy (probably cuz i wouldnt...

.NET Framework

Spotlight Search Question

by: MrWelfare | last post by:

Hi Everyone, I'm currently trying to follow an example I found in a book a while ago to try to create a spotlight (mac-like) search that filters results as one types. The script that I have works...

Javascript

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice