I have a very simple login page which takes an ID number via a HTML form GET. What is easiest way to check that ID number against an Access DB to see if it exists? I want to redirect with the ID in the query string if it does exist and have them re-enter if incorrect.
View RepliesI made an asp that I insert records in an MS Access Database. I do insert them allright. But I want to check before inserting if this customer already exists. I try to do that by checking lastname and name (p_eponimo and p_onoma) but seems not to work ....
View Replies View RelatedI have a directory website which is having more than 20000 company details. Anyone can search the directory for the company. Everything works fine, but if someone misspells the word it returns 0 company found.
So i want to add a spell checker to the word user types in the textbox to the companies in the Access database. I need something similar to the google search.
I'm trying to query an Access database with an asp page hit with a hidden form from an ecommerce site. It was working fine until I added a new variable ("speed"), and now I get the following error: Code:
View Replies View RelatedI have an Access table with (among others) a number type field.
I'm building a web form which will add a new record to the same table. My problem is as follows:
I need to retrieve the (number) value from the previous record and increase it by 1 when submitting the new record. Also, this number should reset to 1 whenever a new year occurs.
Was that clear?
what is the easiest way to display Yes/No, True/Falst, On/Off MS Access fields as check marks on an ASP page? it would be either checked or unchecked.
View Replies View RelatedI have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
View Replies View RelatedI need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
View Replies View Relatedhere is the scenerio
in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003
Now each master batch can have multiple final mixed batch like
200701-0001-01
200701-0001-02
200701-0001-03
and this record is inserted in to fmix table.
so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,
how to achieve this
so in short each master batch will have more than one final mixed batch.
pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.
I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.
How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
View Replies View RelatedI'm working on a "hybrid" application some classic ASP, and some
asp.net. I'm trying to develop a support type page that checks necessary
components, database connections etc.. last item is to check for the .NET
extensions. Is there a way to do that from a classic ASP page?
I am working on a website that requires a login before accessing an appointment book application written in ASP.Basically what I want to do is when the customer first clicks on "appointment_book" link, it takes them to the registration form. After they are registered, It will then redirect them to the actual application.
I also want the same thing to happen when a customer clicks on the login link. I want them to login, then get redirected to the appointment_book.
at the moment the customer click on the registratration link and it shows them the registration form, they are then automatically logged in after registration. However, when I click on the Appointment_book link again, it brings me back to registration form. How can I have the link always point to the appointment book after they are registered or logged in?
let say:
http://www.domain1.com/index.asp?url=http://www.xxx.com/file.asp
can i restrict that only domain1.com can access to http://www.xxx.com/file.asp page?
so when user suft http://www.xxx.com/file.asp, they unable to view the content.both domain is on diff IP.
I have a form with several check boxes.they are all set to default to "unchecked."The db also defaults to unchecked.But,as soon as we hit the "form1.recordset.addnew" all of the cb's change themselves to "checked."?
Does anyone know of any nice ready made asp scripts to check a website's visitors age? I mean the sort of thing you see where you have to choose your day, month and year of birth from drop down lists to comply with US laws Code:
View Replies View RelatedI'm trying to guard against SQL injection, but I have an ID number being embedded into a querystring for MSSQL table selection.
Is it good enough just to check if the querystring value is an int, if so could you quickly remind me how to check that. In PHP we use is_numeric or is_int.
I moved an ASP app to a new Win03 server. The sendmail function using CDO in all ASP appls suddenly stopped working. It worked fine on the previous server (also Win03/IIS6.0). Where should I go to check?
View Replies View RelatedI would like to check if a website is currently down, but don't know how to do this efficiently. I do not have access to the remote server. I have tried using XMLHTTP, and it worked, it just took a long time and I felt it wasn't effecient enough. Is there some other way to check if the website is up or not using ASP?
View Replies View Relatedhow to check any value in asp that it is null or not.
View Replies View RelatedI have a form that has simple vaidation but how do i check to make sure there is and email in the email section.
View Replies View RelatedHow can I check that entered value in a text box is numeric or not in next page?
View Replies View RelatedI have a form that a user submits their clan's website, and roster page.
What I want to do, is check to see if the field submitted contained
"http://" and if not, add it to the field submission.
I know i can make this easier, and put the http:// in the field as a default
value, but i want to know how to do this with a bit of form validation or
something.
I have a signup form.
I would like to be able to check for duplicate entries during the signup.
E.g. Check for duplicate
1. Usernames
2. Phone numbers
How could this be achieved ?
My code basically is two fold.
1. A recordset that checks
if not recordset.bof and not recordset.eof then
'do something. And redirect to say the value exists
end if
2. Run a SP to do an insert and authentication
I've got a page that displays product details. One of the fields in my products table is called Include and is set to Yes/No. I use this to distinguish when I want to add that particular record to a recordset and when I don't. For example, I may have 20 products with the name Ash in them and create a recordset which pulls in all Ash products. However, I only want to pull them in when Include is set to Yes (the others aren't ready yet.)
I'm using Dreamweaver and I've setup my product details page to include that Include field with a checkbox. It checks the box if the Include field is set to True. What I would like to do, though, is be able to then uncheck that box and have it update that field to False, or No. Right now, when I uncheck the box and submit the form I can go back in and it's still showing up in that recordset and the box is still checked when I go to the details page.
i know how to code it in javascript but failed to do it in asp. there are 12 digits of number. exmple like this 871205106599. i want to check every single digit when user clicks Submit button.
View Replies View Relatedwhen i set the checkScore1 to 100 or higher in the table field, the if else condition became FALSE? But it work for 70 to 99 ??
If checkMaxAttempt = "2" AND checkScore1 >= "70" Then
response.redirect "error.asp"
'last attempt check
ElseIf checkMaxAttempt <= "1" AND checkScore2 >= "70" Then
response.redirect "error.asp"
ElseIf checkMaxAttempt <= "0" Then
response.redirect "error.asp"
Else 'do nothing
End If
I have a form and iwant to check if the password which gives the user is between 3 to 6 characters "alpanumeric" there is something in asp code to do this?
View Replies View RelatedIs there any If statement to check browsers?I want to check IE6, IE7 and Firefox.
View Replies View RelatedI have the following ASP...
set dbconn = server.createobject("ADODB.connection")
dbconn.open "dsn=news;uid=hello"
After the dbconn.open, how do I check if the dbconn.open has an error?
e.g. if dbconn has error
do something
I want to use the session check in this The drawback of this page is that anyone can click any no. of time on the options of the poll. So, I want to put a session check so that only once can a person tick the answer. How can this be done?
View Replies View RelatedIn my functions I'm using a double-check all the time to trap if a value has
nothing in it and my question is do I need this double-check.
My check line is:
IF IsNull(xxx) OR LEN(xxx) = 0 THEN
blah blah
ELSE
blah blah
END IF
xxx is usually an array built up of data from an ADO recordset so will
LEN(xxx) = 0 cover my zero values or do I still need the IsNull check as
well?