List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 latin1)) FROM wikimedia_categorylinks WHERE wikimedia_categorylinks.cl_from=p.page_id) AS PageCategory, (SELECT GROUP_CONCAT(TRIM(REPLACE(ccg.GroupName_Friendly, '_', ' '))) FROM custombu_category_restrictions ccr INNER JOIN custombu_category_groups ccg...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 user_registered, user_activation_key, user_status, display_name ) SELECT a.id 'ID', a.username 'user_login', REPLACE(TRIM(LOWER(a.username)), ' ', '_') AS 'user_nicename', a.email AS 'user_email', ' ' AS 'user_url', a.registerDate AS 'user_registered',...

• Type: Article
• Author: Joel Lipman
• Category: Wordpress
• Language: en-GB

Basic Oracle Function Structurehttps://joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 number IS student_no number; cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Connect to Joomla database in standalone scripthttps://joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 // Database prefix (may be empty) // Database prefix (if empty then remove prefixing double underscore) $db_prefix = (trim($db_prefix)=="") ? "":$db_prefix; $db_connect = mysqli_connect($db_host,$db_user,$db_pass); $content_count = 0; // CONNECTED! so...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 the color is still black. Additional Note that instead of just saying if this value equals "Name:" I've added some code to trim the values. If the user types two spaces, then we want the field to understand this as "no one entered anything", treat it as...

• Type: Article
• Author: Joel Lipman
• Category: JavaScript
• Language: en-GB

T-SQL functions to convert Strings to Tableshttps://joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 BEGIN DECLARE @StringValue VARCHAR(10) SET @StringInput = RTRIM(LTRIM(@StringInput)) WHILE LEN(@StringInput) > 0 BEGIN SET @StringValue = LEFT(@StringInput, ISNULL(NULLIF(CHARINDEX(' ', @StringInput) - 1, -1), LEN(@StringInput))) SET @StringInput =...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Accessing Apimo WebService APIhttps://joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 from results $output = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output = trim($output); // process if type specified was xml if($apimo_type=='xml'){ // send header header("Content-Type:text/xml"); //...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

MySQL: Count occurrences of words in a columnhttps://joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) b ORDER BY n ) n WHERE n.n 5 AND TRIM(`value`) NOT IN ('Article','This',' ','content','component','applies','because','doesn''t') GROUP BY `value` ORDER BY `total`...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 = List(); for each r_PicklistOption in r_DealDetails.get("My_MultiPicklist") { v_PicklistOption = r_PicklistOption.trim().replaceAll(",", ",",true); l_MyMultiPicklist.add(v_PicklistOption); }...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 if it is then I proceed with the automations otherwise I stop it. // get given eTag v_eTag = zoho.encryption.md5(input.Title.trim()); // // now compare to stored eTag if(v_eTag != input.eTag_Title) { input.eTag_Title= v_eTag; input.Audit_Change =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 v_UserMessage.subString(0,40) + "...", v_UserMessage); m_Create.put("Title", v_Title); m_Create.put("Content", v_UserMessage.trim()); m_Create.put("Role", "user"); m_Create.put("Email", zoho.loginuserid); m_Create.put("Owner", v_LoggedInUserID);...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Connect to Shopifyhttps://joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

15 July 2025 received when installing the custom app for the first time m_Header.put("X-Shopify-Access-Token",r_ShopifyAPI.Access_Token.trim()); // v_Endpoint = v_Shopify_BaseURL + "/admin/api/" + v_ShopifyApiVersion + "/orders/" + p_OrderID + ".json"; r_GetOrder =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *