if I can search a access db. I have a cm system where all data for pages are held in db field updateable by the user but I want to search the page_text field of the db so that I can offer a site search on my site. I have done it with SQL db but I not done with access?
View RepliesI have a simple intranet for the company I work for and I am attempting to create a phone listing and search tool for it. The list has a simple 500 record access db.
Presently I have a page which displays the entire db. What I'd like to do is have a form at the top of the page that lists the entire db where a person could type in any word... Name, office location etc and have the result ported out on a new page with only items matching the search criteria. Code:
I've had a look and found a few items on searching a database but I need something a bit more complicated.
I want to store documents in a database, I also want to have a web page view and pdf download of the documents available (easy enough if I just embed the URL of the locations). The problem is I want to also be able to provide a search page that allows the user to search the documents and the database (for authors, date etc) using the same page.
So the question is what's the best way to start with the database and pdf docs and end up with a web view and search engine for it. The database is Access btw.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
I have some variables that consist of small paragraphs and or short sentences. How can I to see if a specific word is used in the text of that var.
View Replies View Relatedi want to perform search operations using ASP.
this is a word search i.e. every word entered as search keyword
should be searched in the database...
since it is a word search, i tried to split the string entered as search keyword,
and then search for each splitted word in the database.
It worked for only a few records present in the database. some 1034 records were searched out of 1914 i tried the same procedure in PHP and that worked.
I'm having some problems using like to find items in my database for some reason its not finding anything if it has a space in it. Here is my SQL query:
SELECT * FROM Employees WHERE FirstName LIKE '%Dennis Smith%' OR LastName LIKE '%Dennis Smith%'
In this query i'm searching two fields for any occurance of Dennis Smith whom i know is in the database however no results are returned. Also if i just search one field and the search string has a space in it, no results are returned.
currenlty we are changing our user email ids- about 2000.I have an excel file with thier new and old email ids.
Is it possible to make a .asp form file and put in an IIS server.
where user enter their current id- and the asp returns the new email id.
I'm trying to design a simple website with 2 dynamic searching functions. The first is the user enters text into a search box, clicks on the search button and then connects to a sql or access database and brings back those records that are LIKE the search phrase. It's my intention to then have a detailsview link on the searches so the user can drill through.I'm designing an online version of my catalog so that the user can browse by page. I also want the user to enter a page number and then click go and that would then take the user to the corresponding page in the catalog. I'm guessing I'll need to declare If 1 then open page1.html, if 2 then open page2.html.
I know I'm close but not close enough and my knowledge has been well and truly stretched and I must have read and read my Dummies book about 20 times over the last week.
I have a single column that outputs a comma seperated list of values (black, white, red)
I created an arrary to output the values
Dim colorTypes, arrTypes
arrTypes = split(objRS("types"), " ")
riceTypes = REPLACE(objRS("Types"), ", ", "<Li>")
response.Write "<Li>" & colorTypes
This works fine. Now, I need to compare a queryString to arrTypes and bold the match before outputting it.
Just wondering the best way of doing this? are there any dictionary databases laying around somewhere?
I want to change my search so that it corrects typo's and maybe suggests better words to search with... like googles but with more alternative words to make the search more useful - slightly limited so it doesn't become pages and pages of search terms.
What I don't want to do is sit down in front of my computer and type all of this in, going through related words and possible other searches / best searches from the given input.
I need help in retreiving data from database. my form consists of some checkboxes,
for eg:- in my form for location three check boxes are there and for the type of house four checkboxes.(houses,apartments,offices etc).Below is my form,
London (north of river)
(checkbox here)Central London
(checkbox here) Docklands
(checkbox here)Ealing, Chiswick & Acton
Number of Bedrooms(text box here)
(checkbox here)Houses
(checkbox here)Apartments
(checkbox here)Developments & Land
(checkbox here)Commercial
My databse consists of all this information. If the user want 2 bedroom flat or apartment in central london he will check central london, 2 bedrooms, house and apartment. for this i need an sql query to retrieve from database the appropriate property they are finding.
A client uploads a document (a msword .doc file) to the server,
I need to search a string that document and find specific words in it
(this is an Application to a School, most of them look the same, so all you can do is replace the school name in the application, but sometimes people forget to do so and get rejected for sending inappropriate application).
So I need to find in each Application possible names of other schools and alert about it.
I'm writing in ASP (I can use ASP.net as well)
I DON'T HAVE ACCESS TO THE SERVER (it belongs to the hosting company, and there's no way of installing anything there)
I have a database which has a field called "title". I have made a text input box and set that user submitted text to a variable (call it textvar). How do I say something like this...?
Set rs = conn.execute("Select * from workitem where title contains '" &textvar& "' " )
Of course the word contains is just a guess on my part.. other ideas are "is like". What function/syntax will give me what I want, which is for it to return any title that has the words entered by the user?
I want to search for UserID in 3 table. Searched UserID wil be present in one of any 3 table. Using select * from <table> where UserID = < =userid> allows me to search in only 1 table.
Is there any way .. to join 3 tables and search for the UserID using single SQL Query
I have a code that compares the value in the textfeild of a form with the value in the database table
do until rsData.EOF
if trim(rsData("core_contact_fname"))=trim(request.form("txtNumber1")) then%>
i would like to do two things to it one is to compare the two values while ignoring their cases(ignore case) i am not sure how to use the ignore case function.
I also want it to comapre if i want to search for say"L" I should get all the names starting with L from the database.
Has anyone had dealings with setting up website postcode searches such as one that would let a visitor input their postcode and specify a 'within the range of' value such as 20 miles and then be returned a result.
I have an asp page that allows visitors to input their postcode into a field which then refers to an Access tbl and displays the results, but only if there is an exact or LIKE match within the db.
I want to offer the facility of letting them increase the radius if they are unable to find a result matching the exact postcode. Code:
I know how to use the LIKE command in a query but how do I do it in the
results of a recordset results="<b>Hello</b> World"
I want to search the above result and if it has a <B> in it, I want set
hasabold="Y"
I need to be able to search through a large amount of text so the BOLD marks
will not always be at the front of the results. They maybe be on line 50
character 59,
provide me a full asp code for searching a string e.g name wise details of students from a database when a name is entered.
View Replies View RelatedI want to search some records in ms-access db using asp. The problem is with the sql query.The scenario is I want to search all records where name starts with a or b.
the sql query I m using is as.Code:
select * from members where m_name like 'a*' or m_name like 'a*'
however on execution, it displays an error. what should I do??
I have a website running asp (about to move to asp.net soon though) which has a list of DVD's I have the various pages I want, last 10, listing, full listing ect, but the one page i can't figure out is a search page. I have read various books, but none have given any tips on how to make a search page for a access DB.
View Replies View Relatedmy problem is searching. i want to search words within webpage which is stored in one directory.it is different from normal directory searching beacause i am searching inside the webpage.
so i want to omit all that html tags or other asp codes. also i want to know that is there any way to store webpage inside the database. it will be efficient than storing inside the directory.
We have a need to search through an entire drive for a specific file name. The process is currently written with recursive loops through each directory and the Scripting.FileSystemObject.
Problem is, it takes forever. When I do a standard file search through Windows Explorer, it typically finds the file I'm looking for within 5 seconds. Is there another approach to file searching, or am I stuck with trying to make this recursive loop somehow more efficient?
I have created a page which receives a query string from an SMS text message. The query string 'Body' could look something like this:
123456703061977C123456789sub901sub123sell901buy903 budget
what i need to do is split it up. I know the first 7 numbers are needed, in this case '1234567'
Second i need the following 8 digits:
03061977
WIth the rest of the text i need to scan and see if certain keywords are in there. This case i need to see if C is in there, and if it is then i need to identify the 9 digits after that letter. If sub is in there, then i need to find out the following 3 numbers, and if sell is in there i need to grab the following 3 numbers, plus what 3 numbers follow the corresponding sell.
Is there a way in ASP to enter a link and if the link works, it will search the page for a keyword. If the keyword is found, it displays a result.
For Example:
Keyword: Dog
Page: URL
I need something to go to URL page, grab the html, search it, and tell me if "Dog" is on the page or not.
In a search form how does one stop the form from running when a certain character is entered.
Such as "%" also even if i add 5 of the characters. I have been to a few sites and this goes and gets all the records.
I have to modify an ASP page that pulls data from an Excel spreadsheed and posts it on the web by adding a search/filter option to it. I'll post what I have so far: Code:
View Replies View RelatedI have use sql string to search a table of data,the detail of the data can be viewed by click into the data .How should I do if I do if I want to add a "next button" so that I can go from one detail of the data to another detail of another data without back to the table of data???
View Replies View Relatedas with searching through a mdb table, is it possible to search a query in access?something like...
select * from 'access query' where
I'm trying to figure out how to create a search engine using ASP. Now I know how to create one that looks for say, firstnames. So the user would type in a name ("Jonathan") and the search engine would return the word Jonathan, from an Access database, if there was a matching record.
This time, I want to have a text box in a form, so when the users type in something like "Highlander" or "Star Wars" - then it generates a table, or list of some sort of all images related to the two movies, then the user can click on each image to enlarge. (A bit like Google images I suppose, but a watered down version). Is this viable with ASP?
How can I use these search scripts to search in folders ? Now the search is only going through the folder where the script itself is. Code:
View Replies View RelatedI'm not sure if this is an ASP or SQL question (I'm new to both) Does anyone know how I would query results between two dates (a start date and an end date). Here's a slice of code that I'm using to search by city:
if (request.form("city") <> "") then
where_clause = where_clause + " AND (race.city LIKE '%" & replace(request.form("city"), "'", "''") & "%')"
end if
In my database I have a start_date field and end_date field Also any tips on something that will automatically enter a date in a form using a popup up calendar? Similiar to an example on this page: Code:
I have a msSql database already set up on my server. And the way my site performs a search is that the formaction equals "mypage.asp?subjectID=1". Now the "subjectID=1" is related to the type of subject the user wants to search on.
Instead of having the action of the form go to this destination, I want to make a drop down list that serves as the subject choices such as "subjectID=1", "subjectID=2", ...and so on. So that when the user selects "subjectID=1" it will go to the search results page and display only the items that contain the value of 1 in the database under the field subject when he/she clicks the search button. Code: