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.
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?
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.
I 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:
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 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.
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.
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:
I created a web page from Excel2000, using "Save as web page..."...Publish function. then, I moved htm file to my IIS web server. Then I added a form control, and submit button.
How can get the data on the excel file using ASP from server side? For example, the value of Cell(1,2), Cell(2,3)....
What I want to be able to do is create a user control that will display an entire page page within it. Does anyone know how to do this or better yet have any same code?
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
I have an ActiveX control in my ASP page that has not been signed yet, so currently just for testing I set the Security for Intranet to "Low". When I run the ASP page on my machine (the IIS is in my machine), I have no problem, except the page prompted me with "An ActiveX control on this page might be unsafe to interact with other parts of the page. Do you want to allow this interaction?"
But, when I run the ASP page on another machine (even though the other machine is also a development machine that already has the ActiveX control and I set the Security for Intranet to "Low"), it did not prompt me the above message, and I got an error when accesing any method of the AX control (e.g Object doesn't support this property or method 'myAXControl.method').
Is this because I have to create a CAB file and mark the AX control as safe for scripting ?To create a CAB file for this AX control, do I need to create my own VB AX Control project that contains this control and then create a cab file for this VB project ?
This is a standard ASP application that has several pages at the root withthe global.asa. I set a session variable session("accountid") = "123456" within an asp page and then response.redirect to the next page and immediately response.write session("accountid") and I get back nothing.
But if I set a session variable session("accountid") = "123456" within an asp page and response.redirect to a page in a sub directory and immediately response.write session("accountid") I get back 123456 on the screen.
I am having a problem with a site that I am developing - my aim is for it to validate as XHTML Strict however, I am running into a couple of problems validating it; in my Response.Write ASP script, I am not including " 's to define page element tags as they keep throwing up errors in the page. Code:
I've a strange problem with Windows Vista, running an ASP page on local machine (http://localhost/test.asp), the page does not give me any error but the asp code is not executed (simple code : <% response.write("hello") %), it show me a blank page, I think I've put all the setttings correctly, but maybe I must do something obvious to fix that.
I encounter a page reload situation in ASP. It is I need a way to differentiate whether the current page - "Application_Result.asp" got reloaded itself when user click on the browserRefresh button or is requested by the previous page "Application_Form.asp".
I tried using <%if Request.ServerVariables("REQUEST_METHOD") = "POST" then%> <!--it is requested from "Application_Form.asp, do something--> <%else%> <!--Application_Result.asp refreshed itself(such as user clicks on the browser Refresh button, do something else--> <%end if%>
However, in both cases, the IF statement above all evaluated as true. how to differentiate this two different behavior (Page Refresh versus Page requested by another Page) ?
I have page for user to update his/her details. What i want is after idle for more than 20 mins, the page will redirect to login page automatically. So that the user knows that his/her session already expired and need to login again.
But it doesn't working. This is because if he/she update the details (after idle more than 20 mins), and click the Submit button, it will go to login page and all the data will be lost. Code:
I have list of songs in table in asp page. I would like to put a link to each song so when user click on one I can search database for it's data. How to do that?
i have a database with 5 tables, on my web site i have a search bar.. i wana link that search bar to my tables so.. when ever some 1 searchs for a product, the search bar shows that all the simmuler products to what they searchd for..
