Wiki articles tagged with "sql"

Showing 1-3 of 4 items.

What SQL-Statement creates yii?

Created 4 years ago by Necip, updated 4 years ago by Necip.

The usual way to find out what Yii has created for an SQL query is to mutilate the SQL in the sourcecode and call the program again so that the SQL statement with errors is displayed. Or you can use the SQL logger, which must be switched on and off each time and logs all SQL statements, which leads to an enormous slowdown in program execution and decelerates your workflow.

0 0
1 follower
Viewed: 11 358 times
Version: 1.1
Category: Tips

custom sql query results to CDetailView

Created 9 years ago by Kostas Apazidis (KonApaz), updated 8 years ago by Rohit Suthar.

This is a bried guide about displaying of custom sql query results.

3 0
Viewed: 44 292 times
Version: 1.1
Category: How-tos

Using a CDbDataReader (sql query result) in a zii widget (such as CGridView or CListView)

Created 11 years ago by Revelis Luc Bonnin, updated 11 years ago by Revelis Luc Bonnin.

If in your application you have to proceed to a complex SQL query that is not associated to a model, you will use CDbDataReader like it is described in the Yii documentation. An example could be

8 1
Viewed: 58 888 times
Version: 1.1
Category: How-tos