Everett-
Thanks for the continued interest. The following MySQL command line does work:
SELECT `comment`FROM `modx_web_user_attributes` WHERE internalKey='1'
Below are the details of my work
Set up a Template Variable
Variable Name: comment-RT
Description: Template Variabelt to store rich text for Consultant comments to Clients
Input Type: RichText
Input Option Values: (blank)
Default Value: @SELECT `comment`FROM `modx_web_user_attributes` WHERE internalKey=’1’
Widget: RichText
Selected template allowed to access/process this variable
Created Chunk holding form to update profile {{update-profile-form}}
[+wlpe.message+]
<div id="wlpeUser">
<form enctype="multipart/form-data" id="wlpeUserProfileForm" action="[~[*id*]~]" method="post">
<fieldset id="wlpeUserProfileInput">
<div id="wlpeUserInfo">
<h3 id="wlpeProfileWelcome">Hello [+user.fullname+]!</h3>
<p id="wlpeProfileInfo" class="info">Use this form to update your profile information</p>
</div>
<legend class="display-none">Your User Profile</legend>
<label for="wlpeUserProfileFullName"><span>Full Name</span>
<input id="wlpeUserProfileFullName" class="validate[required,custom[onlyLetter],length[0,100]] text-input" type="text" name="fullname" value="[+user.fullname+]" />
</label>
<label for="wlpeUserProfileEmail"><span>Email</span>
<input id="wlpeUserProfileEmail" class="validate[required,custom[email]] text-input" type="text" name="email" value="[+user.email+]" />
</label>
<label for="wlpeUserProfilePhone"><span>Business number</span>
<input id="wlpeUserProfilePhone" class="validate[optional,custom[telephone]] text-input" type="text" name="phone" value="[+user.phone+]" />
</label>
<label for="wlpeUserProfileMobile"><span>Mobile number</span>
<input id="wlpeUserProfileMobile" class="validate[optional,custom[telephone]] text-input" type="text" name="mobilephone" value="[+user.mobilephone+]" />
</label>
<label for="wlpeUserProfileFax"><span>Fax number</span>
<input id="wlpeUserProfileFax" class="validate[optional,custom[telephone]] text-input" type="text" name="fax" value="[+user.fax+]" />
</label>
<label for="wlpeUserProfileState"><span>State</span>
<input id="wlpeUserProfileState" type="text" name="state" value="[+user.state+]" />
</label>
<label for="wlpeUserProfileZip"><span>Zip Code</span>
<input id="wlpeUserProfileZip" type="text" name="zip" value="[+user.zip+]" />
</label>
[*comment-RT*]
<!--Once this actually works I will use css so that the comment field will not be visible/editable to users.-->
</fieldset><!-- /wlpeUserProfileInput -->
<fieldset id="wlpeUserProfileButtons">
<button type="submit" id="wlpeSaveProfileButton" class="submit" name="service" value="saveprofile">Save</button>
<!--<button type="submit" id="wlpeProfileDoneButton" class="submit" name="service" value="cancel">Cancel</button> -->
<input type="button" id="wlpeProfileDoneButton" class="submit" name="service" value="Cancel" onclick="window.location.href='[~24~]';" />
<button type="submit" id="wlpeProfileLogoutButton" class="submit" name="service" value="logout">Logout</button>
</fieldset>
</form>
<button type="button" id="update-pw" class="submit" name="service" value="Update password" onclick="window.location.href='[~16~]';">Update Password</button>
</div><!-- /wlpeUser -->[!WebLoginPE? &type=`profile` &profileTpl=`update-profile-form` &profileHomeID=`24` &disableServices=`deleteprofile,register`!]
I find it confusing that I get the same results using the different Default Value for [*comment-RT*]
blank
[+comment+]
@SELECT `comment`FROM `modx_web_user_attributes` WHERE internalKey=’1’
@SELECT `comment`FROM `modx_web_user_attributes`
In all four instances any content that is saved in the admin panel "Create/edit web user" is visible on both the profile and update-profile pages. BUT if the update profile page is saved the content is removed from the database.
Thanks again for taking the time to help me:-)
~Jules
MODX Staff
☆ A M B ☆