Assuming query is required, the following 110 results were found.
-
for Joomla 2.5.x Building Joomla lets you build up the queries which admittedly is cleaner and more organized. Here is a query which shows the building methods: // Get a db connection. $db = JFactory::getDbo(); // Create a new query object. $query =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate) AS 'Day'...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Myself 07:30 07:30 07:30 07:30 07:00 00:00 00:00 37:00 I 03:45 03:30 03:00 03:30 00:00 00:00 00:00 23:00 Method 1. Generate query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and closing XML tags: -- Using .query() SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender FROM [dbo].[XML_EVENTS] --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
= "{ products(first: 5, reverse: true) { edges { node { id title handle } } } }"; m_GraphQl = Map(); m_GraphQl.put("query", v_GraphQl); // // Let's test with this GraphQL query v_Endpoint = "https://" + v_ShopID + "/admin/api/" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
$parent) { // $type (install, update or discover_install) if ($type == 'install') { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->update($db->quoteName('#__extensions')); $defaults = '{"param1":"value1","param2":"value2"}'; // JSON...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
How? So this is my plan: Setup a connector to CRM with the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL Build up a SQL query, or more specifically, a COQL - CRM Object Query Language Try using distinct on a single-line text field Adapt the query for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
(and grant execute for your SSRS user) Add a data source to your SSRS report Add an SSRS input parameter Add a dataset Query type: Stored Procedure Refresh fields button Parameter name (oracle input sp variable) and Parameter value (ssrs input...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
find typos as well, eg. "Daat ont Ety Aviable". How? Mine's a bit of a copout as it is a two-step process. I wanted a query that searched every column containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by 4000...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
100 or at least resume from a record... We need pagination. How? To resolve this, I'm building on top of my initial GraphQL query which will now retrieve 10 products per page and loop through 3 pages for use in Zoho Deluge. If this works, we can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
like the English Ordinal Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH to do this in an MDX query but I spent over an hour before I gave up trying to get SWITCH to work. Instead I cheated and got the ordinal in the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
and resource names... Users...the one with users names... Teams...another lookup table for just the name value... The one query to rule them all SELECT CONCAT(s.LogID, ' ') AS ActivityID, t.TeamName AS Team, CONCAT(u.Firstname, ' ', u.Lastname) AS...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
data. Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'"); $mysqli->query ("UPDATE 'accounts' SET...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What we...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
with a PHP script this could be a few lines for something really small. The quick trick to this is to do it all in one query: UPDATE table1 SET counter_field_value=counter_field_value+1 WHERE column1='this_article'
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
\plugins\search\content\content.php: Insert this between the if ($sContent && $limit > 0){ and before the from part of the query $query->from('#__content AS a'); // Add "Relevance" column // + 1000 pts if in title x1 (eg. if word is twice then 2000pts)...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
all the data including the custom fields per line items to ZohoAnalytics; and in ZohoAnalytics importing a table based on a query which joins the sales orders and purchase order items by the custom lookup field. What follows is the code required to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
What? In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
What? A super quick article to demonstrate how an idiot like myself can misread the documentation. This particular article shows you how to customize the search results or response from using zoho.creator.getRecordById(). Why? My use case scenario is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *