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

  1. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    Not Included") { // field mapping of quoted items to invoiced items (i console logged out this line item and copied each of the fields hoping they had the same API name in both modules) o_NewLineItem.CUSTOM = o_ThisLineItem.CUSTOM; o_NewLineItem.Config...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

    of the deal record but it was on the edit page. How? First we're going to add some element IDs to the canvas view page on each of the tabs. Then we'll make an OAuth function that can be executed by the client script which returns the value of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  4. T-SQL Record Separatorhttps://joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    ... Sunday 16/10/2011 A007 08:00 17:00 NULL NULL NULL NULL NULL NULL */ Note that my data is inaccurate as the last row of each grouped data has been changed to NULL. Also note how the actual select query is pulling data from my CTE in its...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  5. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    use EXCEL filters as the parameters. Bit of a cop-out but this was just a workaround and never a solution. Add in the ID of each entry as a field to pull from the database so that anyone can drilldown to the specific logged activity event (smallest unit...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  6. Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    to find either 'a', 'b', or 'c' use the following regular expression: [abc] This expression matches the first character in each of the following strings: at bet cot The expression does not match: def Non-Matching Character List Use the non-matching...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  7. XML Schema Referencehttps://joellipman.com/articles/cms/website-development/xml/xml-schema-reference.html

    Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for schema comments any Enables the author to extend the XML document with...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: en-GB
  8. Pancakeshttps://joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165

    pour the rest into a bowl anduse it to lubricate the pan, using a wodge of kitchen paper to smear it round before you make each pancake. Now get the pan really hot, then turn the heat down to medium and, to start with, do a test pancake to see if you're...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  9. Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    Model handles database and library variables, Views controls the HTML layout - And tweaks so I have as little to setup on each website :c) - Date Uploaded: Mon, 1st Aug 2011 It's Personal - Rounded corners, hover border, styling mostly - For use by my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  10. Accessing Apimo WebService APIhttps://joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    request over HTTPS using the GET method. Why? This was quite difficult to connect to and to determine what was wrong with each step of the development as the error messages were somewhat vague. I thought I'd quickly write this article so I don't have to...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  11. Zoho Deluge: Convert Map to URL Parametershttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-map-to-url-parameters.html

    follows is the code I'm using to convert this: v_Endpoint = "https://api.joellipman.com/myapi"; l_UrlParams = List(); for each v_Key in m_Payload.keys() { l_UrlParams.add(v_Key.toString() + "=" + m_Payload.get(v_Key)); } info v_Endpoint + "?" +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  12. Joomla banners not rotatinghttps://joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

    to display, consider setting categories as vertical, horizontal and square banners. This means that you can have 3 modules each displaying banners from each category and position these as appropriate.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  13. Reminder on SSRS row separatorhttps://joellipman.com/component/content/article/reminder-on-ssrs-row-seperator.html?catid=75&Itemid=165

    Studio 2008 (BIDS) SQL Server Reporting Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Terms & Conditionshttps://joellipman.com/component/content/article/terms-conditions.html?catid=50&Itemid=165

    See the GNU General Public License for more details. There should be a copy of the GNU General Public License included in each download. If not, see www.gnu.org/licenses.

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  15. Forum Ruleshttps://joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    with ill earned post count points. Double posts will be merged into regular posts, and you will lose 10 postcount for each of the posts excluding the first one. Your post count can be changed to a negative number if necessary. The only exeption to this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  16. Client Services: Website Development Agreementhttps://joellipman.com/component/content/article/client-services-website-development-agreement.html?catid=50&Itemid=165

    date). JoelLipman.Com will make the source files available for download 24/7 so in the event that we lose contact with each other, the project manager has the option of going to another developer with the source files in order to continue the work....

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  17. Prefix Line Numbers in a Text Filehttps://joellipman.com/component/content/article/prefix-line-numbers-to-a-text-file.html?catid=51&Itemid=165

    favorite text editor... ta-daa... Explanation: FC is a file comparison tool in MS-DOS /N tells the comparison tool to prefix each line with its respective number /LB 300 tells it to buffer 300 lines (default will show first 100 lines - change this to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: *
  18. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    with a camera). Regulations different to the UK and US are still being reviewed prior to being added to the database but each country's aviation authority has been added. Earthquake Feed for the past day:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  19. Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=53&Itemid=165

    area I have added the hidden fields in the HTML form (generated in PHP) in the following file: mod_joesearch.php. Simply add each component name separated by a comma (eg. "doc_indexer, weblinks"): // add doc_indexer to search // search weblinks as well...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  20. Zoho Deluge - Get English Ordinalhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-english-ordinal.html

    Method #1: Using a list/array, I'm going to check the date against the 3 exceptions to this rule (11th, 12th and 13th of each month): // get the date (eg. 1, 2, 3,... 29, 30, 31) This_Day_Date = My_Date_Field.toString("d"); // determine English Ordinal...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 101 - 120 of 209