Search Function W/out A Database?

I would like my ASP-based site to have a search box to bring up a list of relevant pages according to user-defined search criteria.

Q: Do I need to have a d/b like SQL Server 7 at the back end to process and match the search string? Or can I do w/out a d/b somehow and run a search, and somehow still bring up the same results?

If a d/b isn't necc, pls. advise on webpages where I can find such ASP-search codes.... TQ!!

View Replies


ADVERTISEMENT

Database Search Function

I have a page that uses the data from the previous pages form to search the data in the database and dispaly any matching results.

On doing so i get this error:

Error Type:
Microsoft VBScript compilation (0x800A03F9)
Expected 'Then'
/IT/searchresults.asp, line 20, column 15
If Request.Form"(Typesearch") = "computer_name" Then

My statement has a then in the statement already.

View Replies View Related

Search Function

i am wondering how I would go about making a search page on my site???

Basically, i want a field in my SQL dbase called keywords so i can put general words in i.e. Apple, Bannana, Kiwi etc.

However, I want the page to be able to do 2 thngs:

1. If someone types "APPLE" the page will display all the records where the keyword is entered in the field

2. If someone types "Apples" and "Bannanas", the page will display all the records where the keywords is is entered in the field.

View Replies View Related

Search Function

i have a site that shows my dvd collection i have this call from the database and i want to add a search function in the same page (not the datbase) so when someone wants to search for say "Shrek" it will bring up the search results on the main page and should show "shrek 1 and shrek 2" , Also in the same light if someone searches by Actor all the films that actor has been in will appear on the main page

I have created the Form Form in Dreamweaver Code:

<form name="form1" method="post" action=""SELECT * FROM movies WHERE title = " & request("q") & ";"">
<input type="text" name="textfield">
Search
</form>

View Replies View Related

Search Function

Does anyone know of a tutorial or other source that addresses the following problem:
I have a textbox (txtSearch) and a drop down box.I want to enter text in the textbox, and then select the table column to search using the drop down box i.e.

Search for: Johnson (txtbox)

Search by: Surname (ddbox)

View Replies View Related

Search Function

I have a page where I enter a keyword and I search for that keyword in my database. I want to highlight the word that is/was searched for in the results. My results consists of values out of varchar and text fields.

View Replies View Related

Search Function

i have numerous tables to search through for a 'site search'. some of the searchble fields have html embeded within so after some quick referencing, saw I can use the regExp function to strip out all the HTML leaving only the raw text.

what is the best method to remove alot of words such as "a", "and", "I", "so", "that", "this" ...etc ... from the search string leaving only keywords essentially per page/field that will be searched within for the occurance
of the users' input text through a input field. The idea being to only return the suitable records without alot of rubbish.

View Replies View Related

Asp Search Function

I have a asp/mysql real estate site that someone else created and I don't know much about asp. If you view all the homes listed on the site you get all the listings which is now 4 pages and growing http://arizonarenttoown.com/homes.asp There is no sort or search capabilities so the list is too long and needs to searched by city.

I have some real estate websites that I created with a open source script, open -realty.org. They are php & mysql and have search pages so I can easily create a link for each city. When the link is clicked a search page displays only listings for that particular city. Code:

View Replies View Related

Search Engine Function

i want to do a search function for my project, my project is allow user to upload file into my server and sharing among each other,i need to do a search engine function to allow user to search for the file that they want, can i know there a function can search through the server's file implemented in asp?or may i know there any open source search engine function coding for me to refer?

View Replies View Related

Access Search Function

I have a neat database running and im trying to place a search engine thro it. I have quite a few tables, BUT i can only get the query in one table. ie Code:

View Replies View Related

Recursive File Search Function Bug

I've recently made a recursive sub in asp to search all folder and subfolders of the map "file" for a certain filename. It will list all results and show a link.

Now there's still a bug. I can't place files in the root because this script won't find 'em. The root i mean files.

If i replace the empty dir with Server.MapPath("") it will show the files in the root but it will show 'em twice. Code:

View Replies View Related

Advance Search Text Function

For example:
The text to be searched is the following:

Text 1:
Hello world! what a nice day today. But I like to sit in front of computer and doing some web design. Now I have encountered some technical problems and would like to get some helps from the experts.

Text 2:

I like fishing.

Text 3:
Baseball season is over.

Text 4:
The winter snow storm is coming.

Search Keyword: snow.
Search result is Text 4

Search Keyword: I
Search result is Text1 and Text2

At the end, the key word should highlighted with a different color in the paragraph.

How would I do about this?

View Replies View Related

ASP: Code Search Function For Chinese Site

Got a chinese website (has both chinese character and english), got to code search function for it, search for keywords in the webpages (htm/asp)

search in english it works, no problem
search in chinese it doesn't - it always return "nothing found"

you guys any idea?

View Replies View Related

Database Search;

I have been thinking about this wee problem for a while now, and usually I figure out what I need to do, but in this case I'm drawing a blank And the most annoying thing is that I don't think it should be that hard! I use this code to search a database: Code:

View Replies View Related

Using ASP To Search A Database

My setup is going to be like this:

I have one page that has a few categories on it. When the person clicks on one of the categories it sends the querystring to the next page. That page takes the query string, searches the database and only replies with found results. Thats what I'm trying to setup, I think I'm very close.

I know the request.querystring is being sent properly and receieved properly, because I also have it's name displayed on the next page and that works fine. I know my connection to the database is okay, becasue if I just set it to display the entire database that will display fine.

It's when I try to use the Request.QueryString that was sent to search the database - it returns like it can never find anything. The page displays, no asp or coding errors - just no information.

The database Column I'm trying to have it search is called "Classification". I think that's all the info.. if I'm missing something you need to know let me know. Code:

View Replies View Related

Database Search

Does any one know of any good asp database search scripts. What I'm looking for it to search the database on different criteria or phrases. Eg Kane 400 Boiler.

The user could put in kane 400 and it would pick it up, basically something that you don't have to put in the search how it appears in the database, I have worked on this and works fine if you put the exact phrase in, or one work but if i put in kane 400 it does not work. Also if I put % it lists the whole database, this database will hold 10000 > products so want it not to be to heavy etc.

View Replies View Related

To Search A Database

I'm trying to use information that a user enters into an HTML form to search a database. For example, if a user clicks on a check box stating their interests are 'holidays' then this information needs to be used to search the database for entries that match, ie the entry has a category that states it is about holidays.

The entries in the database are linked to pictures that will then be loaded onto a website.

View Replies View Related

ASP Database Search

I'm having a problem with a simple search. I have a telephone directory where people can search by first or last name. This works great but when someone tries to search for a name with an ' in it you get an error.

Here's my code for the database connection:Code:

sql = "SELECT Staff.[first_name], Staff.preferred_name, Staff.no_location,
Staff.[last_name], Staff.[location], Staff.business_title, Staff.department,
Staff.phone, Staff.fax, Staff.[email]
FROM Staff WHERE (((Staff.[last_name])like'%"
& Request.QueryString("[search-lastname]") & "%')) "

I'm certain it's just a syntax error so hopefully someone can spot it quick. Using a - in the name search doesn't bring the error.

View Replies View Related

Search Database With ASP

I've created a search bar on my site to search a database with job information. I dont know what i am doing wrong, i just want what the user types in to display after pressing search. I thought all i would need is Code:

View Replies View Related

All Database Fields Search

I am looking for an ASP script that let me to serach all database contents with only one textfield in search page. eg: I have a database with five columns for lessons: Mat, physics, geography, history and sport. Each field have numbers 1 thr 5. I want to search only those students have number eg:3. with entering the number in textfield in serach page. I have no problem in result page.

View Replies View Related

Access Database Search With ASP

I have built a small cms driven website using asp and access database. There is nothing special about it, it has about 5 tables each containing unique data.

I want to add a search field on all pages which will search the entire database and present the results.

I have been searching for hours now and cant find a script that suits my needs. Can anyone point me in the right direction or reccomend a script?

View Replies View Related

ASP Access Database Search

I'm having trouble figuring out how to do a freetext search in my ms access db table. Code:

View Replies View Related

Should I Use LIKE Or InSTR For A Database Search?

Which is better practice?

Code:
Select * From groups Where groupName LIKE '%bli%' AND cusType LIKE 'CUST%'
or

Code:
Select * From groups Where InStr(groupName,'li')>0 AND InStr(cusType,'CUST')=1
Right now I'm using and Access database but plan to upsize to a MSSQL if that makes any difference. Are there any advantages or disadvantages to either technique?

View Replies View Related

ASP Search W/ Access Database

I would like to get asp code for searching database.I have data in Ms Access. I want to search by catagories. A dropdown list to choose to narrowdown search. If keyword found, create a hyperlink of the location so that easy to view.

View Replies View Related

Keyword Database Search

I have been searching for a way to search a database based on keywords. All I can seem to find is google searches. All I want to search is my own database.The db contains inventory for a friends store. As list is long he would like to be able to search an item based on item name, supplier, or type.

View Replies View Related

Search On Database Tables

I want to do a searching on database some tables' content, is asp have so function or tool to do this?

View Replies View Related

Search More Than 1 Database Table At Once

Im looking for a means to allow the search criteria provided by a user to be checked against fields in more than one recordset table in a ms access database.

Is there a means within asp to check multiple tables at the same time using one set of criteria? So far the only solutions i've seen to this includes the usage of a list box which dictates which recordset is opened. I would like to avoid this.

View Replies View Related

Database Column Search

I am looking for a asp script, that will do an OR search on keywords in two differant columns in an MySQL database. for example if someone searches for joe bloggs I want to bring back all records that have either of the words joe or bloggs in column one or column two.

I have found a script that does exactly what I want but it will only search one column of a database whereas i would want it to search two columns. http://www.4guysfromrolla.com/webtech/052799-1.shtml

how to modify this code or point me in the direction of some other code that will do the same job.

View Replies View Related

Search A Word In Whole Database

I'm trying to find a Sql query to find a word in all the data of all tables of an microsoft access DataBase.

View Replies View Related

Database Function Input

So far I've been using Sets to read information from the database (Set RS = Server.CreateObject("ADODB.RecordSet") and RS.Open queryString, Conn)

I've got a situation now where I have a function which returns just a single value. I call this function using "SELECT myFunction(parameters)". I can't use a result set to retrieve the function return value, can I? How should I do it?

View Replies View Related

Database Driven Search Engine

Does anyone know where I can find a free simple script to create a search engine using Access Database backend and will allow the user to type in a word (not a using drop down list) and it will search the table.

View Replies View Related

Combobox Criteria For SQL Database Search

I have a combo box in an ASP page, there are 7 lists total in the combo box, there is another text box on the page and a search button. I want the users to select an item from the combo box and type a keyword and click search.

The combo item and keyword will be used as an criteria to query a SQL database. I'm familiar with SQL connection and running queries but how do I take the criteria and pass on further.

View Replies View Related

Search Database By Date Problem

I want a user to search for records between 2 dates.

The database is a msaccess db has a date column ( format type is date). This is filled with the date (date()) at the time of submitting.

I then have a search page this has simple drop down lists to select the two dates. The code for this is: Code:

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved