[SOLVED] proper name format (first letter capitalized)?

Hello,

This is a very insteresting topic !
I would like to know how to adapt your auto action in order to have all the letters of the lastname in uppercase.
I tried this query : but it didn't worked...
Thank you very much for your help !
Kind regards,
Etienne

Your query looks fine. Your auto action is probably misconfigured and not firing though.

Hello,
Thank for your reply.
Please find attached a screenshot of the configuration of this auto-action.
If you find something wrong, I would be happy to find the solution...
Thank you very much !

You have 2 queries in the same auto action but they're not separated with a ; followed by a linebreak. Please end your first query with ; then press enter/return and start your next query.

Hello,
I changed the code in order to add the ';' but despite of these modifications, it doesn't work... I have the last version installed 3.1.0, and tested it with one query at once.
Here attached is a screenshot of the parameters of the auto action.
I even tested to define the sql database as external.
Do you have an idea on was is working wrong ?
Thanks a lot !
Etienne

Ah, I see an issue with your query. Please try the below.

In your query you've quotes around lastname, which is a column that wouldn't exist. Ensure you're testing with debug mode and maximum error reporting set in Joomla global configuration so such errors can be exposed.