Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming state is required, the following 23 results were found.

  1. Win32 Constantshttps://www.joellipman.com/component/content/article/win32-constants.html?catid=48&Itemid=165

    = (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: *
  2. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    ) 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: *
  3. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

    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 CRM
    • Language: *
  4. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  5. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

    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 Books
    • Language: *
  6. Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-display-sales-order-shipping-address-on-package-slip.html

    ${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 Books
    • Language: *
  7. 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

    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
  8. Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-refresh-access-token.html

    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 Deluge
    • Language: en-GB
  9. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    = 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 Books
    • Language: *
  10. Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-add-a-subform-while-creating-a-record.html

    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 Creator
    • Language: *
  11. ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-template-not-being-able-to-edit-a-text-box.html

    ${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 CRM
    • Language: *
  12. Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    ZDK.Page.getField('Billing_Country').setValue(o_QuoteDetails._Billing_Country); ZDK.Page.getField('Billing_State').setValue(o_QuoteDetails._Billing_State); ZDK.Page.getField('Billing_Code').setValue(o_QuoteDetails._Billing_Code);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Returned a data type that is not validhttps://www.joellipman.com/articles/else/database/t-sql/returned-a-data-type-that-is-not-valid.html

    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: *
  14. Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    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
  15. Zoho Deluge - Hide Reset Button on Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-hide-reset-button-on-form.html

    So another quick note as I couldn't find a solution on the forums. This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here goes: Why? Because I can. And because as someone said, a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  16. Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    (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: *
  17. Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

    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
  18. Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    = '{"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
  19. Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

    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
  20. SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    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
Results 1 - 20 of 23