CSqlDataProvider class for Yii, that allows you to create data providers from custom SQL queries
Questions tagged [csqldataprovider]
20 questions
0
votes
1 answer
Yii- Caching with CSqlDataprovider
Is it possible to do caching of data from sql server queries when using CSqlDataProvider. If so can anyone please provide some links for documentation about it. Or if you have done it personally please guide.
I did a search but found nothing :(
neophyte
- 1,726
- 3
- 15
- 21
0
votes
1 answer
Yii Csqldataprovider works only for first page
This is a very strange situation to me. I have a CSqldataprovider to handle my pagination.
According to documentations and examples it works almost correct. It calculates correct the number of pages based on the totalitemcount and pagesize. It shows…
PimD1988
- 307
- 5
- 14
0
votes
1 answer
Yii Pagination Result using CSqlDataProvider
I am using pagination with CSqlDataProvider. Result is shown properly for the first 20 or first page of the pagination. When I see the Log message on the web page the query it uses is actually selecting top 20 rows for all the pages and that's the…
neophyte
- 1,726
- 3
- 15
- 21
0
votes
2 answers
using Csqldataprovider CGridView and CButtonColumn (Yii Framework) dont appear
i have got a gridview using the Csqldataprovider but then unlike CAtiveDataProvider default cButton column doesnt appear i did write the custom code to it
array(
'class'=>'zii.widgets.grid.CButtonColumn',
…
Tested
- 761
- 4
- 16
- 38
-1
votes
1 answer
Yii CSqlDataProvider with relations
I have an complex query with joins and conditions
and I get data with CSqlDataProvider
But I also need to join relational table records.
Lets say, we have table A (products) and table B (product_modifications)
I need to list products along with…
johnode
- 720
- 3
- 12
- 31