Simple Page Search
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.
View Replies
ADVERTISEMENT
Have a database setup and its main purpose is for images. image libraray. There's a few database tables all linked some how or another. The main one being "tbl_img" where images are linked to a project, owner, and have details about that image etc. Im after creating a simple yet advanced in terms of people selecting and searching search script.
SQL server is used for the tables. Hope i make sense. like a libraray I wish users to search on many or 1 criteria from a few available which can then return results. And examples online would be great. I think i could go about it no problem Im just asking for advise and maybe help speed things up if I see early "mmmmmm, i like the way they did that" .
View Replies
View Related
i have a text field that the user can input a keyword to search on. i want it to search two fields in my database: productName and productDetails. can someone tell me the sql i would have to use? I know it would be a mixture of using the WHERE and LIKE commands.
View Replies
View Related
I'm building a simple search page, the database connection is fine, but when I hit the search button. I get this error:
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/sort_search.asp, line 63
This is the line it's referring to:
Response.Write(" <td>" & RecordSet.Fields("Name") & "</td>")
but I think this is the problme, but I just don't see a problem and the database is fine as well: Code:
View Replies
View Related
I am trying to do a simple text search
The Table I am searching is called 'Items' and the Field I am searching is called 'Item Title'
My search sql string is as follows:
strSQL = "Select * From Items WHERE Item Title LIKE '%var2%'"
However I keep getting the following error message:
Microsoft OLE DB Provider for ODBC Driverserror '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Item Title LIKE '%var2%''. /showroom/asp/showroomSearch.asp, line 45
Is this error being caused by the fact that the field I am searching has a space in the name? If not, please can someone tell me where I am going wrong as this code seems correct to me.
View Replies
View Related
I need to send data from a 'form' on an HTML page to an ASP page.
The ASP page should 'return' a simple HTML page containing
the data from any items submitted, including any hidden items.
View Replies
View Related
I am in the process of building a Simple Survey, and I am having trouble getting started. I have put together my html form, and now I need to build my "survey.asp" page to communicate with my Access database. I have designed my database to have 3 tables: Department, Contract, Survey. Code:
View Replies
View Related
I am attempting to write a simple progress bar for a redirect page. I am unsure if I need to do this in javascript or if I can do this in asp. The progress bar is a series of square blocks that are transparent, but outlined, and fill as the loop works through it's processes. I have been tinkering around with this for awhile now and I can get it to run. sort of.
I get the same table written on the page as the loop goes through it's process, instead of just one table. I was also looking for a simple timer that pauses before doing the next action. Is that just a simple server.pause or server.timer?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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 Related
I am shine from India, a web programmer. I want to know
about how to create a domain search page using ASP.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
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'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.
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 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:
View Replies
View Related
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:
View Replies
View Related
Here 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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
A system I use uses advanced encryption for passwords. It was taken from some sample script and adapted some where. However this was I think intended to be for passwords. So nothing too long.
However the time has come where I need to create a function to encrypt a large amount of text. It has to encrpt a large amount of text but nothing too advanced is needed to be honest. Just so its unreadable because its written to a text file on drive. It has to be a function though then capable of decrypting the encrypted text.
Any ideas ? Again Dont have to be nothing too flash. I mean I had a go at just changing letters to different letters but the function got huge with all the replaces.
View Replies
View Related
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.
View Replies
View Related
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 Replies
View Related
i have 3 fields like these
membershipamount=100.00
Postage=15.00
GiftArticles_Amount=5.00
and i add them up to get the totalcharge like this
Total_charge=Int(membershipamount) + int(Postage) + int(GiftArticles_Amount)
so i get Total_charge=120.00 which is what i want
but when i have like this
membershipamount=100.00
Postage=15.00
GiftArticles_Amount=3.50
i get Total_charge=118.00
View Replies
View Related
does someone know a good site for asp 3.0 interiew questions
View Replies
View Related
I have only begun to look into ASP due to an assignments requirements.I usually code in PHP,one feature in PHP is to be able to do an if.else statement,where if a certain statement is true then a chunk of HTML can be outputted.
Basically I want to be able to do this in ASP to use with a simple authentication system which I will construct.I have just got a fat book on ASP,and am beginning to read through it
View Replies
View Related
I am not an ASP programmer, but I need help with the syntax. I have a simple if/else statement that I need to translate into ASP. Begin Pseudocode
if
{
(id == 1,2,3,4,5,6),
then print "Private"
}
else
{
Print <a href="https://www.mydomain.com/file.asp?ID=<%=rs("ID")%>" target="_blank">Register</a>
}
End Pseudocode
So how do I say this in ASP?
View Replies
View Related
i'm trying to create just a simple upload - fill in a form with the article
title, and description - and select a file - i need to upload that file to
the webserver, and then rename that file to the <% =Sartid %>.pdf
any ideas where to get something this simple from? never done anything like
this before - i'm guessing the FSO will be used?
View Replies
View Related
This code is working partially fine
<%
sch = "http://schemas.microsoft.com/cdo/configuration/"
Set cdoConfig = Server.CreateObject("CDO.Configuration")
cdoConfig.Fields.Item(sch & "sendusing") = 2
cdoConfig.Fields.Item(sch & "smtpserver") = "mail.aws.no"
cdoConfig.fields.update
Set cdoMessage = Server.CreateObject("CDO.Message")
Set cdoMessage.Configuration = cdoConfig
cdoMessage.From = Request.Form("E-Mail")
cdoMessage.To = Request.Form("sendto")
cdoMessage.Subject = "Tilbakemelding fra nettsiden"
cdoMessage.TextBody = strBody
cdoMessage.Send
Set cdoMessage = Nothing
Set cdoConfig = Nothing
Response.redirect Request.form("resulturl")
%>
Well, this works with only some addresses and not others.
Examples:
bjorn@domain.no
b@2.com
will work...
On the other hand:
bjorn.kaa@domain.no
bjorn-kaa@domain.no
won't work at all...
View Replies
View Related