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

  1. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    DECLARE @DateMatch int; DECLARE @TimeMatch int; DECLARE @ColumnTypeIsDate int; -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET @OrigLen =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  2. DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    int; DECLARE @IntOptions int; DECLARE @CharOptions varchar(max); -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET @OrigLen = LEN(CAST(@OrigVal AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  3. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    There are reports though that some people set up websites with NO 3rd-party items whatsoever... For those of you with this issue, I'd double-check your website host allows Joomla and if they don't, look for either an upgrade or a different host. If your...

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

    http://www.buydomains.com/ http://www.sedo.com/ When you have registered a domain name, please tell us and we will issue you the assigned NameServers to point your domain at (done via your domain registrars control panel). Styles, Visuals and Source...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  5. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    - the spec) Details on the Development Environment (is there a TEST system and deployment procedure in place?) Known Issues/Bugs (is there an "Issues Log"? Anything that still needs addressing?) System Requirements (in case you need to transfer/move to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  6. Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/cms/website-development/css/three-boxes-two-roll-over-one-falls-out.html

    the problem. I'm guessing this was because 990 divided by 33 leaves a remainder of zero but I'm not 100% sure this fixes the issue throughout other systems. IMO: Somewhere in the Javascript (based on jquery), the script is using the remainder when it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  7. Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

    Issue Basically you have a HTML form with an input field type of 'FILE' (ie. ) and want a PHP file to process this. This example applies to a Linux Apache MySQL PHP (LAMP) environment. The Solution 1. The first thing to do is check that your HTML form...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  8. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    Great! Few problems though, multiple terms are not supported; quotation marks and apostrophes may be an issue; Full PHP: $sanitized_search=(isset($_GET['search'])&&($sanitized_search==""))?trim(strip_tags(addslashes($_GET['search']))):""; # 2 functions...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  9. 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

    TIN, DIN run. Testing: No records are being processed despite relevant ones existing and all monitors run I would get this issue if I cloned an existing process (released an existing one, made changes, stored it as a new one) Check the DOT for records...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  10. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    Label parameters in XML and language file review - Date Uploaded: Tue, 18th Mar 2014 3.2 - Fixed Bug: Redeclare function issue when used multiple times - Date Uploaded: Mon, 17th Mar 2014 3.1 - Backwards compatible with Joomla 2.5.x - Modified for...

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

    Joomla Extension Update Manager corrected. - Date Uploaded: Wed, 4th Jun 2014 3.0.1 ThomasM - Fixed Bug: Strict Standards Issue: New Operator removed for PHP5+. - Fixed Bug: Object without reference: Child object design converted to Object array. - Date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  12. Xero API: Send Multiple Invoiceshttps://www.joellipman.com/articles/else/fintech/xero/xero-send-multiple-invoices.html

    A really quick article for anyone who got stumped by the same issue: How to send multiple invoices to Xero in one API call? Why? Our use-case is in Zoho Deluge which couldn't generate more than 5 invoices in a scheduled task because Xero only allows 5...

    • Type: Article
    • Author: Joel Lipman
    • Category: Xero
    • Language: *
  13. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    in adjusting row height would be like a magician revealing the secrets to his tricks... no it wasn't really, time was the issue. Additional conditions Direct access to our databases, both development and production, means that anyone with access to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  14. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    later it still wasn't working. I followed the process above and it took immediate effect... Update 2024 So I've run into the issue that when downloading the certificate from GoDaddy and followed the steps above but it kept showing the certificate for...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  15. Joomla: Unable to find install packagehttps://www.joellipman.com/articles/cms/joomla/joomla-unable-to-find-install-package.html

    This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to resolve this, he had to do a fresh install and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  16. Restoring your WYSIWYG editor after upgrading Joomlahttps://www.joellipman.com/articles/cms/joomla/restoring-your-wysiwyg-editor-after-upgrading-joomla.html

    The Issue Basically that after upgrading Joomla, my TinyMCE WYSIWYG (What-you-see-is-what-you-get) editor halved its number of buttons and I couldn't add code snippets... The Fix Just installed JoomlaFCK WYSIWYG Editor, an editor I use with my day...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  17. Changing the yourdomain.com for phpBB3https://www.joellipman.com/articles/cms/joomla/changing-the-yourdomaincom-for-phpbb3.html

    This is related to the issue of renaming yourdomain.com as your title page in phpBB3. You need to login to the phpBB admin control panel (ACP). On the General tab, look under Board Configuration and click on 'Board Settings'. The Site name is the first...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. Joomla banners not rotatinghttps://www.joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

    The issue here is that you have added all your banners, divided between clients and categories and you're looking for a solution which doesn't involve installing a 3rd party applicatoin. Unfortunately the Joomla banner module only supports alternating...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  19. Error 404 Component Not Found when enabling SEF URLshttps://www.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

    I found I could disable the third-party SEF extension and enable my Joomla SEF settings... ??? This is a Joomla 3.x issue.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  20. SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 61 - 80 of 89