I have a database with a field called "Value" in one of my tables. This field is just set as number. I want to be able to search this field so that users can bring up records in the database.
How can i get it working so that instead of have a long dropdown list of all the values i can just have a search that offers the user the option to use Greater than "A Value" or Less Than "A Value".
I'm trying to write a zipcode validation. I want to validate if the zip is less than 5, then error, and if zip is greater than 5 but less than 10 then error. here is what I have, it's not working:Code:
If Len(zip) < 5 Then
r7 = "<img src=""removeX.gif"">"
InputError=InputError+1
else
If Len(zip) > 5 AND Len(zip) < 10 Then
r7 = "<img src=""removeX.gif"">"
InputError=InputError+1
How do i check if one form value is greater than another in a request.form?
View Replies View RelatedI've noticed that session variables will persist on Mac IE even after all browser windows have been closed. One must quit the program to clear the session variables. This presents a security risk for my session variable based security scheme.
Basically, the risk is that a user will login to my site, close the window when done and allow someone else to come up to the machine, go back to my site and be logged into the previous user's account.
how to make session variables disappear when a window closes? Am I going to have to redesign my whole security scheme?
I am trying to write an ASP SQL for a date greater than today:
Here is my SQL Statement:
Select * from table ORDER By date ASC
date is the field that stores the date. I want to retrieve all records with a date treater than today.I have tried a number of things but nothing seems to work. By the way I am using SQL server and not Access.
I know the UPDATE sql, all I need is to figure out how to get all the records, see what their date is, and if their date is greater than 150 days (dateDiff) execute the command code. How would I do this?
P.S. It's for a 'auto-archive' script...set the field Archive value to 'Yes'...
When using the following statement, I am encountering a problem:
<% If rs.Fields(0) = "Lead 30 Day" THEN %>
<% IF rs.Fields(2) "89" THEN %>
Pass
<% ELSE %>
FAIL
<% END IF%>
<% End If %>
rs.Fields(2) is a numerical value, in this case 100. For some reason,
the page is still displaying "Fail" for the record, even though 100 is
obviously larger than 89.
Any ideas on why it would think 100 is less than 89?
I need to show an image in the header of an asp page. If the image's width
is greater then 82 pixels, the header gets mis-formed. If I specify the
height for the image and it is smaller then 82 pixels it gets stretched and
misformed.
How do I solve this? At first I planned to write a vb-dll that checks the
image's height but since the image come's as a BLOD from sql-server tat is
a no-go.
Can I find the original height in the binary data from the blob itself?
I m having two combobox on my page cmbyear(years) and cmbmon(months). i want to make a check that if year selected is current year then selected month should not be greater than current month. how we can achieve this.
one way out is that we can store values of selected options in two variables in javascript function. In the function we can make the check that if selected value for year is current year and selected value for month is greater than current month then it ll show some error message and reload the page.
i m trying this but do not get results. May be i m having some mistake in syntax. can anyone tell me how to get selected value in a variable in javascript or some other way out to achieve this. I have applied same technique on text box value. its working fine. but with combobox. i dont know whats the prob.
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 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 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?
View Replies View Relatedi 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..
I was wondering if there was a way to search pages using ASP or ASP.NET.
I have roughly 5000 static html pages (an online library of sorts) and wants a serch feature. Is there any way to do this?
how to search within the selected category?? Example : Search "bubble clock" in category,Clock and watches.
View Replies View RelatedI have a search page that has ms frontpage database wizard results showing. The thing is, is that I want to have the search form on other pages besides my search.asp page. Does anybody know how to make a search form on a seperate page that submits the search to the database and displays the wizard results on the search page.
View Replies View RelatedNeed help here~ =) ..For -> while not rsConfiguration1.EOF ... blah blah blah
How to write my code so that even if its not End of record, it will still search my db?
In short : I want the db to be able to search under 2 circumstances : EOF and not EOF
How could I try and make the most important result from a search show up on top?
I was thinking of having a result where the strSearch is the most to the left come up on top but else then that vague and not necessarly effective option I have no idea on how to do this.
Intranet tech support system using ASP/VBScript running on W2000 Server,
IIS, and using SQL Server 2000. I need to add a search engine. The problem
with using a regular SQL query is that if you put a phrase, say "red car" in
the text box, to hit submit, my SQL qurey would only look for that phrase,
and would leave out other items where the words red and car appeared
separately. I guess what I am saying is that I would like something like
Google or other search engines, which would find results which seem to fit
the criteria typed into the box, and rank them and highlight key words.
My research so far has shown me that SQL Server has something called
Full-Text searching, and I have tried to read up on that in BOL, but not
really seeing how I can apply it. I wonder if there's already some tutorials
or sample code out there. I have done some looking on the Web, but still
haven't found much.
I have created an asp server page as described in the
Microsoft Article 318387 HOW TO: Query Index Server Data
by Using ASP in FrontPage 2002
(http://support.microsoft.com/?id=318387)
It is running off my IIS server for the search results.
However, the results return only file locations; I would
like it to return a link to the hits. How would I do this?
im now doin a search function... but my problem is... if i didn't enter any data in the textbox and then click search button, it will appear all list from database instead of display "please key in data".
I just want to display "please key in data" but not display all records. Code:
I'm make a search and I want to limt the results to 10 and have a next button.
View Replies View RelatedWith Index Server I can search web pages stored on our servers. Is there any
way to programmatically search web pages on the web ?
I am trying to set up a pge that allows users to search DB for their order status. I managed to get it working with 1 search parameter. I would like to give my clients more then 1 search option to search by.
This is where I ran into problem. I believe it to be with my lack of ASP knowledge and the problem here is with the SQL statement. I do not think that it will work the way SQL statement is set up right now but I am at a loss for correct syntax here. Am I way off ? Code:
I am relatively new to asp so still need help on it.
On my site I have a search that allows users to search for a specific job skill ie.cobol, asp etc
The problem is that at the moment the search can only search for what is exactly typed in the box eg.
"ASP" this search works fine,
"ASP, HTML" this doesnt because It searches for what is typed in.
I have been told It is something to do with parsing and that this will allow me to search for multiple job skills using commas to split what is typed in. If any body has any ideas I will be very greatfull
Does anyone have or know of some ASP programming that will allow me to do a text search of a folder full of PDF files?
I want a user to be able to enter some text and then the programming to do a full text search across all the PDF documents and return the results.
I want to search the content of some database tables,do asp has some function or tool do this?
View Replies View RelatedI have a column in my database where emails are copied to, and i need to be able to search through each entry for certain keywords and display the results if the column contains any of the keywords. i can't figure out how to do this though, because if i use the select statement like this:
select * from maintable where column LIKE ('keyword')
or
select * from maintable where column IN ('keyword')
it will only display the results when the keyword is the only word in the field.
I'm producing a search that when a section is chosen from a drop down menu the search only searches the selected section. The problem is the code below searches others sections as well as the selected one.
strSQL = "SELECT * FROM qry_Policies WHERE SectionID = " & request.Form("section") & " AND title like'" & txtSearch & "' or keywords like '%" & txtSearch & "' OR keywords like '" & txtSearch & "%' OR keywords like '%" & txtSearch & "%' AND '" & txtSearch & "' OR title like '%" & txtSearch & "' OR title like '" & txtSearch & "%' OR title like '%" & txtSearch & "%' ORDER by title" .
It may be a really stupid question, but if you dont ask, you dont know. Is it possible to search an an xml file, which is used for an RSS feed, with asp at all? So for example, i want to have a search box on my site, which will then search the xml file for the search term, and then return the result to the person searcing?
View Replies View RelatedI'm producing a search that when a section is chosen from a drop down menu the search only searches the selected section. The problem is the code below searches others sections as well as the selected one.
strSQL = "SELECT * FROM qry_Policies WHERE SectionID = " & request.Form("section") & " AND title like'" & txtSearch & "' or keywords like '%" & txtSearch & "' OR keywords like '" & txtSearch & "%' OR keywords like '%" & txtSearch & "%' AND '" & txtSearch & "' OR title like '%" & txtSearch & "' OR title like '" & txtSearch & "%' OR title like '%" & txtSearch & "%' ORDER by title"
I'm developing a site search engine and I need to have it be able to search through PDF documents also. Being a novice programmer, can anyone help me out with this?
View Replies View RelatedMy company's website has a search feature, and we would like it to search using multiple words instead of finding exact phrases. If I type Roland Printers, it finds nothing. But some of our titles have both of those words in them.
I've attached a screenshot of the code (I couldn't get it to copy and paste correctly out of dreamweaver).