Search code examples
Convert SQL containing JOINs, a subquery, GROUP BY and SUM() to CodeIgniter's active record...


phpcodeigniterjoinactiverecordsubquery

Read More
SELECT query to COUNT qualifying rows from an indirectly related table with CodeIgniter's active...


phpsqlcodeigniteractiverecordcount

Read More
Impossible Rails Syntax: Order has_many with polymorphic association...


ruby-on-railsrubyactiverecordpolymorphic-associations

Read More
How to eager load associations with the current_user?...


ruby-on-railsruby-on-rails-3activerecorddeviseeager-loading

Read More
What is the purpose of the CodeIgniter's get() active record method?...


phpcodeignitermethodsactiverecordquery-builder

Read More
WHERE clause condition including CONVERT_TZ() and DATE_ADD() does not render as intended when using ...


phpmysqlcodeigniteractiverecordwhere-clause

Read More
rails model querying returns 11 records but no limit is set...


ruby-on-railsactiverecordlimit

Read More
CodeIgniter active record query to return rows where a column value is LIKE one of potentially multi...


phparrayscodeigniteractiverecordsql-like

Read More
Rails accepts_nested_attributes_for Error...


ruby-on-railsactiverecord

Read More
ORM Query results: Arrays vs Result handle wrapped in Iterator interface...


phpmysqlormactiverecordarrayiterator

Read More
How does this CodeIgniter pagination feature work?...


phpcodeignitermodel-view-controlleractiverecord

Read More
ActiveRecord find_each combined with limit and order...


sqlruby-on-railsactiverecord

Read More
Is it possible to change active record associations in memory without saving them to the database?...


ruby-on-railsactiverecord

Read More
How to implement a BETWEEN condition in a WHERE clause with CodeIgniter active record...


phpcodeigniteractiverecordwhere-clausebetween

Read More
constant enums in rails models and database...


ruby-on-railsactiverecord

Read More
With Rails, can I use a single table to store simple values (gender, hair color, eye color)?...


sqlruby-on-railsactiverecord

Read More
Convert SQL with subquery as part of JOIN's ON condition to CodeIgniter active record syntax...


phpdatabasecodeigniteractiverecordsubquery

Read More
Querying for date range in rails...


ruby-on-railsruby-on-rails-3activerecordtimezone

Read More
Rails—get a random record from db?...


ruby-on-railsactiverecordruby-on-rails-5

Read More
CodeIgniter select() method with two parameters only returns one column in result set...


phpmysqlcodeigniteractiverecordquery-builder

Read More
Enclose portions of WHERE clause conditions in parentheses with CodeIgniter query builder methods...


phpcodeigniteractiverecordquery-builderlogical-grouping

Read More
CodeIgniter active record query to return a column value from a single row otherwise a default value...


phpsqlcodeigniteractiverecordquery-builder

Read More
ActiveRecord serialize using JSON instead of YAML...


ruby-on-railsjsonactiverecordyamlserialization

Read More
Codeigniter combine where_in and like active record queries...


phpmysqlcodeigniteractiverecordwhere-in

Read More
Using a subquery with CodeIgniter WHERE IN clause...


phpcodeigniteractiverecordsubquerywhere-in

Read More
Upsert in Rails ActiveRecord...


ruby-on-railsactiverecordupsert

Read More
Rails GROUP BY query using Active Record...


ruby-on-railsactiverecordruby-on-rails-5rails-activerecordruby-on-rails-5.2

Read More
CodeIgniter's distinct() method with a column as a parameter doesn't work as expected...


phpmysqlcodeigniteractiverecorddistinct

Read More
Write query with JOINs, GROUP BY, and SUM()s using CodeIgniter's query building methods...


phpmysqlcodeigniteractiverecordquery-builder

Read More
Rails: Add UUID Primary Key to Table in Database Already Using UUIDs as Primary Keys...


ruby-on-railspostgresqlactiverecorduuid

Read More
BackNext