Register here!

Forgot password?

ASK NEW QUESTION

Home Page » sql

Questions tagged as "sql"

0 Votes

Best approach for working with joins and echoing out information

ARquerybuildersql

Hi,

I’m new here so apologies if this question’s answer is simple. If I have a list of questions in a questions table and each row of data has aREAD MORE

By Yiibie in Active Record · Asked 110 days 23 hours 24 mins ago

Questions: 1 Accepted: 0 ( 0% ) | Reputation: 0

0 Votes

Many-Many CRUD Generation

crudgiiGiixmany-manysqlyii

I’m really struggling trying to find a tool that does CRUD generation on my database that has some many-many relationships.

For example, I have a table A which has a many-manyREAD MORE

By sarink in Active Record · Asked 518 days 3 hours 13 mins ago

Questions: 1 Accepted: 0 ( 0% ) | Reputation: 0

0 Votes
Solved!

Complex SQL

ACTIVERECORDsql

What is a good way to incorporate the following complex SQL into a Yii application?

  1. select * from (
  2.    SELECT * FROM (
  3.       SELECT * FROM tbl_extradata ORDER BY field1 DESC) AS s
  4.    GROUPREAD MORE

By mminnie in Active Record · Asked 524 days 7 hours 8 mins ago

Questions: 1 Accepted: 0 ( 0% ) | Reputation: 0

0 Votes
Solved!

CActiveDataProvider SELECT only some fields

cactivedataprovidercactiverecordjoinsql

How to make CActiveDataProvider to SELECT only some fields from the query. For example :

  1. new CActiveDataProvider($model, array(
  2.   'criteria'=>array(
  3.      'select'=>array(
  4.           't.field1',
  5.           't.field2',
  6.      READ MORE

By phreak in Active Record · Asked 596 days 10 hours 54 mins ago

Questions: 1 Accepted: 0 ( 0% ) | Reputation: 0

© YiiAnswers.com 2011. All rights reserved.

Switch to our mobile site