Modify the value of createdByUserNum

Oops !!! [blush]

Excuse my question, I found the answer.

In section Admin > Advanced Commands...

Djulia

It's not editable, but here's some ways you can do it.

One simple way, is to just copy and paste and create a new record as the new user. That's not always practical though.

Another way is to use a MySQL editing program and change the value of the createdByUserNum field to a different user num.

And a third way would be as follows:

- Make sure you are logged in as an admin user with 'admin' access to 'All Menus'.

- Find the user number of the 'new' record owner by mousing over (or clicking) the modify link for their account under "User Accounts". The user number will be displayed in the url.

- Go to the section you want to change in the Section editor

- Enable "System Field Editing" (bottom left under "Advanced Commands"

- Edit "createdByUserNum" and change the field to "createdByUserNum2" with type "textfield"

- Go edit the records you want to change. createdByUserNum2 will show up as a text field and you can change the user number.

- When finished, go back and rename the field back to "createdByUserNum" with type "none"

Hope that helps, let me know if that works for you.

Thank you Dave, [:)]

Oops ! I think that simplest is to employ a MySQL editing program.

Thanks,

Djulia

Another question.

You can give the values ?

0 == ???
1 == ???
2 == ??? (admin)
3 == ??? (user)[/#0080c0]

Thanks, [:)]

Djulia

If you can, that's _definitely_ the simplest! :)

I use 'MySQL Query Browser' for that. It's free, runs on my desktop, and by the MySQL folks. phpMyAdmin is good for that too. Not all web hosts let you connect remotely to MySQL.

If anyone wants to check out MySQL Query Browser you can here:
http://www.mysql.com/products/tools/query-browser/
http://dev.mysql.com/downloads/gui-tools/5.0.html