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

  1. Zoho Creator: isBlank and isNull: Before or After?https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-isblank-and-isnull-before-or-after.html

    info "---------------------- Value of TEST is a BLANK String"; v_Test = ""; if(isBlank(v_Test)) { info "isBlank Preceding is TRUE"; } else { info "isBlank Preceding is FALSE"; } if(v_Test.isBlank()) { info "isBlank Succeeding is TRUE"; } else { info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    the building methods: // Get a db connection. $db = JFactory::getDbo(); // Create a new query object. $query = $db->getQuery(true); // build the SQL query $query->select($db->quoteName(array('p.user_id', 'u.username', 'u.real_name')));...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/cms/website-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

    1234567 JOEL LIPMAN Two things to do really: Add the xmlns:xsi namespace in the xsl:stylesheet tag so that "xsi:nil=true" is valid. Test for a string length of greater than 0 (not blank) and change the attribute of the element so that it's tag displays...

    • Type: Article
    • Author: Joel Lipman
    • Category: XML Stylesheet Language Transformations
    • Language: *
  4. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

    Sort By Radio selection. The following will set the Radio to Ascending: Code: javascript: document.all.sort_dir[0].checked = true; void 0 pwb.document.all.sort_dir[0].checked := True COM_Invoke(pwb, "document.all.sort_dir[0].checked", True) Get Text...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  5. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    show me column 3 with myspecialcomma replaced back to a comma info l_StringParts.get(2).replaceAll("|mySpecialComma|", ",", true); // yields: Flat 8, House Corner The long answer is to consider the following code which generates a sample CSV and then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. Zoho Deluge: Convert Map to HTML Table without a FOR loophttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

    and a lot of replaceAll: l_Keys = List(); l_Keys = v_Data.toMap().keys(); v_DataHtml = v_Data.replaceAll("},{", "}{", true); v_DataHtml = v_DataHtml.replaceAll(l_Keys.get(0) + "\"", " ", true); v_DataHtml = v_DataHtml.replaceAll("\",\"" + l_Keys.get(1)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    we're sending curl_setopt($ch, CURLOPT_HEADER, 0); // hide header info !!SECURITY WARNING!! curl_setopt($ch, CURLOPT_POST, TRUE); // TRUE to do a regular HTTP POST. curl_setopt($ch, CURLOPT_POSTFIELDS, $api_message_xml); // In my case, the XML form that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  8. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    type :GET ]; // // upload file to workdrive r_WorkdriveUpload = zoho.workdrive.uploadFile(f_File,v_TargetFolder,v_FileName,true,"zworkdrive"); info "Workdrive response:"; info r_WorkdriveUpload; if(!isNull(r_WorkdriveUpload.get("data"))) { // // set...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

    CURLOPT_POST, 1); curl_setopt($ch1, CURLOPT_POSTFIELDS, file_get_contents($file)); curl_setopt($ch1, CURLOPT_RETURNTRANSFER, true); // set authorization header curl_setopt($ch1, CURLOPT_HTTPHEADER, array('Content-Type: '.$mime_type, 'Content-Length: '....

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  10. Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    v_MyString = "Joe's \"Amazing\" Skill & Sidekick (1)"; v_FormattedString = v_MyString.replaceAll(("([&'\"\%()])"),"\\$1",true); // yields Joe\'s \"Amazing\" Skill \& \ Sidekick \(1\) v_FormattedString = v_MyString.replaceAll("%"),"\u0025",true); The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  11. Zoho Creator: Copy Subform to other Subformshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-copy-subform-to-other-subforms.html

    that when the decision box "Copy Monday to the Other Days" is clicked it runs the following deluge script: // only run if true if(input.Copy_Monday_to_the_Other_Days) { // init c_Tuesday = Collection(); c_Wednesday = Collection(); c_Thursday =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    Set xRow = xRow.Offset(SplitRow) Next Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Press F5 to run the code. This will prompt you twice: It is prompting you for the range of all the data to apply this to (eg. $A1:$W36000)....

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  13. Connection Strings for SQL Serverhttps://www.joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

    needs to have a certificate installed. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Encryption=true; This option is available from Connector/NET version 5.0.3. In earlier versions, this option has no effect. Using encryption,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  14. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    proposed file name matches the original file exists and is an exception for renaming. v_Increment := 1 b_KeepLooping := true while ( b_KeepLooping || CountExistingInColumn2( v_NewNameWithExt ) > 0 ) { v_Increment++ b_FileExists:= FileExist( SelectedDir...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  15. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    = " Hello World "; // // output input.Note_Preview = input.Title; // // re-enable auto-update preview input.Update_Preview=true; To any other fields I would add the code: if(input.Update_Preview) { input.Audit_Change = "Title: " +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  16. Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-proper-case-for-names.html

    // // let's deal with double or triple barrelled first names v_FirstName = v_FirstName.replaceAll("-", " :|JOEL|: ", true).proper(); v_FirstName = v_FirstName.replaceAll(" :|joel|: ", "-", true); // // Names starting with Mc, O', D', I'...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    $header); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($data)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($ch); curl_close($ch); $output = json_decode($response, true); return $output; } 5. Get Minutes Remaining on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  18. URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    "%2fMYREPORTS%2fDemos%2fRB+Report+for+Me" to the name and folder of your report. To hide all except the report (default is True) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Toolbar=False To...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/cms/website-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

    LocalSettings.php file: # for debug purposes error_reporting(E_ALL); ini_set("display_errors", 1); $wgShowExceptionDetails = true; $wgShowSQLErrors = true; $wgDebugDumpSql = true; $wgDebugLogFile = '/var/www/html/debug_log.txt'; I still couldn't upload...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  20. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    similar to the following: // this is sample JSON with replaced IDs "My_CRM_File": [ { "extn": "pdf", "is_Preview_Available": true, "download_Url":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 1 - 20 of 88