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

  1. Error 1065: Query was Emptyhttps://joellipman.com/articles/else/database/mysql/error-1065-query-was-empty.html

    to do when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and double-quotes ("). But who can honestly build a system that thinks of everything...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Country Lookup by IP address CSVhttps://joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    feedback. It's FREE to download unlike others which is probably why I made the generator in the first place but I do like to make people sign up so I can gauge the level of interest.

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  3. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://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

    want to export for offline backup. I have to raise and log a formal change request and follow a workflow process in order to make a change on a live system to a service user account... Especially one used by the scripts to access the database-driven...

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

    errors EventViewer (if Windows) errors.log (if Linux) Above and beyond Product Handover (branded pack with contact details - make it simple and friendly!!!) Warranty / Grace Period (agreed support period post production - fees and estimates) Behind the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  5. CSS keeping the footer at the bottomhttps://joellipman.com/articles/cms/website-development/css/css-keeping-the-footer-at-the-bottom.html

    different methods across the web but only 1 article worked for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: Header Left Right Footer Situation The header displayed fine. The left and right...

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

    with a Yootheme template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It isn't so much a miscalculation of 100% divided by 3 that leaves...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  7. FTP on Mac: Failed to retrieve directory listinghttps://joellipman.com/articles/cms/website-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

    was to change the options on the mac firewall by going into Settings > Security & Privacy > Firewall Click the lock to make changes Firewall Options Untick "Block all incoming connections" Leave the boxes ticked EXCEPT for "Enable Stealth Mode" Settings...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
  8. This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://joellipman.com/articles/cms/website-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

    By making some minor changes to the MediaWiki LocalSettings.php file, we can fix this. For demo purposes, I'm going to make our system recognize SWF files (by default these are disallowed): Firstly: Add the following line to somewhere in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  9. Sort an associative array by values in Javascripthttps://joellipman.com/articles/cms/website-development/js/sort-an-associative-array-by-values-in-javascript.html

    What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  10. Pure JS - Display Time Elapsed & Remaininghttps://joellipman.com/articles/cms/website-development/js/pure-js-display-time-elapsed-remaining.html

    but this is an example that I was coding and found to be one of the most reduced cut down formats I've made. I thought I'd make a note of it to not have to search elsewhere... This example specifically displays the time remaining on an access_token...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  11. Sun-Dried Tomato Basil Couscous Recipehttps://joellipman.com/component/content/article/sun-dried-tomato-basil-couscous-recipe.html?catid=96&Itemid=165

    tomatoes, green onions, and basil. This dish may be served hot or at room temperature. Use store-bought vinaigrette or make your own. Prep Time: 10 minutes Cook Time: 5 minutes Ingredients: 1/4 teaspoon dried garlic powder 1 package (10 ounces) plain...

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

    1.6.x+ websites - Thumbnail Service group restricted to 1 (Multiple support in J16?) - Update Server added - Tweaks to make it work in Joomla 1.6.x - Date Uploaded: Mon, 1st Aug 2011 1.4.4 - Removed the word "Hits" from popup and inline - Re-uploaded...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  13. Submit form as a server and not the client with cURLhttps://joellipman.com/component/content/article/submit-form-as-a-server-and-not-the-client-with-curl.html?catid=109&Itemid=165

    to a third-party API. The third-party only accepts requests from a static and permitted IP address. If the end-user were to make the request, then their own IP address would be the one checked against, and it just wouldn't be manageable to add every new...

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

    After several days... I tried the example as per the Apimo documentation and it worked! There were a few adjustments to make which I'm documenting here. Basic Example Here's a complete PHP script of a basic example of getting the agencies belonging to a...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  15. Crystal Reports: Exporting to Excel omits column headershttps://joellipman.com/component/content/article/crystal-reports-exporting-to-excel-omits-column-headers.html?catid=110&Itemid=165

    design view, only the circled headings would appear on the exported report: The solution I found that worked for me, was to make all the heading boxes the same height and to get rid of all the unnecessary extra gridlines (the ones that appear in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  16. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    in the worksheet. NOTE: Fields formatted so they are much wider than the actual size of the data can cause blank columns. Make sure the field width is just wide enough to display the longest data value. Cause 3: Fields and objects in the same column do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  17. DJI Phantom FC40 - Fun at the raceshttps://joellipman.com/component/content/article/dji-phantom-fc40-fun-at-the-races.html?catid=113&Itemid=165

    there is a vehicle underneath... Um, so I'm sharing the marshall's area. {youtube}L0uJyA6sXKk{/youtube} I reckon they should make drones that go right a tipped over car or bring it back to the track... Then again, couldn't those cars self-right...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  18. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Theatre Tokyo Warehouse More Art Terms These are ones mentioned by YouTubers that had an effect on the output (ones I didn't make an image of didn't work for me but I want to remember them in case I learn how to use them): YouTube - Making the Photo...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  19. A for loop within a for loop in MS-DOShttps://joellipman.com/component/content/article/a-for-loop-within-a-for-loop-in-ms-dos.html?catid=51&Itemid=165

    loop through the line it finds. Why? I use another technology for automation but sometimes the simpler solution is the one I make for other people to use. Explaining MS-DOS batch programs is a lot easier and colleagues trust these more than my...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  20. CSV Chart Generatorhttps://joellipman.com/component/content/article/csv-chart-generator.html?catid=53&Itemid=165

    interactive flash charts The program was intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file.

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 101 - 120 of 130