Fixer
Posts: 18
|
| Posted: 12/17/2004, 4:32 AM |
|
New to this awesome application- learning as I go. I can create a grid form with fields from a table from my hosted MySQL. One field is a y,n - That is the only field that I want users to be able to change- do I set up the rights at MySQL, CCS, or both. How and where in CCS do I define which fields are editable- also, when looking to build a login screen and setup authentication- can I just import users from MySQL somehow.
|
 |
 |
peterr
Posts: 5971
|
| Posted: 12/17/2004, 12:01 PM |
|
I don't know if MySQL supports field-based permissions. In CCS you would use standard HTML approach, for example use the "disabled" HTML attribute (also available on the "Format" tab in properties). Or you can use Label instead of Textbox, so that the information is shown but not edited.
As for the login and users, you don't need to import users, just specify the user table in the security settings. Your Web application will read the user table at the time of login.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Fixer
Posts: 18
|
| Posted: 12/17/2004, 12:52 PM |
|
Great, thanks for the info- I must have been thinking about MS-SQL in terms of field permissions- By any chance, would you know how I can trigger an email to go off if a field value is changed? If not I can start a new post, I'm sure there is a way.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/17/2004, 1:02 PM |
|
There may be couple or more ways to do this, such as:
1. Server based: in "Before Update" event use the CCDLookup function to lookup the field value before it is updated, then send the email if it doesn't match the currently submitted value.
2. Client+server based: create a non-bound hidden field and use some JavaScript that will change its value when another field's value is changed. Then in the program use the "Before Update" event to read the hidden field's value and send the email accordingly.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Fixer
Posts: 18
|
| Posted: 12/20/2004, 4:04 AM |
|
thanks- I'll give it a shot.
|
|
|
|
|
