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

  1. Zoho Deluge - Multi-line Variable Assignments and Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-multi-line-statements-using-semi-colon-termination.html

    Do bear in mind that once the script is saved and re-opened, the code will be reformatted back onto a single line. How? Below are three examples demonstrating multi-line assignments in Zoho Deluge. 1) Multi-line string concatenation, converted into a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    forums for a bit. Their solution only permanently sets the default sort order to WEBLINK TITLE in order from A to Z. The below code with my modifications maintains the functionality for the user to change the sort order by clicking on the column titles....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

    this solution which I found is compatible with almost any site and with all my components without having to modify the below script. Why? The article modal is a much easier way for the end-users to select a Joomla! article in the component...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    in the search results should be the text that the system emails out on password change. The default if you’ve lost it is as below (exclude the double-quotes): “Hello,\n\nA request has been made to reset your %s account password. To reset your password,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    the migration of a Joomla! CMS running version 2.5.11 to an instance of Joomla! CMS version 3.4.1. I would consider the below instructions an ALPHA version as it is considered unstable for official use... Saying that this is how I upgraded my own...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    punctuation symbols) ValueToConvert = textInfo.ToTitleCase(ValueToConvert.ToLower()); // add a trailing space to catch below exceptions (eg. "Director of It ") ValueToConvert = ValueToConvert + " "; // tranformation exceptions: words to be lowercased //...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  7. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    I only googled for about 1 hour before I gave up and just wrote my own. Saying that it's taken me 4 hours just to do the below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  8. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    (eg. T-SQL is @localvariable, Oracle is :localvariable). I need to change it to a conditional query with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM table1, table2 WHERE...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    The Quick Fix First off, check there aren't any Update for Windows 7 releases at Microsoft's Windows Update The Long Fix Now below are the notes I've had to try and fix this before (personally it was because Microsoft released an optional windows update...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  10. Windows 7 Aero Featureshttps://www.joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

    visual effects tab you should see that the option “ Let windows choose what’s best for my computer “ is by default checked. Below it you should see a list of visual effects, some of which will be unchecked if you are not experiencing the full range of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  11. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    browsing it will navigate to other pages and it will identify itself as IE7 to sites that check your browser details (see below - Additional Info) The Free Virtual PC solution (Requires ISO or WinXP disk) Go to Microsoft.com and search for Microsoft...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  12. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    Right click on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below you want to set as restricted, and click on OK. -- Restrict multiple drives by adding the values together -- For Example:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  13. T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

    This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  14. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    more and more. Similar systems have popped out that support some form of time recording and activity logging. The example below however is within a LAMP/MySQL environment but the SQL basics are here to help me adapt it to whatever environment people...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  15. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    business techno babble and I get asked what does this mean in stage 1? And this in stage 2? (There are over 100 stages)... Below is my template project initiation plan (project mandate?) for my freelance website development process. It may look clean,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  16. Embed an FLV file into a web pagehttps://www.joellipman.com/articles/cms/website-development/html/embed-an-flv-file-into-a-web-page.html

    your webserver. I like to use flowplayer for this example but my own systems can't use a solution as crude as this. Copy the below code (beginning and ending with object tags) Paste it into your HTML page Replace both instances of the text...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: *
  17. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    Put the cursor in the field and press F1, this will give you the name of the field, its entity and dictionary. My example below will use the Decision/date and Response/date fields (rather than the CAP_IDRC). This demo will use the key fields from the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  18. Zoho CRM: Update Opportunity Type as New or Existing Businesshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-opportunity-type-as-new-or-existing-business.html

    "Fn - Sales Orders - On Complete" Give it a function name, I'm calling mine: fn_SalesOrders_OnComplete Paste in the function below In the rightmost bar, you will see a pair of tabs one which has (x) and the tooltip "Arguments" click on this Type p_SoID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  19. Zoho People and Zoho Analytics: Push all Employee Salary Data to Analyticshttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-and-zoho-analytics-push-all-employee-salary-data-to-analytics.html

    changes as well. I don't want to use up 1200+ API calls either to do it which my script for performance goals did. The below will do it with 7 calls (to get 7 pages of 200 records) and 1 call to push into Zoho Analytics... Create the Zoho Analytics...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  20. Display a thumbnail of a Google Drive videohttps://www.joellipman.com/component/content/article/display-a-thumbnail-of-a-google-drive-video.html?catid=61&Itemid=165

    file, in this case a video file. How? The hardest part of this is to get the Google Drive File ID (which you need for the below). The image link (src) will be as below but then this is a redirect to the actual thumbnail stored by Google Drive:...

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