Want to Use Custom Validator To Check for Duplicate Record

[Mike Moore]

We have 3 fields on our web form that makeup what could be a duplicate entry.
We would like to look at these three fields that the user enters and check
in the database to see the information in all three fields matches
information in the database. Can you do this in a custom validator?

[Curt_C [MVP]]

Sure you could... Give it a whirl and let us knwo where you get the
problem/issue.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Mike Moore" <Mi*******@discussions.microsoft.com> wrote in message
news:60**********************************@microsof t.com...

We have 3 fields on our web form that makeup what could be a duplicate
entry.
We would like to look at these three fields that the user enters and check
in the database to see the information in all three fields matches
information in the database. Can you do this in a custom validator?

[Mike Moore]

How? We would like to have the message also displayed in the summary
validation.

"Curt_C [MVP]" wrote:

Sure you could... Give it a whirl and let us knwo where you get the
problem/issue.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Mike Moore" <Mi*******@discussions.microsoft.com> wrote in message
news:60**********************************@microsof t.com...

We have 3 fields on our web form that makeup what could be a duplicate
entry.
We would like to look at these three fields that the user enters and check
in the database to see the information in all three fields matches
information in the database. Can you do this in a custom validator?

[Lucas Tam]

"=?Utf-8?B?TWlrZSBNb29yZQ==?=" <Mi*******@discussions.microsoft.com> wrote
in news:9A**********************************@microsof t.com:

How? We would like to have the message also displayed in the summary
validation.

Search the database. If there are multiple records, set Args.Isvalid =
False.
You can do ANYTHING in a custom validator. It basically executes any code
you place in there when a validation is called. Technically it doesn't even
need to do validation... you could use it for logging or whatever.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Mike Moore]

are you suggesting to have one custom validation or to validate on each of
the three fields?

We would like to have a red askerisks appear beside the three fields if a
duplicate record is found in the database. We would also like to have the
duplicate message displayed in the summary validation control.

"Lucas Tam" wrote:

"=?Utf-8?B?TWlrZSBNb29yZQ==?=" <Mi*******@discussions.microsoft.com> wrote
in news:9A**********************************@microsof t.com:

How? We would like to have the message also displayed in the summary
validation.

Search the database. If there are multiple records, set Args.Isvalid =
False.
You can do ANYTHING in a custom validator. It basically executes any code
you place in there when a validation is called. Technically it doesn't even
need to do validation... you could use it for logging or whatever.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Lucas Tam]

"=?Utf-8?B?TWlrZSBNb29yZQ==?=" <Mi*******@discussions.microsoft.com>
wrote in news:B3**********************************@microsof t.com:

are you suggesting to have one custom validation or to validate on
each of the three fields?

We would like to have a red askerisks appear beside the three fields
if a duplicate record is found in the database. We would also like to
have the duplicate message displayed in the summary validation
control.

Is each text field a separate validation? If so, I would use 3 validators.
Two reasons: 1. Errors will be displayed in the validation summary. 2. The
askteriks will be displayed automatically.
You could use 1 validator - in this case just put a label beside the other
fields and set the text to *. However, placing error text into the
Validation Summary maybe more difficult.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Mike Moore]

Another thing to mention is that it works when we have the summary validation
property set to showmessagebox = false, but we need it to be set to true. It
might be the way we are doing the validation. we have custom validation
controls that are set to false until are code runs and then sets them to
true, but the message box doesn't get displayed.

any suggestions would be helpful?

"Mike Moore" wrote:

We have 3 fields on our web form that makeup what could be a duplicate entry.
We would like to look at these three fields that the user enters and check
in the database to see the information in all three fields matches
information in the database. Can you do this in a custom validator?

[Mike Moore]

thanks for your suggestions.....

"Lucas Tam" wrote:

"=?Utf-8?B?TWlrZSBNb29yZQ==?=" <Mi*******@discussions.microsoft.com>
wrote in news:B3**********************************@microsof t.com:

are you suggesting to have one custom validation or to validate on
each of the three fields?

We would like to have a red askerisks appear beside the three fields
if a duplicate record is found in the database. We would also like to
have the duplicate message displayed in the summary validation
control.

Is each text field a separate validation? If so, I would use 3 validators.
Two reasons: 1. Errors will be displayed in the validation summary. 2. The
askteriks will be displayed automatically.
You could use 1 validator - in this case just put a label beside the other
fields and set the text to *. However, placing error text into the
Validation Summary maybe more difficult.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Mike Moore]

We have it working now, but the only problem is that the message box doesn't
pop-up. Would there be any reason why this is happening?

"Lucas Tam" wrote:

"=?Utf-8?B?TWlrZSBNb29yZQ==?=" <Mi*******@discussions.microsoft.com>
wrote in news:B3**********************************@microsof t.com:

are you suggesting to have one custom validation or to validate on
each of the three fields?

We would like to have a red askerisks appear beside the three fields
if a duplicate record is found in the database. We would also like to
have the duplicate message displayed in the summary validation
control.

Is each text field a separate validation? If so, I would use 3 validators.
Two reasons: 1. Errors will be displayed in the validation summary. 2. The
askteriks will be displayed automatically.
You could use 1 validator - in this case just put a label beside the other
fields and set the text to *. However, placing error text into the
Validation Summary maybe more difficult.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Lucas Tam]

"=?Utf-8?B?TWlrZSBNb29yZQ==?=" <Mi*******@discussions.microsoft.com>
wrote in news:62**********************************@microsof t.com:

We have it working now, but the only problem is that the message box
doesn't pop-up. Would there be any reason why this is happening?

If you have the new IE service pack loaded, it blocks pop-ups.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/