Timeline for Transforming a Query for JDATABASE
Current License: CC BY-SA 4.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Jun 21, 2018 at 8:12 | history | suggested | mickmackusa | CC BY-SA 4.0 |
was missing the critical `COUNT(*) AS tracks` part (I won't be insulted if you overwrite with your preferred style.)
|
| Jun 19, 2018 at 4:28 | review | Suggested edits | |||
| S Jun 21, 2018 at 8:12 | |||||
| S Apr 23, 2018 at 8:44 | history | suggested | mickmackusa | CC BY-SA 3.0 |
Added missing single quote after 0
|
| Apr 23, 2018 at 6:40 | review | Suggested edits | |||
| S Apr 23, 2018 at 8:44 | |||||
| Apr 22, 2018 at 9:46 | comment | added | Lodder |
@mickmackusa - Updated again. Keeping the small disclaimer as I hadn't actually tested the code for this specific scenario. It was the first where clause I was unsure about. As for the prepared statements, I'd suggest asking on the Joomla Github Issue Tracker and tagging mbabker, as he maintains the database framework package ;)
|
|
| Apr 22, 2018 at 9:45 | comment | added | mickmackusa |
Is there any hope of prepared statements with placeholders in the near future in Joomla? I want a bind() method asap!
|
|
| Apr 22, 2018 at 9:44 | history | edited | Lodder | CC BY-SA 3.0 |
deleted 12 characters in body
|
| Apr 22, 2018 at 9:43 | comment | added | mickmackusa |
...a couple more mentions: you can chain from getQuery and I can't think of any advantage to casting (int) on a static 0. To improve researcher confidence please remove your post-code-block disclaimer -- because you know that it's good now.
|
|
| Apr 22, 2018 at 9:18 | comment | added | Lodder |
@mickmackusa - Good shout. Probably answered before I knew about the default and glue. Updated the answer
|
|
| Apr 22, 2018 at 9:18 | history | edited | Lodder | CC BY-SA 3.0 |
added 3 characters in body
|
| Apr 22, 2018 at 8:37 | comment | added | mickmackusa | How about where() with glue or andWhere() ? | |
| Jul 28, 2015 at 10:04 | comment | added | Victor |
But, thank's for explaining me how to use GROUP BY and ORDER BY, and you code that youve writen to me i will use in next query that i need.
|
|
| Jul 28, 2015 at 10:00 | comment | added | Victor |
Fatal error: Call to a member function group() on a non-object in ->group($db->quoteName('title'))
|
|
| Jul 28, 2015 at 9:53 | vote | accept | Victor | ||
| Jul 28, 2015 at 9:54 | |||||
| Jul 28, 2015 at 9:52 | vote | accept | Victor | ||
| Jul 28, 2015 at 9:52 | |||||
| Jul 28, 2015 at 9:30 | history | answered | Lodder | CC BY-SA 3.0 |