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 Replieswhat term is used for limiting the number of results pages displayed. My site has over 1500 searchable article, if you search for "a" then it returns all 1500 articles in batches of 15/page.. I then have 100 links to results pages. How do I truncate the results pages.
View Replies View RelatedI 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:
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.
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)
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 RelatedI 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:
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.
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?
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 RelatedI 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.
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?
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:
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?
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?
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:
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.
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:
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 RelatedI 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:
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?
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?
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 Relatedi 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).
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>
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).
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 RelatedI 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:
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:
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.
This question has to do with MS file search but it is happening only with
..asp pages, so I though someone programming with .asp pages has experienced
the same situation.
I'm trying to find .asp pages with a certain table name (i.e.
"renewalInfo" )
When I ran the search I get no results. I know that I have that string in a
couple of pages. My file system search engine is working fine with other
file types, like Word documents, Excel spreadsheets, etc.
I tried typing the string outside the <% %> tags and when I do the search I
get the file results, so it seems like if the search engine in my file
system was not searching inside the <%%> tags. Code:
I'm just about to start a project that needs to combine the results of a SQL
Server query with the results of an Index Server query. The basic idea is
that the user enters/selects a bunch of search criteria on a form.
Most of
the criteria selected by the user will be used to select records from the
database - standard WHERE clause stuff - but the user can also enter
free-text that should be searched for in associated uploaded documents.
The
documents are sitting in the file-system with file-name pointers only stored
in the database (not the document). Only records where the associated
free-text is found in the documents should be returned. I'm new to Index
Server and am wondering how is this done. Any good references/tutes?
i get the ref url that come to my site and i want to convert it to find
out what was the query in (google or other searcher sites)
foe example : if someone goes to google and search some text and my
site was in his resaults and he click on it , in my site i see his link
ref like
http://www.google.co.il/search?hl=i...91-Google&meta=
i want to know (in asp and save it to DB) what was the word or words
that the user write in search engine.