Validating a 'like entry'

Dear Jason, firstly Happy New Year. I have a form that can only be submitted if the person enters a pin. The pin is contain in a table called pin - it has only one entry in the table - the actual pin number.

Only invited guests can submit the form - but they need to know this pin - and they will be issued with this pin number.

Problem 1
The pin is setup to validate against the pin number in a recordset. It works in that the form doesn't process if the incorrect pin number is entered in the field, but no client-side validation or server side tooltip appears for this field, so the user is unclear as to the error. The tooltip only appears if the user types nothing into the field.

Any suggestions?

I have attached a screenshot of the form and the php page.


Problem 2

To keep my submit buttons consistent i changed the code from:
<input class="formButton" name="SimpleContact_submit" type="image" id="SimpleContact_submit" src="webassist/forms/fd_sharp_default/submit.gif" onclick="clearAllServerErrors('SimpleContact_Sharp_Default')" />


to

<input name="Clan_submit"
type="submit"
class="Sharp2"
id="Clan_submit"
value="Submit"
onclick="clearAllServerErrors('SimpleContact_Sharp_Default')" />

But when I do this it won't process the form

1) The like entry cannot be processed client side since it uses a recordset, it can only be processed server side.

the Validation Show if you added for showing the server validation message is set to trigger on the required validation for the pin, you should change it to trigger on the Like entry validation instead.

2) The behaviors on the page are set to use a button named "SimpleContact_submit". By changing the name of the submit button, you are breaking the behaviors. instead of:
name="Clan_submit"

use:
name="SimpleContact_submit"

Thanks, a million - that worked very well with the pin number.

However, the submit button is now processing the form, even with the wrong answer to the security question. Funnily, it won't process if no answer is entered.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Okay, I'll logon to the ticket to deal with the submit problem.


After successfully dealing with the pin issue in the last few tag on this thread, I decided to add a pin field the registration form - the purpose is to limit people who can register (they must know the pin).

When a user enters the pin, it validates against a recordset containing the pin using the 'like entry' behaviour. It's works in the last example you sorted for me (see previous tags on this thread) - but it doesn't work here - I get the attached errors in the browser - see attached screenshot.

I've also supplied the zipped page.

the screen shot is to small to read.

I cannot make out the errors.

See attached pdf, for clearer view

move the following code from line 103:

<?php require_once("webassist/database_management/wa_appbuilder_php.php"); ?>

to line 1.

Brilliant - your great.

But just for future reference, how did that line of code end up there. Was that something I did or is that something that CSS Form Builder did?

no way to know the answer to that question.

i can only tell you that is was in the wrong place.

i was not there when you created the page, so cannot say how it got added in the wrong place.