I want to create a search form on my site using ASP, it will search through the database and return many many records. But I don't want ALL those records to be shown on ONE page, I want them to be "splitted" up to many pages, about 10-20 records per page. You know, just like any MP3 sites or Soft sites. Is there any one can help me to solve this problem? Or you can show me a link to another location which can show me a way.
View RepliesHere is what I am trying to accomplish.
Language: .asp vbscript
Building a searchable real estate property database (MS Access)
Search page submits form variables to result page.
Works great but I have seen other web sites where the results page is a custom named page. for example.
If you search for homes with the following criteria.
Criteria: Buford, GA 30519
Your results page is named something like the following.
MLS-Buford-GA-30519-10-Distancea-0.aspx
Is this only doable in .aspx or can I accomplish this task in .asp?
i want to have a search application wherein it returns a results page and arranged based on the most relevant word. can you please give me an idea with this or point me to any info.
View Replies View Relatedi am trying to make a search/result page(using asp, dreamweaver,iis,winnt,miscrosoft access database) wherein the results page brings up the most relevant words or phrases and not in alphabetical order.
View Replies View Relatedi'm sure there're no post about this in asp forum.Any idea how do I show the percentage number for the matching result.
example :
Your search for xxxx :
1. item 1 98%
2. item 2 86%
3. item 3 75%
we have a MSAccess database of products with titles, short descriptions, long descriotions, bulletpoints etc contained for each product. we currently search the database looking for the target keyphrase within the fields, but this doesnt give any accurate results as for example a product that is compativle with "widget 1" is shown before "widget 1" . anyone know of a process that will give us better, more relevant search results?
View Replies View RelatedI am in the process of making a new frontpage for the site and i would like to have some new links on there. However with the site been .asp based as its an online store im unable to link to a specific product range.
I would like to know if it is possible to make a link to include a specific search string so that it will display the information that would be displayed if a user had typed this in on the search bar of the site.
For example i would like to make a link that displayed the results for "black shoes" exactly as it would return if a user had typed this into the search bar.
i am developing a search engine(ASP with SQL SERVER) for my project . My objective is to search for a data and it should display the result and highlighting the search text in different color. But when i use the search text with more than one word, the result is highlighting only the last word of the search text.
Example - If i search for "Opal" , the search result highlighting all the words with "opal", But when is search "Opal Service", the search result is highlighting only the "service".
Here the "Opal" and "service" are different identities, i will search these two words with AND condition . Code:
I have created a search page which has a text field and button to search.When searching, if you dont enter anything into the text field, you get no results. I would prefer that everything in the database shows rather than nothing. I am told that if you enter '%' into the text field everything will come up. But how would I make this happen automaticaly rather than the person searching typing this in every time?
Text field code:
<input name="keywordSearch" type="text" id="keywordSearch">
Button code:
<input name="Search" type="submit" id="Search" value="Search">
why my results page is not coming back with anything?? I have set up a simple form in dreamweaver, it connects to a access database and IIS web server. When i test the recordset it works ok (returning the desired affect).
It uses a post method therefore the recordset uses form variable. But when i preview in browser(either IE or Firefox or Netscape) and enter text the browser comes back with something like the page does not exist or can't be found? It's not the recordset and result page so is there something else i'm missing?
My web page is calling a result set that is displayed on the page. If I click refresh, it pops a warning saying, "The page cannot be refreshed without resending the information." I then have to click RETRY in order to refresh the page.
Is there anyway to automatically perform that action so that my users will not have to be prompted?
I have a search page that allows user to search a SQL database and want the result page to display on a search page. How do I get the result page to display on a search page when user clicks a search button. Have you got any sample codes to demonstrate this?
View Replies View RelatedI want to add two buttons to my page, which direct to and send query information to different result pages.
View Replies View Relatedit is possible to compare the result of 2 recordset and
filter those similiar results,and display only the remaining results
We are building an application with ASP/SQL Server and need to build a
search page. I want to display lots of fields/textboxes on the search page
to allow user to search any field by entering the search terms in any of the
textboxes.
I was thinking of using lots of if conditions to build the search string
something like
strSQL = "Select <<fieldnames>> from Contracts where Active= True "
if request.form("contractno") <> "" then
strSQL = strSQL & " and contractno ='" & request.form("contractno")
& "'"
end if
Does anyone know of a better way to build the SQL string. Also any methods
to speed up the query built will be much appreciated. I have already limited
the total results that the query displays but adding " Top 20 " in the SQL
string. Any other suggestions?
When a visitor hits the F12-key, there will be a search-window to search within that page
Can anybody give me a ASP-script that will do exactly the same. So, a little ASP-script with a "input type=text" to search in that page.
I am trying to make a search page. Once a serach word or words is put in I need it to serach multiple product tables and output the description of any prioduct if the search word is present in the description.
However, If i put in 2 keywords like "paper sticker" I get no results. How do you search multiple keywords? Code:
I am trying to create a search page. I have few hundreds of word documents in my server. I am giving the user a text box to enter the text to search within these word documents. when the user enter "xyz", all the word documents that contain xyz should be filtered.
View Replies View RelatedI am shine from India, a web programmer. I want to know
about how to create a domain search page using ASP.
I am starting to create a seach page that will seach a database based on values entered by the user. I have the actual seach working but now am working on the user interface.
What I would like is to have a screen with 2 rows of text boxes(search parameters) where the user could enter a name or location to search on the database with. AFter data has been entered and the user clicks on the submit button I would like the results to be displayed on the bottom half of that same page with the original search parameters at the top of the page. I don't want to open a new page to display the results.
I made an application using asp using help from fellow members. This application allows user to download files uploaded through ftp through a web page. they can select the check-boxes and download all the files in a single zip file.
Now some users want that some search functionality should be put on so that they can type a part of file name and all the files having the searched words in their name should come on a separate page so that they can select and download in one go.
We have a simple html page that contains a long list of documents that users can hyperlink to. The entries are currently in alphabetical order and we would like to implement some type of page search instead of requiring users to go to Edit, Find, and type in the search.
suspect that this is possible. We would simply like to have a SEARCH box at the top of the page and it allows users to search only the current page for words. We simply want something a little more eloquent than the built in IE page search.
Search results on my site started to show a large number of page
links. I never had to deal with it before but it is time now. I am
trying to come up with a good logic / idea how to display a large
number of page links without showing all of them at once.
For example, if user is searching for "pets" and gets 50 pages back, I
want to show 10-20 page links and hide the rest. Also, the closer user
gets to the last visible pages, the more hidden page links become
visible. Something like Google does...
If somebody worked with it before, could you share with ideas, or
suggestions, or good examples to look at? Is there a standard way to
implement this, perhaps?
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've taken over maintenance of a website running on NT 4, IIS with ASP pages and an MS Access database, but I don't have much experience with this platform. I've got the ASP down pretty well and know SQL, but am having a problem figuring out how to get data for the main page.
On the main page (default.html) I want to display a random business from our database of businesses. Since it's a .html page how can I run server-side code to run the query and select the business? Am I stuck with CGI or is there some other way to do this? I don't want to redirect from the main page to another page, either.
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 want to add a "quick search" functionality in ASP or ASP.NET page. I heard
we can use Microsoft Indexing Service to accomplish the task, but not sure
how to do it. Is this the correct approach? Code:
I am trying to make a search page. Once a serach word or words is put in I need it to serach multiple product tables and output the description of any prioduct if the search word is present in the description.
However, If i put in 2 keywords like "paper sticker" I get no results. How do you search multiple keywords? Code:
I have an ASP search function which, after typing the search term, searches HTML pages and creates a list of links.
The problem is that I do not know how to code so the search term is highlighted in red after the user clicks on the link to view the HTML page.
Does anybody have any experience uploading large files (60 - 200mb)?
I am having a lot of difficulty with this right now. I am using clsupload and it keeps timing out. It always just stops and says the connection has been reset.
I tried changing the aspmaxupload in the metabase.xml and using the script timeout function but nothing seems to work.
I have a database setup and the results come out as
Product 1: Shorts
Size: M
Price: £2.99
Product 2: T-Shirt
Size: XL
Price: £3.99
Total: "TOTAL HERE"
What I need to do is total these up
The Cells are called:
Product
Size
Price
I want to do some checking for my table for eg:
I want to check if the table for which year then if same year then do something.....
Does anyone know how i can make
[code]
Dim excl
excl = rs("price") / 1.175
[code]
return only a 2 decimal place number