Checking 2 Entries
Is there a way of checking whether two entries in a form are the same? Like when you have to enter your password in twice. I'm not actually sure whether it's asp. Sorry if I've posted in the wrong place.
View RepliesIs there a way of checking whether two entries in a form are the same? Like when you have to enter your password in twice. I'm not actually sure whether it's asp. Sorry if I've posted in the wrong place.
View Repliesi'm trying to limit the ammount of entries a user can put in the access database, here is my code:
View Replies View RelatedI have a problem with Insert statement. Though My SQL Statement executed once only, there are 2 records entered in DB. I am using ASP and SQL Server. Does anybody know the solution?
View Replies View RelatedI want to validate client entries into textbox,checkbox
controls etc. can u do this with asp. Like, is there
onchange and onclick and so on for these controls?
A different question though. Is it possible to delete duplicate entries,
where the email address is the same, and only keep one?
i.e..
I got say 4 DB entries, all with the same email address, and I want to
delete 3. How do I do this?
Does anyone know what sort of command I need to use so that if someone posts an entry to my database with a primary key that's already been used, the old entry is overwritten by the new one
View Replies View RelatedI have a database for projects. Some managers are responsible for multiple projects. I want to dynamically populate a list of project managers, choose a manager, and display a complete list of his/her projects. I have a few problems 1) I cannot figure out how to list a project manager's name only once in and 2) I don't have a clue how to compile all the projects for each manager so that when his/her name is chosen it will display all the records.
View Replies View RelatedI have setup a simple site in which users input data to an access database, and then the database results are shown on another page in a table. One of the fields in the databse is Date Added, using the date/time data type.
I would like the table to show new results with a different background colour for a period of time, say one week? Code:
There are a lot of references on the net on how to delete multiple entries in a database by using a checkbox. What I would like to do is add a checkbox to the output of a query (ie. bunch of names).
Then be able to select some of the names by clicking on a checkbox and when submitted, add those checked names to another database (insert). Similar to a shopping cart selecting multiple products but when submitted, it does not add them to the checkout, it adds them to a database as new inserts.
I have made a forum script and I know this is very basic stuff but how do you go about updating a number with an increment of +1.
Access Database - Two Tables - Topic and Replies.
In Topic there is a column called replies. When a user views a topic there is a reply form at the bottom which is processed by reply.asp which add the information entered to the database in the replies field. Also added is subjectid to each reply so I can link the two together.
Either I want to be able to update the reply number in the topic table by +1 in the appropriate subject row (the id is passed on to the reply page) or count the number of alike subjectid's in replies to the subject in topics. What is the best way and how do I update numbers by +1.
i have a registration form in my website. the requests are going to the database (windows 2003 small business server). I have an other page who the entries are displayied. how i can delete the each entry separately with a button?
View Replies View RelatedI tried the following code to save in a variable, the quantity of entries in my recordset:
if rsEntries.Supports(adApproxPosition) = true then
strCount = rsEntries.RecordCount
end if
It didn't work for me. It's returning a value of -1 and I have close to 100 entries in my recordset. Is there an alternative to this? What code can I use to accomplish that?
I have an ASP app (developed with Interdev 6) which uses
a DTC listbox (server-side) bound to a recordset to allow
the user to make a selection. This works fine until the
number of records in the record set seems to hit a limit
(not determined the exact limit, but seems to be c. 400).
If there are too many records, the app just hangs until
it hits the scripttimeout limit.
I've tried increasing
both the command timout (I'm using an ADO command object
to generate the recordset) and the scripttimeout to no
avail. Does anyone know whether there IS a defined limit
on the number of entries in a listbox? Also, any better
ideas on how to allow the user to select from a large
number of records (> 1000)?
User clicks on a button [BUY NOW], item is added to cart. User can either
continue shopping or view cart. The order here doesn't matter. When user
views cart, two items are added, the one selected and the last one in the
product file. The product file is a CSV file.
The last entry is called BAD-Product. It is a debug entry during site
development so the developer knows the product name is entered wrong, i.e.
misspelled. If the name was omitted an error would occur so there is a
name.
This only happens with Firefox and Netscape. IE experiences no problems.
The last entry is not added.
Accidental temporary solution:
In review of the code, a debug line was put in to make validate the product
item being returned. After saving the page (.asp add item page), the error
disappeared. The debug line was then commented out and the error still has
no resurfaced. Code:
I need to loop the recordset and count the occurrences of each entry. The entries will always be numbers.
If entry = 1 then count(1)=count(1)+1
If entry = 2 then count(2)=count(2)+1
...
If entry = 100 then count(100)=count(100)+1
The problem is that there could be 1-100 (or more) different answers stored in the field so coding 100 IFs will work (as long as noone needs to enter 101) but seems silly. How do I create the array above to look something like:
While...
<%
strField = (Recordset1.Fields.Item("Field").Value)
CntNumInField(strField)=CntNumInField(strField)+1
%>
WEND
The above code returns a "type mismatch"
I have a ASP page that returns and manipulates information from an access table. The information it returns is the figures for each month for certain products.
Basically the page adds up the results returned from each month and then gives a total for the year so far for each product. So we can view the figues for every year back to 2000 to see how the product did. The problem is that when we choose 2006 it returns no values, and I can't see why. The only difference is that for the months that havnt been completed yet - May onwards, there are no entries, not even a '0'. Would this be a problem when adding using the asp page, adding a number to a returned object that contains nothing?
I have a dbase containing login details for 21,000 members. I also have a
forum that I am about to implement.
When the user gets to the main site, he has to login (this is done by
checking his credentials against DB1) When he is logged in, all his details
are stored in session variables. Clicking on the forum link will take him to
the forum where he has to log-in or register. Currently, the forum checks
cookies to see if there is a valid name and password and then checks these
against it's own DB (herein called DB2) or requires the user to
login/register
I plan to modify the forum so that the login is bypassed and the forum
accepts the current session name and password as the login. (This is so that
all names on the site main site, chat, forum etc are uniform, i.e Dave47 in
a chat room, is Dave47 in the forum, is Dave47 in the members area etc)
so...what I need to do (if you're still with me) is.
When a new user registers on the main site, his details are put into DB1
*and* DB2. , can I have two data sources open at once?
The reason I need two DBs is that the information in DB1 is a lot less than
is needed by the forum in DB2.
Also how can I copy selected fields from DB1 (name, password for existing
users) into DB2? like I said..there's 21,000 and to do it manually would
take forever.
Does anybody have a nice method of forcing a user to enter a value into a
form using asp?
I think the best is to have a popup when they hit submit that will stay on
the same page and then just alert the user to enter something in so and so
text box.
I have a database that is for E-Cards. I want it to delete all of the entries that are more than a month old. I have the date stored in a field called "dags" (without the quotes). Please help me on this!
*******************************************
Also, I would also like to have an option for "Send the E-Card Later" and then have the options possible dates. What script(s) could I use to do the actual sending on a later date?
********************************************
I have this table that has two columns Department and RecId. what I am doing is I need to give access to different people in different departments. So if I am in billing I say billing 76 which is my rec id and than if I also need acess to accounting I say Accounting 76.
So now in my asp page I open this records set to check and see who has access to what departments and give them the access Code:
I want to check whether the value in recordset is "=> 3 ".
I try "If rs => '3' then...".
But it doesn't seems working. Can I can't check the condition by using the recordset like how i written above?
Or do I need get the value in recordset and assign to a variable in order to check the condition. Please advice.
Let say my rs now stores a value of "2". Can I check with the following code.
[code]
set rs = server.createobject("...")
rs.open "Select...", objconn
if rs >=3 then 'THIS LINE DOESN"T SEEMS WORKING
....
[code]
I want to do some error checking using on resume next to determine whether to commit an ADO transaction. However we have a custom 500 error page which we use through out the rest of the site. Can I remove the on error resume next after I have rolled back the transaction and raise a normal error.
View Replies View RelatedI'm trying to qualify email addresses. Is there any reason why the following line would not catch an email address beginning with "www." ?
ElseIf Left(Session("em"),4) = "www." Then
I put in a dummy email address: www.mydomain@aol.com and it goes through....
<%=Left(Session("em"),4)%> does reflect "www."
why?
Is it possible to have an ASP page which checks if a user is in a certain group in Active Directory (AD). For example jbloggs is logged in and belongs to the group "project_allowed". When jbloggs goes to project.asp it will allow him access
However when jsmith is logged in and belongs to no groups and tries to access project.asp it will deny him access.
The script is designed as a form validator which checks fields for various criteria and then sends a mail with the form contents. Since 40 different forms will be plugged into this script, there needed to be complete seperation between the two.
I've managed it so far by checking for required fields by putting the word 'required' into the name of the field. The script then sources out any fields which has this text and checks them to see if they are filled out.
The problem I've come across now is that I need to check for field length. My idea was to put the amount of characters needed into the name of the field in the form and then have the script check with a Reg Exp. However, Im not too sure of the regular expression needed to check for this.
Can someone suggest one? The one I have at the moment is [1-14] but say I had a field like this: <input type="text" name="passwordrequired12"> That would match bout for 1 and 12. Any ideas?
How can I check whether a variable is set as a value, integer, etc .. ??? (So that when a user submits a value via a web form and its a letter, i can give them an error note.)
View Replies View RelatedI am writing a script that lets me brows the contents of a web server. The problem is the account that is running ASP does not have permissions to every folder. Don't ask me why ... I have no idea but it can't be changed.
What I would like to do is perform a check for:
Microsoft VBScript runtime error '800a0046':Permission denied
And if this happens display an error message saying they do not have permission to view this directory. Code:
How can I write an asp page, say, CHECKIP.asp that checks the incomin
requesting IP address and returns a protected page, based on th
checking result? That is, if the IP is a permitted address, the
presents a page, say, OK.asp. If the IP is not allowed, then send
REJECT.asp. Both OK.asp and REJECT.asp cannot be directly accesse
without going through the CHECKIP.asp.
I am a somewhat beginner in ASP. I would like 2 know how do I check whether a recordset, that was fetched from an MS-ACCESS database through a 'SELECT' query, is empty or not??
The scenario is that I m making a form where users can register for my message board. The form will take in all the details and pass on to another asp file which checks whether the username is already in use or not. If its in use then it says that Username in use else the page is displaying error.
I m using the following sql.
"select * from members where user='" & username & "'"
The error is something like record cannot be found. Either EOF or BOF or the record was deleted.
win 2k pro
sql server 2k
asp - vbscript
I got the below code from somewhere ages ago. I have a list of links on my site that link to other sites but I want to check if the link is a valid link automatically and if it fails after x checks (checks every 7 days) then to mark the link as a possible broken link
the below seems to take ages to process and was wondering if there is a better way to do the below. Code:
How to re-write this so it can error check for each individual field. Username, email, password etc.
This is written and validates if the user already has an account in the Database. then it returns the messaage below. But I would like to indentify if it is the username that exist or the email or password. Code:
i wanted some help in the bewlo subject i tried in different code but some time it is showing wrong error.is anybody give me the example or site linke where i can donwload the the password checking script from database.
I have pulled data from database and shown those user name in suer tab ( drop dwon box) user need to select the his name and to type password.once user type the password it should check with database . if it exists then it should capture that user name and move on to next page.
I have a simple question. Can you check if a number has been passed through a form? For example I making a website for a property letting company and they upload the property themselves. But if you you put in text into the rent field, it throws up an error when adding to database obviously.I do validate the in put before adding it to the database so was thinking about another IF statement checking that a number was entered before they get as far as adding to the database and throwing up errors
View Replies View Related