close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Default value for registration

Thread began 5/25/2012 5:53 pm by h150477 | Last modified 5/29/2012 9:46 am by Jason Byrnes | 514 views | 2 replies |

h150477

Default value for registration

Registration on my site is done by a person other than the one being registered. Eleven people all belonging to different clubs are registered as editors for their club.
They are only allowed to register new members for their club. Each registered person has a club_index field that points to the index field in the clubs table.
So the editor logs in and goes to the registration page and enters the registration information for his new member.
Using the standard registration page, with minor modifications to use a menu for the user level, I can get the page to work - but with no club_index.
A new user can only be registered to the club to which the editor belongs, so a session variable supplies the club_index shared by both the editor and the new user.
This club_index does not change, and as far as I can see, it should not need to be validated, as it is provided by the system.
So how do I get this session variable's value transferred into the club_index field of the newly registered user?

On a none SA form, I would usually set the value of that field to a hidden field on the form, and the session variable would be bound to the club_id field in the insert record behaviour.
However, this does not seem to work in SA or I am doing it wrongly, as all the fields on the form change from yellow to green.
When I click the submit button, I get the "Invalid information, please check your entries and try again."
All entries are correct as no other validation errors are shown, yet this error still persists, so it must be a problem with the hidden field. Gets a bit wearing after a while.
I could just insert the user without a club_id and then do an automatic update it on the next page, but that seems to defeat the object.
Just what is the purpose of the hidden field in SA? How can one use it? There is no documentation for this item anywhere that I can find, and it obviously needs some.
All suggestions welcome.

Sign in to reply to this post

h150477

Still no answers, but there is a solution to the problem in part - after some 12 hours plaaying with SA.

To pass a single value using the standard SA registration form, create a stock dreamweaver recordset containing a single value.
Like select club_index, club_name from clubs where clubsession = 2
Then populate a menu with the single value within the recordset.
Bind the insert record field to the recordset field and you have done.
It looks like a drop down list but it only contains one value. Must be a better way but it will have to do for the moment.
If you need to register someone from the admin side, all that is is needed is copy the file and widen the scope of the recordset to include more options in the copy.

Still don't know how the SA hidden field is used. Should just be able to bind the session variable to it but ......?

Sign in to reply to this post

Jason ByrnesWebAssist

  Still no answers,  



You post was made late Friday evening, WE are available Monday - Friday 9am to 5pm PST, except for major US holidays. Monday was the Memorial Day Holiday.

the default value should be set directly in the Database.


In the database, select the column and set the default value to whatever you like. the attached screenshot is an example of using PHPMyAdmin to set the default value of the UserEmail Verified column to 0.

By setting the default value in the database, you don't need to bind that column to anything in the insert record behavior.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...