I've created a search page that gets complete addresses based on postcodes, and name, suburb and address.Almost 6000 entries in the db.I want to limit the amount of times a user can search, i tried cookies but anyone can delete cookies and off they go again.The reason behind this is to prevent the opposition from collecting stuff and cold calling them.
View RepliesI have this code in a procedure, and it basically will select all the quotes from a certain 'manager' and if the date is more then 7 days, it will archive the quote (by placing a 'Y' in it)
Declare @tempDate varchar(20)
SELECT @tempDate = DATEDIFF(day, SaveDate, getdate())
FROM QuoteFeedBack
WHERE TerritoryManager = @Manager and Archive <> 'Y' and QuoteNumber = '3'
if (@tempDate > 7)
UPDATE QuoteFeedBack Set Archive = 'Y'
WHERE TerritoryManager = @Manager and Archive <> 'Y' and QuoteNumber = '3'
Now this code works, but instead of specifying the QuoteNumber, I want it to scan through all the records for that manager. Basically searching all the quotenumbers that have not been archive yet.
I am searching a string that look like this (21,5,15,25) using Instr().
So, if I am searching for '5', I get everything that contains a five.
If InStr("21,5,15,25", req,QuerStr("id") Then
response.write "yes"
End If
I want only the one value '5' to get found but anything that contains a 5 is found. I have tried using Cint and Int to no avail.
I was told by a friend that Web searches like Yahoo can't "find" ASP pages to return their results within a search. Is that true?
View Replies View RelatedI've got a catalog (table) of products (records), which will undoubtedly grow to over 5000 records in months. This is in an Access 2000 mdb file behind an ASP page, and the products have full text descriptions. I want my customer to easily "search" the database
table with a simple SQL query. I guess I'll use a LIKE operator to search the field with the product's long description.
Problem: Noise words. i.e. - and, but, it, its, or, the... will return thousands of records and slow down browsing efficiency.
Has anyone got a good solution to easily eliminate noise words from submitted text entered into the asp page "search" field?
I was able to find the file noise.enu from the Microsoft Index server installation. It has about 50 words or so. Would I use a replace() function to eliminate the words from my sql statement?
I'm sure someone else has come across this.
What would be the BEST and most logical way of using VBscript and ASP to accept the query string typed and then condition it for introduction into a "LIKE" statement in an ADO query?
I am running a contest in which people can vote for a villain, but I had to take it down to figure out a way so people are only allowed one vote (at least per day or something) Does anyone know a way that I can restrict access to the people voting to one per day? I know how to get the users IP address through ASP, maybe something to do with that?
I am short on time for this
I have a Textfield input for an amount of money and wish to restrict this to two decimal spots any ideas ?Code:
<input name="amount" type="text" maxlength="10" id="amount" value =<%= amount %>>
If I were to write an application in ASP and sell it to a business, can i restrict people from installing it on multiple servers?
View Replies View RelatedI have a .asp page which is protected by a username & a password. Only people having the required details can view that but I wanted to know is that possible somehow that even if the user has username & password he should not be able login from every machine but only through machine from where we authorise.
The IP address of that machine will not be static so i cannot make restictions through that.
I'm trying to limit access to certain portions of our intranet application from certain user levels. For example, an admin user would have full access to the site while a data entry users could only access small portions of the site. What is the best way to restrict pages? I have a UserLevel field in the database for each user and have already added this value into a session variable. What about pages that should allow Admins and Managers, but not data entry users? I am using a SQL Server 2000 database .....
View Replies View Relatedhow can I in plain old ASP restrict a cookie to a folder like http://www.site.com/folder1 so that it is not seen by folder www.site.com/folder2?
View Replies View Relatedhere is the code for the asp that basically handles the uploads, how could change it so that the uploading form will only allow .doc or .xls files? Code:
View Replies View RelatedI'm doing a web page with Admin rights to a MS Access database. So far when the admin logs in they are directed to the admin page. However if someone knows the name of the admin page they can still type it into the address bar and it will pop up with no restriction. Any ideas how to restrict this access to administrators only?
View Replies View RelatedIs there a way to keep an other application from opening a link in a
browser where I am running an ASP application?
For example, I have an ASP application open in a browser. If I click on
a link in an email message, Outlook "hijacks" the open browser and
opens opens the link in it. Is there a way to prevent this? To somehow
identifiy that browser window as "off limits" to another app?
I'm creating a web application for my company now. This application has 2
parts. 1 part for the customers to access. The 2nd part is for our staff to
access only. My director hopes to make the 2nd part to be something like an
intranet, such that only our company's computers (maybe only 1 or 2 in the
company) can login to this part of the application.
1. My company's intending to put the application on shared server with a web
host. Windows Authentication is NOT allowed.
2. My company doesn't have a static IP address.
3. My manager suggested using Network Card number (which I don't really
quite understand. Is there a way to get the Network Card number that's on a
client PC?).
How??
Some ISP told us that they can provide a firewall management feature such
that it will restrict access to the website from anyone that is not coming
from my company's network. This requires Static IP.
Another told me that IIS Manager has the security feature that restrict
access based on IP address. This requires Static IP again.
Is it possible to implement the 2nd part (the part that is to be accessed by
my company's PC) as a windows application instead? Then we only put the
windows application on one computer. So, 1st part (for the public) will be a
web application, 2nd part (for my company) is a windows application, both
accessing the same database server from an ISP. Will the ISP allow the
windows application to access its database server? I've no experience in
making a windows application at all, is it the same as making a web
application?