duplicate message from my asp page

Posted: 02-16-2005, 02:43 PM
Hi..
Ok how could I create an insert pages that whenever it found any duplicate ID
like car registration number, DW page will prompt me an error message custom by
me, currently when I insert the duplicate id in my insert pages, IE will route
me to error pages with error as below

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'PK_Car_Plate'. Cannot insert duplicate key in object 'Car_Plate'.
/dua.asp, line 115

Reply With Quote

Responses to "duplicate message from my asp page"

CMBergin
Guest
Posts: n/a
 
Re: duplicate message from my asp page
Posted: 02-16-2005, 04:22 PM
Use the "Check New Username" behavior. You can check any field which cannot
be duplicated, not just usernames. It's under the "User Authentication"
menu in the server behaviors panel.

"samkry" <webforumsuser@macromedia.com> wrote in message
news:cuvpma$9n5$1@forums.macromedia.com...
> Hi..
> Ok how could I create an insert pages that whenever it found any
duplicate ID
> like car registration number, DW page will prompt me an error message
custom by
> me, currently when I insert the duplicate id in my insert pages, IE will
route
> me to error pages with error as below
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
> constraint 'PK_Car_Plate'. Cannot insert duplicate key in object
'Car_Plate'.
> /dua.asp, line 115
>

Reply With Quote
 
LinkBack Thread Tools Search this Thread Display Modes
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Output Error message...Bug? Bryce_Steiner@adobeforums.com Adobe Indesign Windows 11 04-19-2004 06:35 PM
Strange message when opening print dialog John_Darnell@adobeforums.com Adobe Indesign Windows 0 04-01-2004 07:34 PM
Error Message 1010 with Photoshop 6.0 Ann_Shelbourne@adobeforums.com Adobe Photoshop Mac CS, CS2 & CS3 0 02-10-2004 07:56 PM