User Registration Form Full

I am trying to add one additional field to the "users_Registration_full.php" file. All I want is a field for entering a company name. I have already added "userProperty" to the ps3_users table, and I know that I did that part right, but I can't seem to get the insert to work. What am I doing wrong here?

<p>
<label for="UserProperty">First Name:</label>
<span id="sprytextfield20">
<input name="UserProperty" type="text" class="WAATKTextField" id="UserProperty" onBlur="if (document.getElementById('firstNameServerValidation')) document.getElementById('firstNameServerValidation').style.display='none'" value="<?php echo(ValidatedField("usersRegistrationfull","UserProperty")) ?>" size="32" />
<span class="textfieldRequiredMsg">A value is required.</span></span>
<?php
if (ValidatedField("usersRegistrationfull","usersRegistrationfull")) {
if ((strpos((",".ValidatedField("usersRegistrationfull","usersRegistrationfull").","), "," . "11" . ",") !== false || "11" == "")) {
if (!(false)) {
?>
<span class="textfieldServerError" id="firstNameServerValidation">
Please enter your first name. </span>
<?php //WAFV_Conditional users_Registration_full.php usersRegistrationfull(11:)
}
}
}?>
</p>

you will need to edit the Insert Record Behavior on the registration page using DataAssist to bind the new form element to the new database column.


With DataAsisst installed, open the server behaviors panel, Window -> Server Behaviors, then double click the insert record server behavior to edit it.

Dont change anything on the first page, click the next button, on the second page, select the database column, then click the lightning bolt icon next to value and select hte new form element.

Thanks Jason,

What's the best way to create the new form element. The first time around I simply copied all of the code for the First Name entry and pasted it, then changed the code to what I pasted into my first post here.

Matt

place your cursor where the element should go then go to Insert -> Form -> Text Field.

What if I want to duplicate the same type of Spry validation that the rest of the form has?

place your cursor where the form element should be added then go to Insert -> Spry - > Spry Validation Text Field

I am considering redoing all of my registration, login, logout forms, etc. using Security Assist but I wanted to ask if doing so could damage my Power Store 3 in any way. The following pages came supplied with all of the necessary forms, but I need a bit more customization.

users_Confirm.php
users_EmailPW.php
users_LogIn.php
users_LogOut.php
users_Profile.php
users_Registration_full.php

Would it be unwise to delete everything from the Main Content areas of these pages before starting from scratch with the Security Assist Wizard? Or should I leave that content there until after I run the wizard?

Also, in the Security Assist tutorials the database used has a user level access table, but the database for Power Store is slightly different, with the user access defined in the ps3 users table. Is there anything I need to do differently?

Sorry for the not so educated questions. My brain takes to graphic design much more readily than PHP code.

Thanks for your help!

no, do not recreate the pages using the wizard, instead you should edit the server behaviors on each of the pages to add the additional fields.


user level is defined in PS3 the same as the tutorial, the user levels are defined in the usergroup table, and related to the users table using the UserGroupId Column.