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

05 July 2011 = (WM_USER + 12) Const TB_ISBUTTONINDETERMINATE= (WM_USER + 13) Const TB_ISBUTTONHIGHLIGHTED = (WM_USER + 14) Const TB_SETSTATE = (WM_USER + 17) Const TB_GETSTATE = (WM_USER + 18) Const TB_ADDBITMAP = (WM_USER + 19) Const TB_ADDBUTTONSA = (WM_USER + 20)...

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

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

30 January 2011 ) AS name, CONCAT(`title`, ' :|joes|', `id`, '|: ') AS title, '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}' FROM `my_old_database`.jos_categories WHERE `my_old_database`.jos_categories.section='com_banner'; --...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a module called "States" which stores a default timezone and can be searched for with the "State" field on the Lead record. // //...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 personal website: www.joellipman.com. This article assumes you are familiar with upgrading a Joomla! CMS and running MySQL statements against your database. For the purposes of this article, we will refer to the live/current/production website running...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 product description" } ], "shipping_address": { "address": "Test Street", "street2": "Test Street 2", "city": "Test City", "state": "Test State", "zip": "Test Postal Code", "country": "Test Country" } } However, if you try forcing the billing or...

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

Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://www.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 ${CONTACT.CONTACT_DISPLAYNAME} ${CONTACT.CONTACT_ADDRESS} ${CONTACT.CONTACT_CITY} ${CONTACT.CONTACT_CODE} ${CONTACT.CONTACT_STATE} ${CONTACT.CONTACT_COUNTRY} and in my Sales Order: BILLING ADDRESS SHIPPING ADDRESS ------------------- -------------------...

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

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 v_Scope = "ZohoBooks.contacts.ALL,ZohoBooks.invoices.ALL,ZohoBooks.purchaseorders.ALL"; v_State = "testing"; v_ResponseType = "code"; v_Access = "offline"; v_Prompt = "consent"; l_Params = List(); l_Params.add("scope=" + v_Scope);...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 = 0; m_CreateEstimate = Map(); l_CrmBillingAddress = {"Billing_Street","Billing_Street_2","Billing_City","Billing_State","Billing_Code","Billing_Country"}; l_CrmShippingAddress =...

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

Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 a GROUP BY a.VisitorIP ORDER BY a.DateTimeStamp DESC) t1 GROUP BY CONCAT(MONTH(t1.Date), ' ', YEAR(t1.Date)) Caused by SQL statement returning first column date as CONCAT(MONTHNAME(t1.Date), ' ', YEAR(t1.Date)) AS Month Solved by changing SQL statement...

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

Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 the number of columns. My Solution SELECT title, intro FROM ( SELECT `title`, `introtext` intro FROM `jos_content` a WHERE a.state=1 UNION ALL SELECT `name` AS title, `description` AS intro FROM `jos_hp_items` b WHERE b.published=1 ) t1 Resulting in:...

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

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 v_AddressLine1 = r_ContactDetails.get("Street"); v_AddressCity = r_ContactDetails.get("City"); v_AddressState = r_ContactDetails.get("State"); v_AddressZip = r_ContactDetails.get("Zip"); v_AddressCountry = r_ContactDetails.get("Country"); } // // get...

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

ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 ${Organization.Street} ${Organization.City} ${Organization.Country} ${Organization.Postal Code} 11 My Street, My City, My State, My Zip, My Country They wanted to get rid of the "11 My Street, My City, My State, My Zip, My Country" but when editing the...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 (make a backup/copy first) Look for the following line of code [the function is "protected function populateState("]: Line 181: $orderCol = JRequest::getCmd('filter_order', 'ordering'); and change this to: $orderCol = JRequest::getCmd('filter_order',...

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

UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 $db->setQuery( $sql_utf8 ); $temp_result = $db->query(); $sql = 'SELECT '.$modulescancontentsql.' FROM #__content WHERE state=1'; $db->setQuery( $sql ); $rows = $db->loadObjectList(); foreach( $rows as $row ) { $id = $row->id; $title = $row->title; }...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 references (eg. T-SQL is @localvariable, Oracle is :localvariable). I need to change it to a conditional query with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM table1, table2...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

16 August 2011 created 'post_date_gmt', CONCAT(introtext, ' ', `fulltext`) 'post_content', title 'post_title', '' post_excerpt, CASE state WHEN '1' THEN 'publish' ELSE 'draft' END 'post_status', 'open' comment_status, 'open' ping_status, '' post_password, alias...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 absolute novices (like me) who just want to see an example of an AJAX form within Joomla 1.6.x - 2.5.x in it's most basic state. At time of print, I am using this with Joomla 2.5.6. Why? The examples of the official site (mootools.net) did not work in...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 my connection manager as follows (note the "Ragged Right" and delimiter as "{CR}{LF}" - my rows to skip is because of the state of my data): Crucial fix here, add 2 to the OutputColumnWidth value. It seems you need to set the data column to accommodate...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 e1 LEFT JOIN DMExtractReferenceTable r1 ON e1.CodeType=r1.MapIn So why do I get the error: Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value 'B110' to data type int. I'm not using any of the non-numeric values to map...

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

Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 = '{"core.admin":{"2":0},"core.manage":{"2":0},"core.create":{"2":1},"core.delete":{"2":1},"core.edit":{"2":1},"core.edit.state":{"2":1},"core.edit.own":{"2":1}}'; // JSON format for the parameters, see PHP serialize()...

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