CodeIgniter Forums - Search Results

Search Results

Thread: Use Where in updateBatch (CI 4.3.3)
Post: RE: Use Where in updateBatch (CI 4.3.3)

Just add the condition with onConstraint() it will accomplish the same thing. /* * IT COULD PRODUCE: * * UPDATE `test` * INNER JOIN ( * SELECT '22' `course_id`, '34' `question_id`, '80' `min_s...

Thread: Type casting in PostgreSQL with updateBatch()
Post: RE: Type casting in PostgreSQL with updateBatch()

The quick and easy fix for this is to use RawSql as well as casting your php values: Code: -- $data = [ [ 'name' => 'Derek Jones'...

Thread: SQL query with 1 fixed and 2 OR conditions
Post: RE: SQL query with 1 fixed and 2 OR conditions

You need to use Query Grouping. See https://www.codeigniter.com/user_guide/database/query_builder.html#group Code: --

Thread: [SOLVED] SQLite3 Error
Post: RE: SQLite3 Error

Try: Code: -- $this->db->table('formula')->insertBatch([ ['url_id' => 1, 'source_id' => 1, 'medium_id' => 1, 'content_1_id' => 1, 'content_2_id' => 1, 'content_4_id' => null], ['url_id' => 1, 's...

Thread: [SOLVED] SQLite3 Error
Post: RE: SQLite3 Error

Your dataset for insertBatch() is not symmetrical. You must use symmetrical data for any of the *Batch() methods. You need to define content_4_id in the first and second row as well.