[SOLVED] Auto action to store a value into DB using code action

I have a drop down field that contains city values

Some of those cities names are something like "Pomigliano d'Arco".

I need to convert those cities names in a SEF way like "pomigliano-d-arco". I need that 'cause I use another auto action to redirect to a GJ group where the redirect link is www.mysite.com/ [city]

Now if I use [city] as substitution I have a link like this: www.mysite.com/Pomigliano d'Arco instead of www.mysite.com/pomigliano-d-arco

Is there a way to do this? Maybe with another auto-action code that convert the [city] value in a SEF way and then store it into another cb field ?

Thanks

Up to previous post, can I use a cb query field to convert city field valued in a SEF way?

Yes, use CB Query Field to query the database for the field then you can use SQL functions to format it however you need.

I've creted the CB query field and it seems work fine but I can't transform to lowercase words. I've used this statement:

If I do not use LOWER ( .... ) everything works fine. How can I lowercase all words in this expression?

Enable debug mode and maximum error reporting in Joomla global configuration then view anywhere the field is displayed to see if a fatal SQL error is present.

I got this error 1305:

FUNCTION mydbname.LOWER does not exist SQL=SELECT LOWER ( REPLACE ( REPLACE ( REPLACE (`cb_city`, '\' ', '-' ), '\'', '-'), ' ', '-' ) ) FROM `jos_comprofiler` WHERE `user_id` = '885'

ADD

Now I got this error 1064:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT LOWER ( REPLACE ( REPLACE ( REPLACE (`cb_city`, '\' ', '-' ), '\'', '-'' at line 1 SQL=SELECT SELECT LOWER ( REPLACE ( REPLACE ( REPLACE (`cb_city`, '\' ', '-' ), '\'', '-'), ' ', '-' ) ) FROM `jos_comprofiler` WHERE `user_id` = '885'