Wiki articles tagged with "sql"

Showing 1-3 of 4 items.

What SQL-Statement creates yii?

Created a year ago by Necip, updated a year 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: 7 806 times
Version: 1.1
Category: Tips

custom sql query results to CDetailView

Created 6 years ago by Kostas Apazidis (KonApaz), updated 5 years ago by Rohit Suthar.

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

3 0
Viewed: 40 237 times
Version: 1.1
Category: How-tos

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

Created 8 years ago by Revelis Luc Bonnin, updated 8 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: 30 945 times
Version: 1.1
Category: How-tos