Error Handling-duplicate Key
when I try to insert a duplicate record I get the primary key error. which
is good. but I want to generate a user friendly error ... telling the user
that u have got this error because u r trying to insert a duplicate record.
i can simply do so by using "on error resume next"....
this is what I do:
"on error resume next server.transfer("error.asp")"
the problem is it simply takes me to a page where I display an error has
occurred... it doesn't look attractive to display a one line error in a big
page? I hope I am clear....
1. how can I display the error message in my error.asp
2. I can I make it look better... how is error handling done ???
Code:
View Replies
ADVERTISEMENT
I have a booking form, called classroomform. On this form the user requests a classroom number, location, date, start/end time and number of students.
As it stands, the data is submitted via a submit button and an insert query created using Dreamweaver.
I already have various validation on the form, such as javascript which error checks for invalid times etc and asp validation which checks for correct dates etc.
However, the final touch that I'm looking to do is to add some code to the form which checks for duplicate entries that are in the database. I basically want an error check which doesn't allow the user to enter a duplicate record that is based on classroom number, location, date, start/end time.
Here's my code: ...
View Replies
View Related
How do i do error handling using asp. Like taking an example i am getting this error on trying to save a record twice whihc has a primary key constraint:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
how can i handle such cases and where do i place the code???
View Replies
View Related
I want to error handling in ASP. But i think that ASP is not enough for
error handling. I have got two chance.
1. I can prapare an error page and control throught IIS.
2. I can use on error resume next.
For 1. This is a general handling. I want to handle local error. Maybe i do
special thing when error occured.
For 2. I have to write alot of lines code. I have to control every line.
View Replies
View Related
Is there a possiblity that, when an error comes in asp page in server, especially with sql script, to hide that error from user and display just Error, report to admin,
i just want to make a general case where when an error comes i should take the page to report to admin.
View Replies
View Related
How i can handle the errors in ASP. Please suggest something.
View Replies
View Related
how i can handle errors on ASP page. Actually i want to maintain a ErrorLog in Database and want to redirect the user on an Error.asp page where i can show him the error details(i-e error #,Description etc).
I have found "With Endwith" method to handle errors but the problem is that i can only write it with a record set and it will handle only record set related errors and also i have to write With EndWith with each recordSet but i want to handle any error on page at a single place.
View Replies
View Related
what this code doesnt work?
<%
on error goto errhand:
exit sub
errhand:
response.redirect("error.asp")
%>
View Replies
View Related
I have a script that takes gathered customer data, sends it to the gateway (ecommerce site), then takes the response from the gateway and redirects or prints out any errors (invalid CC number, declined etc.). Code:
View Replies
View Related
I am am using WDDX.Deserializer.1 to parse some XML data to display on an ASP page. Occasionally, I get an error like this:
Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'deserialize'
/includes/sidebar.asp, line 25
Line 25 is:
set MyRs = MyDeser.deserialize(content)
I would like to set up some error handling so that if this error occurs it will display a custom error message rather than this one. Right now this message occurs near the top of each page on the site, in effect crashing the whole site. How can I test this to see if an error will occur?
View Replies
View Related
I inserted an error handling code for the code bellow. What happen is
the page is taking a long time to load. Upon loading it takes me to
"page not found" of microsoft internet explorer. How do I solve the
problem? Code:
View Replies
View Related
When a user tries to visit a non-existant page in our web site they receive a custom 404 error message. I want to capture the URL the user tried to visit. Does anyone know where I can find this string?
View Replies
View Related
how can i put the error messages in HTTP 500.100 - Internal Server Error - ASP error page in a nicer way so that it suits my web design.. ?
View Replies
View Related
I have an error handling routine that emails me the Err.Source, Err.Nbr, and Err.Description in the event of an error. How can I include the line number of the error as well and the filename?
View Replies
View Related
Is there an elegant way to check for the REFERENTIAL INTEGRITY VIOLATION in Access via ASP. The reason I ask is that if the user attempts to refresh the screen after implementing an INSERT he will be trying to insert an identical record which thows up the following error (below).
I could place On error resume next before but I find this dangerous or am I overworrying. I could preface the insert by doing a check for the record but this creates longer code which warps my anti-debugging frame of mind :) - is there a better way? Code:
View Replies
View Related
i am coding in VBScript. i am coding for an online survey. Fr error handling (eg if the user forgets to fill out a field), is it possible to ensure all fields have been filled out BEFORE clicking the submit button? i wish for the user to be notified via a MESSAGE BOX, how would i go about this(using VBScript)?
View Replies
View Related
I currently use this for my error handling in XML HTTP... Code:
On Error Resume Next
If NOT xmlHttp.readyState = 4 then:xmlHttp.waitForResponse = 5:End if
If err.number then
response.redirect("error.asp?error=2&pg=" & Current_page_URL)
else
If xmlHttp.Status <> 200 OR NOT xmlHttp.readyState = 4 then
response.redirect("error.asp?error=2&pg=" & Current_page_URL)
Else
'content here (no error)
end if
But when the site I am gathering data from is down, then I get an error saying that It cannot connect to the server. How can I error handle this error?
View Replies
View Related
Error is:
Subscript out of range: '[number: 0]'
or
Subscript out of range: '[number: 1]'
or
Subscript out of range: '[number: 2]'
This is correct in that the variable is empty if user does not fill in correctly. However how do i stop it falling over and just get it to error handle?
e.g. If Subscript out of range: '[number: 2]' empty how do I 'know' this without an error? Code:
View Replies
View Related
If I try and add a record with a duplicate primary key I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. Code:
View Replies
View Related
I am having trouble, with Error Handling.. I have a ICMP ping utility in VBScript, it works fine if there is a proper reply but will create an error if the IP or DNS name is unknown, Can someone look through the code and see if theres a way I can catch the Error and display say "REQUEST TIMED OUT" Code:
View Replies
View Related
I can't seem to get error handling to work from inside my classes. On the outside it works but on the inside it doesn't. Any thoughts?
if err.number <> 0 then response.write "errors" end if
I'm trying to catch all the errors as I go and I can't do that if it won't work on the inside of my classes.
View Replies
View Related
i'm trying to incorporate error handling into my application, but i've run into a dilemma.
i've already performed 10 successful INSERTS, but on the 11th INSERT, the application fails for some reason (say for example, i tried to perform an INSERT into a table that doesn't exist). logically, i should stop execution and display some sort of error message. but, i've already ran a bunch of INSERTS so what do i do?
View Replies
View Related
I am calling some stored procedures from ASP. These strored procedures have to deal with lots of deletes and updates. So i have thought of implementing transaction commits and rollbacks.
But if a rollback occurs in these stored procedures, i want to get a value back to asp page, based on this value i will run the next stored procedure.
View Replies
View Related
I want to capture err.description into asp variable when any error occurs in the pages as a whole. Suppose some error occurs at the top of the page say ADO Block.
Can it will travel till page end, or can every error necessarily stop the proceedings and throw error resulting page crash. My ultimate aim is to capture error in asp variable when ever crashable error occurs. How to capture it. Code:
View Replies
View Related
i'm trying to incorporate some error handling into my web app,
but i'm not sure how to go about it in this case.
say for example, i already ran 10 INSERTS, then on my 11th INSERT,
something fails (perhaps trying to perform an INSERT into a table that
doesn't exist). logically, i should stop execution of the page and
display some sort of error message. but, since i've already run 10
successful INSERT queries before the error occurred, what do i do
now?
View Replies
View Related
I am facing some problems for the database query.
Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. How to do the error hanndling, if certain record cannot be found in the database? If possible, please show the coding.
View Replies
View Related
I need to know how to handle errors if a write to the database fails. Here's the pseudo-code:
View Replies
View Related
How to do the error handling if the users key in character into integer text field? If possible, please give example and show me the coding.
View Replies
View Related
when i want to insert my data into my table but i encounter the following error
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Violation of PRIMARY KEY constraint 'PK_sDetail'. Cannot insert duplicate key in object 'sDetail'.
/fsearch/InsertTable.asp, line 153
sql = "Insert into sDetail values('" & semyear & "','" & sem & "','" _
& modulecode & "','" & tutorial & "','" _
& semday & "','" & startTime & "','" _
& endTime & "','" & location & "','" _
& roomno & "','" & tutor & "')"
oConn.execute sql 'line 153
how to solve this error can anyone help ?
View Replies
View Related
For example, now my 1st page is a search page, i use it to search for all records that has the same Business_unit, so it goes to a second page where a table of the records is shown.
Now this page has a link to a 3rd page, where i wan an exact duplicate of the second page, is it feasible, is there anyway to display the exact saem table on the 3rd page?
View Replies
View Related
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
View Replies
View Related
My table in the database may contain duplicate records, which means except
the primary key (auto_increment) field is unique, all or almost of all the
fields are with the same content. How can I select them to display and
delete them?
View Replies
View Related
I 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 Related
