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 loop is required, the following 85 results were found.

  1. Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-a-html-entity-decoder.html

    // // map string replacements m_HtmlEntity = Map(); m_HtmlEntity.put("&","&"); m_HtmlEntity.put(" "," "); // // loop through each of the above replacing where found for each v_HtmlKey in m_HtmlEntity.keys() { v_StringToDecode =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    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 increase the number of pages as well as the number of products per...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

    set an estimated number of products that are in your listing, it will then generate the number of pages it thinks it has to loop, so try and give a number higher than the actual number of products you have in your shop, it will stop when it's reached...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

    r_GoalsData = invokeurl [ url :v_Endpoint_Goals type :GET connection:"zpeople" ]; // // parse the response loop through each record returned m_GoalsResponse = ifnull(r_GoalsData.get("response"),Map()); l_GoalRecords =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

    : a_QuotedSalesOrders || []; // set first valid sales order ID var v_FirstSalesOrderID = null; // loop through related sales orders for (var i = 0; i...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

    ")); m_CrmAccount.put("Billing_City",v_XeroAddressCity); m_CrmAccount.put("Billing_Code",v_XeroAddressZip); // // loop through phones for each m_XeroPhone in m_XeroContact.get("Phones") { if(!isNull(m_XeroPhone.get("PhoneNumber"))) { v_XeroPhoneType =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

    ")); m_CrmAccount.put("Billing_City",v_XeroAddressCity); m_CrmAccount.put("Billing_Code",v_XeroAddressZip); // // loop through phones for each m_XeroPhone in m_XeroContact.get("Phones") { if(!isNull(m_XeroPhone.get("PhoneNumber"))) { v_XeroPhoneType =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Format Numbers in AutoHotkey with Commashttps://www.joellipman.com/articles/automation/autohotkey/format-numbers-in-autohotkey-with-commas.html

    in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum% StringReplace, Result, Result,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  9. VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

    0 x = 14 Do Cur = Cur * 256 Cur = Key(x + KeyOffset) + Cur Key(x + KeyOffset) = (Cur \ 24) And 255 Cur = Cur Mod 24 x = x -1 Loop While x >= 0 i = i -1 KeyOutput = Mid(Chars, Cur + 1, 1) & KeyOutput If (((29 - i) Mod 6) = 0) And (i -1) Then i = i -1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  10. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

    folder, the program will just create another one. Question How does the thumbnail name generating work? Answer: The program loops through the images folder and finds a name that isn't taken (something like "000065.bmp"). It won't overwrite existing...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  11. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

    Internet Explorer" ) oShell := COM_CreateObject( "Shell.Application" ) ; Contains reference to all explorer windows Loop, % COM_Invoke( oShell, "Windows.Count" ) { If pwb := COM_Invoke( oShell, "Windows.item[" A_Index-1 "]" ) If ( COM_Invoke( pwb,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  12. Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

    ), VarSetCapacity( List,10240,0 ) IfEqual,nPtr,0, Return SubStr( DllCall( "ImageHlp\UnMapAndLoad", UInt,&$LI ), 0,0 ) Loop % NumGet( P+24 ) + 1 A_IsUnicode ? Var := DllCall( "MulDiv", Int,nPtr, Int,1, Int,1, AStr ) : DllCall( "lstrcpy", Str,Var,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  13. Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

    msgbox % Chr(24) ; upwards arrow msgbox % Chr(25) ; downwards arrow, unstable Generate list of those that work for you: loop 255 fileappend,% a_index . A_Tab . A_Space . Chr(a_index) . "`n",ascii-chartable.txt A bunch of others that may work: Some...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  14. Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    3.X a.name AS 'display_name' FROM my_joomla_db.jos_users a ORDER BY a.id; A bit more to do: PHP file So I needed to do a loop and rather than complicate things with stored procedures and cursors, it's likely if you're using either Joomla or Wordpress...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  15. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

    ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; DECLARE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  16. DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

    ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; DECLARE @RandString varchar(max); -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  17. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

    For one thing, the accidental search for "Jane" and pressing the Enter key, no longer goes off into the interminable loop that is "loading".

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

    function was only going to be applied to names and titles rather than addresses, but here it is anyway, add this after the "loop through exception cases" while clause: -- Now for some UK (British) PostCode recognition SELECT @i=1, @CaseExceptions =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  19. Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

    brace var myRecords = newSortedArrayObject.split('}'); // removes last row which is undefined (ie. "]") myRecords.pop(); // loop through array for (i=0; i

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  20. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

    Sort the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file contents - Loops through each row and splits by commas (not within quotes) - Sorts the final array by a object label function...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 41 - 60 of 85

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.