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

  1. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    */ // // initialize v_AccountID = ""; v_Output = "Error: Could not retrieve given CRM Account ID"; // // ****************************** GENERIC CODE BELOW ****************************** // // retrieving the parameters of the request m_RequestParams =...

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

  2. Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html

    form link name is P_Goals which doesn't feature under the developer space > Zoho People API... The Zoho People function to retrieve this data: /* ******************************************************************************* Function: String...

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

  3. Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, database, etc.). For obvious reasons, these cannot be hardcoded. What? Any...

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

  4. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    = 'http' . ($_SERVER['SERVER_PORT'] == 80 ? '' : 's') . '://' . $_SERVER['SERVER_NAME'] . $_SERVER['SCRIPT_NAME']; // retrieve from credentials file function getStoredCredentials($path) { $credentials = json_decode(file_get_contents($path), true);...

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

  5. Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    locationManager = (LocationManager) getSystemService(Context.LOCATION_SERVICE); // Create a criteria object to retrieve provider Criteria criteria = new Criteria(); // Get the name of the best provider String provider =...

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

  6. 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

    is not blank. Derived Column Task: Format keycolumn as per your requirements and use substring on trimmed DataColumn to retrieve each data column. Additional The TRIM in SSIS does not appear to get rid of new line and carriage return symbols!!! Use the...

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

  7. SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    which files (in this example "File*.txt", all files starting with "File" - eg. "File0001.txt", "File0002.txt") For "Retrieve File Name" I put "Fully Qualified" (hoping this means the full path is used as just putting the file name did not work). Under...

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

  8. SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    display the image. When the report is run on the report server, the report server uses the unattended execution account to retrieve the image. So here's my checklist: Test adding an external image that doesn't need credentials (such as Google's logo @...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  9. No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  10. Convert foreign characters to English alphabethttps://www.joellipman.com/articles/else/database/mysql/convert-foreign-characters-to-english-alphabet.html

    t SET t.`myColumn`=REPLACE(t.`myColumn`, 'ź', 'z'); UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'ż', 'z'); Retrieve records with foreign characters: SELECT * FROM `myTable` WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]' Joomla! Additional...

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

  11. Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/cms/website-development/php/creating-a-top-10-chart-with-less-code.html

    used often to do a statistics table or top ten chart of your data (eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each data exists, sort it in reverse order so that the most frequent is at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *

  12. SITS: XET format for Export not availablehttps://www.joellipman.com/articles/cms/website-development/xml/sits-xet-format-for-export-not-available.html

    Exchange Format first: Run the DEF from the menu Clear and create a new one based on the following: Now you can go and retrieve a student/staff (depending on what data your XET feeds off) Bring up STU File > Export... You should have something similar...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
Results 41 - 52 of 52