Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 -- Step 3) Re-associate correct parent ids and start rebuilding paths in J30 UPDATE `my_new_database`.my_prefix_menu child, `my_new_database`.my_prefix_menu parent SET child.parent_id=parent.id, child.path=CONCAT(parent.path,'/', child.alias) WHERE...

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

XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for schema comments any Enables the author to extend the XML document with...

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

T-SQL: Parse an XML valuehttps://joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 -- to return unknown nodes from XML column - Event_XML SELECT Event_XML.query('//* ') FROM [dbo].[XML_EVENTS] Parent/Child Node Names -- to get name of parent node -- returns STAFF SELECT ( SELECT c.value('local-name(.)', 'nvarchar(50)') FROM...

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

Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const WM_TIMECHANGE = $001E Const WM_CANCELMODE = $001F Const WM_SETCURSOR = $0020 Const WM_MOUSEACTIVATE = $0021 Const WM_CHILDACTIVATE = $0022 Const WM_QUEUESYNC = $0023 Const WM_GETMINMAXINFO = $0024 Const WM_PAINTICON = $0026 Const WM_ICONERASEBKGND...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 3.0.1 ThomasM- Fixed Bug: Strict Standards Issue: New Operator removed for PHP5+. - Fixed Bug: Object without reference: Child object design converted to Object array. - Date Uploaded: Thu, 31st Oct 2013 3.0- Fixed Bug: Version compatible with Joomla v3...

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

Zoho Creator: Embed Forms/Reports on a Pagehttps://joellipman.com/articles/crm/zoho/zoho-creator-embed-forms-reports-on-a-page.html

05 May 2022 The last part shows how to embed using an IFRAME tag which isn't great for CSS styling as you can't do cross-dom acoss child iframes; but it does let you use OpenURL(v_Url, "iframe", "iframe_name") which is good if you have multiple iframes on a page...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 v_OutputMessage = "Credit application sent to " + v_RecipientEmail + " for signing."; // // create CRM zohosign document child records (recipient and event) if(!isNull(r_ZCrm_ZSDoc.get("id"))) { // // get logged in user (who clicked the button)...

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

Zoho Inventory Template Issue: First Page is Blankhttps://joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 attribute "page-break-inside" If this is set to "avoid", then change it to "auto" Additional You may also need to remove the child tags of the table specifying the above CSS.

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