Sql Insert Command With Additional Options

Yii 1.1 General Discussion
1

Hi,

how to insert data to db with form generated by gii with additional option, e.g. UPPER.

Generally I’d like do some sql insert commands (save() methods) like INSERT INTO table(column_name) VALUES(UPPER(column_value)) on Postgres db.

Can I (if - how) do this in my controller code, in actionCreate method?

Many thanks in advance for any help!

2

As i understand you want to save some fields in upper case. You can do it in your model then.

You can use THIS for creating database commands.

3

Can you give me some example, please? :)