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

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

    Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {... } isBlank() can be used to check if the string only contains...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

    Password=myPassword;Socket=MySQL;Option=3; On Windows, the socket variable is the name of the named pipe that is used for local client connections. The default value is MySQL. On Unix platforms, the socket variable is the name of the socket file that is...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  3. Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

    an SSRS input parameter Add a dataset Query type: Stored Procedure Refresh fields button Parameter name (oracle input sp variable) and Parameter value (ssrs input parameter) Fields (field name=ssrs reference, field source=oracle sp field name) 1. Create...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  4. Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

    prompt, you know that you have to refer to each tool using their full path unless you add it to the PATH environment variable: This allows you to use keytool from any folder: Open a command prompt Type CD C:\Program Files\Java Determine your JDK folder...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  5. SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

    in report parameter expressions". I tried this with "Default values" and got the same problems. Note: before you try, "Variable values cannot be used in report parameter expressions" either. I'm using an Oracle/PLSQL database for this so whether you're...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

    confidentiality is somewhat important, some of the images will be censored or data changed in the example below. Add a variable (preferably to the scope of the package) called "SourceExtractFile" and give it the data type "String". Set the Value to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  7. Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

    in ZohoCRM: Create a function with a string parameter called "crmAPIRequest". It has to have this name. It is a reserved variable and will contain all the webhook payload data. When a webhook is pointed at it, the crmAPIRequest variable will hold the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

    WHERE ThisRecord = :UserSpecifiedID -- where :UserSpecifiedID is one of the report parameters (Oracle local variable) -- where :ParameterToCheck is another of the report parameters (Oracle local variable) MDX Check /* For Expression Value. Remember to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

    every column containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by 4000 characters in a variable (so I couldn't store it in a local variable). So the idea here is to run the below example which outputs a huge SQL query...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  10. Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    All oracle utilities and connections working on my computer (except for TNSPING). TNS_ADMIN is another environment variable used that we must maintain (current value at "C:\app\\product\11.2.0\client_1\bin") Setting environment variables using the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  11. AutoHotkey: Get Media Information and Displayhttps://joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

    := "", Kind := "", P* ) { ; v.90 By SKAN on D1CC @ goo.gl/jyXFo9 Local Static xDetails If ( sFile = "" ) { ; Deinit static variable xDetails := "" Return } fex := {}, _FileExt := "" Loop, Files, % RTrim(sfile,"\*/."), DF { If not FileExist(...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  12. Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

    and the second time to add the collection to the subform. Syntax for inserting a row into a subform: // declare a variable to hold the collection of rows = Collection(); // declaring the row = .(); // assigning values for various subform fields in the...

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

    as many rows as required) = .(); // assigning values for various subform fields in the row . = ; . = ; // declare a variable to hold the collection of rows = Collection(); .insert( , ); // insert the rows into the subform through the variable...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

    receive parameter crmAPIRequest (of datatype string in your function) m_Payload = crmAPIRequest; // // initialize response variable m_Response = Map(); // // get xero signature v_XeroSignature = "SIGNATURE_FAIL"; if(!isnull(m_Payload.get("headers"))) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Books: Generate Bank Text File for Downloadhttps://joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

    Generate the file The code here is a cut down version just to demonstrate generating a text file and storing this into a variable: // // initialize v_CSVString = "Bank Sort Code,Bank Acc. No,Account Holder"; v_CSVString = v_CSVString +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

    A quick article on how to use remove() on a map variable as well as a snippet of code to copy tags from a contact to a deal record. Why? Anything that stumps me for 30 minutes is worth writing a quick article on. In this case, I had a function querying...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. SSRS Report Builder 2.0 - Error during processinghttps://joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

    report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

    . " Kb "; echo "Temp file: " . $_FILES["uploaded_file"]["tmp_name"] . " "; The key of the above array is the name of the variable you passed in your HTML form. If the above yields NO empty data (and size is not 0) then it was successful. If not, then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  19. Community Builder in Joomla Vulnerabilityhttps://joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

    which I will go into more detail as I test each one (11.11.09): administrator/components/com_comprofiler/plugin.class.php variable mosConfig_absolute_path http://secunia.com/advisories/14337 allow_url_fopen = Off Keywords: Hacking, XSS & SQL-Injections.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  20. Add Image Mouseover effect in AutoHotkey GUIhttps://joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

    text BEFORE the gui,show command. The above example is used in a search form where "SearchButton" is the name of the variable (picture) to change. Note that I am using the method of hiding the input button and putting an image over it. The code above is...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
Results 1 - 20 of 57

Please publish modules in offcanvas position.