Search Results Looking In More Than One Field
I am having trouble getting my scripting to look in more than one database field when presenting results from one form field.
I can get it to work when there is more than one form field but I am trying to get the system to look in both a description field and keyword field then present the results.
The problem area is: Code:
formFields = Array("name", "shop", "suburb", "city")
dbFields = Array("shoptitle", "shopdesc", "shopsuburb", "shopcity")
The formfields and dbfields relate to each other. What is want is 'shop' to look not only in shopdesc but also in shopkeywords I have tried commas with out quotes, semicolons etc etc Code:
View Replies
ADVERTISEMENT
I have an access database search engine. I am trying to make it resort by clicking on one of the results.
This search engine looks through CDs and returns Title, Artist, Description, Disk Number, Track Number and Price. I would like to be able to click on the disk number and show what all is on that disk. Code:
View Replies
View Related
anyone have any tips on creating a search results filter to provide the best
matches first? we're using an access database as part of a very small custom
CMS, and we need to site search function that doesnt just output any base
matches for a given term.
View Replies
View Related
I have a mdb file with the fields Country, Name, Date. The data when filled out would like like this
Australia - John - 21/7/02
Australia - Bill - 22/7/02
Australia - wendy - 23/7/02
Usa - Geoff - 23/7/02
Usa - Bill - 23/8/02
What i need to do is a search on the name "Bill" but only search on the latest records added to the database for each Country (by date) and return a result that matches "Bill".
I currently have a search set up that does an outter and inner search but it searches for anything matching "Bill" and then returns the latest records for anything that its matched (so i get results for Australia because its found a bill record but it displays the latest record for wendy)
View Replies
View Related
Hey I keep getting this error when i try to use paging in asp for my search results. Error: "Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype." I have read a number of different websites to try and fix the problem but none of the solutions seem to work. Code:
View Replies
View Related
I currently have a working search w/highlighted results page. My problem is that there is HTML stored in the text that is being searched and whenever the searched keyword is within HTML, it throws off the rest of the page.
I would happily throw away my code and use another if I could get it to check for things like <> and avoid breaking them. Ideally what I tried to do was display approximatly 10 words on either side of the highlighted keyword, just to give it some context, but I have thus far failed to get this to work properly.
View Replies
View Related
I'm wondering how I can rank search results based on how close the result is to the search term. For example, I have a database that includes a field for position title. When a user searches for the title "President", they are shown a list of everyone with the word "President" somewhere in their title.
However, I want to show the records for the presidents above the records for the vice presidents. So I guess I should say that I want to show exact matches first, then loose matches afterwards. Can anyone tell me how to get started on this?
View Replies
View Related
What do you call it when search results are broken up into page numbers across the bottom? I want to try that instead of getting a long list of results. I was going to search but none of the terms I tried returned anything.
View Replies
View Related
I am trying to sort the results of a search. The SQL statement looks like this:
strSQL = "SELECT * from DVDTable WHERE [Category] = '"&searchCat&"' ORDER BY '"&by&"' " & order
The output of strSQL is as follows:
SELECT * from DVDTable WHERE [Category] = 'Action' ORDER BY 'Rating' asc
Not sure what the problem is but the results do not get sorted.
View Replies
View Related
I have web page that returns all the entries from a table in the database. the web page becomes bigger and bigger as the database is expanded. how do i limit the results such that only 15 rows are dispalyed per page and the user will be able to go to the next page to view the next entries? .....
View Replies
View Related
I have an asp results page that returns results depending on their search criteria.I'd like to give them the option of clicking on check boxes in order to narrow down their results.
Do I put the <form> tags outside these results?Because if it returns many results,will it work if each result has the same select name?
View Replies
View Related
I have a SQL statement that returns the following list:
Email | Client_ID | Search | Description
test@test.com | 1 | chevrolet | chevrolet, in new condition
test@test.com | 1 | chrysler | very nice chrysler, $ 500
mail@mail.com | 2 | chrysler | good chrysler as new
Email = e-mail address
Clienst_ID = ID of the client
Search = Keyword that a client entered in the database to search for Description = The result from the database based on the keyword. Code:
View Replies
View Related
I have search capability in the web site that I'm working on. I submit my search criteria, and using the post method, displays my results on a results page. Now here is the problem: If I click on a link within the results, and opt to go back to the results page, my page has expired as it needs to request those objects.
I used for the search criteria again to repost and display the results. Is there an easy way around this so that when I hit the back button it can just redisplay the results with the criteria I've already used to query?
View Replies
View Related
Well I was able to build a simple search page, that would search a database and give the results on the restuls page from the criteria on the search page....
However I am having a issue with the data that's shows in the results. I'm getting the ID Column of the table in stead of the Column with the names. Eg:
<%=(births.Fields.Item("DName").Value)%>
Is there a way to change the data to be displayed to another column?
View Replies
View Related
I have a database with several hundered images and I need to retreive them using recordset paging, otherwise the page will be to long. So far so good.
I added a search function which will return only the desired results. The first page returns the search results (30 per page) and I also have a line of code that tells me how many records was found, let's say 70. This should give me 3 pages of results.
But when clicking on the next link I don't get the next set of results, instead ALL the images from the database is returned on the following pages, starting from image 31 in the DB. Not just the rest of the originally search results. Code:
View Replies
View Related
I have two tables like this:
TapeRecords
TapeID - Integer Primary key
Title - Text
TapeDetails
RecordId (Primary Key)
TapeId (related to the taperecords table)
ProgramDetails (Text)
The tape details table has a record of the programs that are stored on each
tape and each tape we have about 20 programs.
What i want my users it to allow them to search by programdetails and
display the list of tapes that match that search. I am not able to built a
query to search and display at the same time.
View Replies
View Related
At the moment, I'm working on search engine based on several crtierias. Upon submiting their query, the system will then compare the values entered with the DB and return the search results. Those search results are displayed in a table and users are able to print out that search result page for reference.
However my problem now is if there are more than say 4 search results, though they can view it on screen, they cant print out the whole table! The table will be cut into 2, leaving the rest of the data out. So I was wondering if I can program it in a way where if there is more than 4 rows, it will break into 2 tables. I've attached my files for references. Code:
View Replies
View Related
I found this on the net but it shows that he is using one ASP page for both search and response. I need it for two pages. The first for HTML coding and the second (response page) with ASP coding. What do I need to modify? Code:
View Replies
View Related
I have a little function to highlight text if it exists.
Function Highlight(vFind, vSearch)
Dim RegEx
Set RegEx = New RegExp
RegEx.Pattern = vFind
RegEx.IgnoreCase = True
Highlight = RegEx.Replace(vSearch, "<span class=""Highlight"">" & vFind &
"</span>")
Set RegEx = Nothing
End Function
The only problem is, that if I search for "something", "something" appears
highlighted when the string being searched actually contained "Something".
This is not about case sensitive searching, this is about showing the actual
match rather than what was being searched for. Code:
View Replies
View Related
how to create a search option that would search the recordsets in my database table.
I would be allowing users to search by name or date. I'd like the results in the same page. Any suggestions or tutorials?
View Replies
View Related
I have a page with a list of links that when clicked submit data to a clients search engine, The result opens in another window and either displays a list of items or diaplays "No Items Found".
I want to perform another action in my Asp Page if the result is "No Items Found"
Can I get my Asp page to read the result from the search engine when it's results are returned in another window or would i have to return them into a frame?
View Replies
View Related
i have been trying to create a search and result page. - (The same page if possible) using both Dreamweaver and Frontpage. But keeps returning a provider failure code. i know want to just code it to see if that will work but am a newbie when it comes to coding. I wish to do a search on 1 field in a SQL database if at all possible using a trusted connection, but return more fields from various tables.
View Replies
View Related
i have a form with 2 radio buttons(title1 and title2), a textbox and a submit button,(the form is called search and its posting to searchresults.asp) and i have 2 procs corresponding to each radio button.
what i want to do is,when a search button is clicked, radio button value checked must execute a specific proc(meaning the value must be passed to searchresults.asp and execute a proc accordingly).
View Replies
View Related
How can I force to show search results in IFRAME? The search-form is part of many pages of my website separated from the result page. Search works fine but opens a new window.
<form name="search" method="post" action="/search.asp">
<input type="hidden" name="action" value="dosearch">
<input type="hidden" name="offset" value="0">
<input type="hidden" name="allwords" value="1">
<input name="words" type="text" size="13" maxlength="90"> <a target="iframe" href="/search.asp"><img src="/pics/lupe.gif" width="18" height="18" alt="" border="0"> </td>
</form>
View Replies
View Related
I am having a problem with the following search results code. The first page of results looks normal, but on the second page (records 26+), no results are displayed and the following error message is shown:
“The catalog directory can not be found in the location specified by 'CiCatalog=' in file indexServer.idq.”
I do not understand how the catalog could have changed in between the first and second pages of results. Can anyone tell me what may be wrong? I have attached the search page (search.htm), the query file (indexserver.idq) and the query results template (indexserver.htx).
View Replies
View Related
I have a search page ( below is some of the code). I am currently displaying records from my Access database. At the end of each row, I am printing out a delete.gif. On click of this image I would like to Delete the printed record. How do I do this? Can you point me in the right direction? Code:
View Replies
View Related
I am trying to create a parametric search within a table (in the column headings). My first page (search.asp) allows you to choose parameters from a dropdown box, such as package and volts. You click "search" and it reads the Access dbase to yield the results.
The results page (results.asp) displays the information based on the parameters. Under the package column heading, I have the same drop down box, and I am able to once again choose the package I want and the table will refresh. Code:
View Replies
View Related
here's what i want to do. from an asp page, perform a search on a
table in access. i have used sql code in the asp page itself, but i'd
rather execute a query in access. i have success in running any query
(basic SELECT, SELECT with conditions _other_ than LIKE, etc..) for
some reason, when i execute the query below from the asp page, i get
no results.
the search.asp page just has a text box in a form that submits the
srchBOX field to the results.asp page.
here's the asp code from the results.asp page: Code:
View Replies
View Related
When searching through code in Vis. Interdev 6, when in the Find
dialog, it listed the results in the results pane below. The cursor
didn't change position to the next found item until you clicked on a
line in the results.
This is actually a nice feature that I haven't seen before -
all the matches show up at once in a list,
with a column containing the text for the line the string was found
in, so you can quickly see the context of the match.
Anyway, the first couple times I used CTRL-F, I saw a results pane.
Then I must have changed something without realizing,
because now when you search, no results appear in the results pane,
but the cursor moves in the editor window. This is the behavior I am
used to with Vis Studio 6, but I would prefer to turn the results
pane back on.
View Replies
View Related
can i search a database field for a specific word. for example i have a field in my user database(access database) called name and in that field i have more than one name that is separated by a comma such as john,james,mike,etc.
is it possible for a user to key in into a textbox for instance james and click search than only the name james will be shown. i just want to know is asp how the select statement will look like.
View Replies
View Related
I've had a site built for me but the programmer got on my tits for a variety of reasons - I know nothing about databases and need someone to help me sort out a fairly simple problem with two search fields.
(URL address blocked: See forum rules) is a site that will offer users the ability to sell and swap books online but the second and third search fields on the home page are returning no results.
View Replies
View Related
how to search multiple fields in an access database?Basically I want the code to search an entire table, field irrelevant.While I'm at it, does anyone know how to make the same search not care about word order or placement?
Such as:
Search string: "John went to the store"
returns the same results as
Search string: "The store went to John"
Just thought I would throw these out there and see what direction anyone can lead me.
View Replies
View Related
I'm trying to create a search page with a beginning and ending date, but I can't seem to get it to work. I am using SQL Server. Here is my statement:
SELECT *
FROM dbo.REQUEST2
WHERE REQUEST_DATE BETWEEN ' " & Request.Form("txtBeginDate") & " ' AND ' " & Request.Form("txtEndDate") & " '
This statement is not returning any records when I know there are existing records that fit the criteria that I'm entering.
View Replies
View Related
