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

  1. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    the title doesn't put you off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  2. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    to tell MySQL WorkBench 6.0 to "use the old authentication protocol": • For versions before 6.0.7 • For versions after 6.0.7 Method #3 (Recommended): Do not use MySQL WorkBench!!! Seriously, your pride will slow you down or get you sacked!...

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

    I started maintaining the project, a revamp had been agreed with another web team. This has been delayed somewhat and still after 2 years there is no new site (blamed on the customer for not knowing what their application did in the first place... tut...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  4. What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    me.". "Hang on its on the other side of the room.". This was a remote support job over the phone. The discussion above was after installing drivers and setting up the workstation with updates etc. as per our standard image. The printer was connected via...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  5. Vertically align an asterisk on a linehttps://www.joellipman.com/articles/cms/website-development/css/vertically-align-an-asterisk-on-a-line.html

    often increases the line-height and causes the overall line height to change for other objects in the same row. The problem afterwards was that the asterisk character would overlap the item beneath it (in this case #2) so when a user clicked on #2 they...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  6. Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

    ; Needle1a is a marker for a unique value in the whole content Needle1b := " " ; Needle1b is a marker for a value located after Needle1a Needle2a := " " ; Needle2a is the closing marker ; get table HTML Needle1 := InStr( Haystack, Needle1a, false,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  7. Slideshow div layer through a windowhttps://www.joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    Known Issues If the end-user clicks too quickly between slides, the slides are not ready or not in the right position until after 1 second --> reduce transition duration? No MooTools Vertical/Horizontal Fx.Slide? couldn't get it to have that smooth...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
  8. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    'ISO-8859-15', true), ENT_COMPAT, 'UTF-8'); My other fix (for Croatian characters and Western languages): // insert after database connection and prior to database query (where $db_conn is your mysqli connection) mysqli_set_charset($db_conn,"utf8"); //...

    • 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

    up to running the monitors and populating an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which will be specific to your business requirements. Why? If you're developing in...

    • 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

    not already in list. - Date Uploaded: Wed, 20th Jul 2011 1.6.5 - Bug Fix: Keyword Exclusion List removes spaces before and after all words. - Date Uploaded: Mon, 18th Jul 2011 1.6.4 - Added Joomla! Admin Option: Module Content Caching - Added Joomla!...

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

    a Non-SSL-Enabled host. How? Previously, I would have used cURL but for some reason, I couldn't get the configuration right. After several days... I tried the example as per the Apimo documentation and it worked! There were a few adjustments to make...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  12. Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/component/content/article/excel-convert-degrees-minutes-seconds-to-decimal.html?catid=110&Itemid=165

    (for importing to a database where DECIMAL(10,7) ). Merging the lot If B1 contains the coordinates and there is a space after the first letter (N or S): // for latitude =IF(MID(B1,FIND("″",B1)+1, 1)="N", (MID(B1, 1, FIND("°", B1)-1) +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  13. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/component/content/article/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html?catid=113&Itemid=165

    decided to repair the hull integrity of my DJI Phantom FC40 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  14. Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    and will offer to ship them from an overseas location, or even get you to book seats on a plane. These are usually sought after dog breeds such as English Bulldogs, Yorkshire Terriers and Chihuahuas. These ads are usually accompanied by staged pictures....

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  15. Zoho People Analytics Regional Configurationhttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-analytics-regional-configuration.html

    workspace and select all the tables with this filter to import in one go. Schedule to Every ‘N’ Hours > 3 hours > Notify me after 5 consecutive failures trigger when at least 10 tables fail. Also notify “All Organization Admins”. Go to “Data Sources”....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  16. COVID-19: Working from Homehttps://www.joellipman.com/component/content/article/covid-19-work-from-home.html?catid=45&Itemid=165

    during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my back is suffering terribly. I figured on a personal DSE assessment and setup my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  17. Add default to a picture buttonhttps://www.joellipman.com/component/content/article/add-default-to-a-picture-button.html?catid=48&Itemid=165

    more confusing then anything else. My solution is to set up the default button and the image to respond to the ENTER key after you typed something (this is for a search feature) in addition to having a button if the user would rather click then press...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  18. Joomla - How to preview module positions in a given templatehttps://www.joellipman.com/articles/cms/joomla/joomla-how-to-preview-module-positions-in-a-given-template.html

    like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after your website URL: http://www.yourdomainname.com/index.php?tp=1&template=thetemplatename where yourdomainname.com is your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  19. Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

    Having trouble ordering your frontpage articles? After re-ordering articles wondering where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  20. Link to a Joomla article from within another articlehttps://www.joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

    Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article even when you have Search-engine-friendly website addresses...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
Results 101 - 120 of 130