Primary field validation

[mnongkhlaw]

Dear folks,

I have an ASP with fields bound to an Access database.

When I test the page by adding a duplicate primary key and clicking Save button, I get :

Error Type:
Microsoft JET Database Engine (0x80004005)
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.
/hardware/_ScriptLibrary/Recordset.ASP, line 311

How do I display a friendly message in lieu of the above and then return the user to the page with focus on the primary field's textbox?

Please help.

Mark
mark@shillong.meg.nic.in

 

[y2k1981]

maybe somebody in the ASP forum would be better able to help ?

 

[vbkris]

yup, this is an ASP question, u can use the error object...

Known is handfull, Unknown is worldfull

 

[mnongkhlaw]

Actually, I'm new to JS and I was looking for a client-side _onbeforeserverevent handler for the Save button. Can't such a thing be done in JS?

Mark

 

[clarkin]

Nope, those error messages are created as plain html files by your web server (eg IIS or Apache). It would be easier to modify said plain html pages to have the friendly error message built in, than to modify them to include script that did exactly the same thing.

Have a look at:

http://www.aspfaq.com/show.asp?id=2335

and perhaps:

http://www.aspfaq.com/show.asp?id=2162

and to a lesser extend:

http://www.aspfaq.com/show.asp?id=2109

Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].