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

  1. 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

    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! Instructions: Go to Google Search Search for "Free MySQL database manager" (preferably add...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Convert foreign characters to English alphabethttps://joellipman.com/articles/else/database/mysql/convert-foreign-characters-to-english-alphabet.html

    properly as it thinks "riviere" is different to "rivière". We need to ensure that a search for any of these kind of words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  3. MySQL: Count occurrences of words in a columnhttps://joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  4. Some milestones for a website projecthttps://joellipman.com/articles/cms/website-development/some-milestones-for-a-website-project.html

    the nature, objectives and features of the website. Design document - a detailed plan of the website’s features and how it will display are generated from the concept and presented to potential publishers. Technology demo – a prototype that demonstrates...

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

    functions used in the system? (do this yourself anyway and use theirs as a guide only) Site Authentication Method(s) (will this need to be rewritten? eg. clear-text passwords) Level of Security Testing (XSS and SQL-Injection at least?) Referenced common...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  6. Display Feeds to major Social Networkshttps://joellipman.com/articles/cms/website-development/display-feeds-to-major-social-networks.html

    } }(document,"script","twitter-wjs"); Instagram Not sure on this one as I could only embed a specific video manually. Will update this if ever a free method for embedding the page comes up. Go to Instagram and open the video/picture to embed Click the 3...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  7. CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://joellipman.com/articles/cms/website-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

    their terms and conditions in quote/invoice templates and want the HTML to be indented neatly. Other examples out there will work, but I found that once the list count increased the number of digits (eg. 1.10) the text would be more indented (relative)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  8. CSS Center an iFrame Horizontally and Verticallyhttps://joellipman.com/articles/cms/website-development/css/css-center-an-iframe-horizontally-and-vertically.html

    How? We're going to use a touch of CSS and instead of determining heights and alignment with JS. The following code will work with DIV layers but in this case, also works on iframes: HTML: Horizontally and Vertically Centered Iframe CSS: body {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • 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

    y ? 1 : 0; }); // use built-in JSON stringify function newSortedArrayObject = JSON.stringify(my_records_copy); // note: will convert single apostrophes to double-quotes // split by closing curly brace var myRecords = newSortedArrayObject.split('}'); //...

    • 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

    is generated from an OAuth 2.0 process. I want to display to the user how much time is left before another access token will be generated and how long ago was the last token created. How? So almost pure JS. I'm working out the seconds remaining and...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  11. Convert Past Date to Time Ago in PHPhttps://joellipman.com/articles/cms/website-development/php/convert-past-date-to-time-ago-in-php.html

    Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  12. Add attribute xsl:nil=true on empty elements using XSLThttps://joellipman.com/articles/cms/website-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

    than 0 (not blank) and change the attribute of the element so that it's tag displays "xsi:nil=true". If...then...else... will be emulated by the XSLT choose...when...test...otherwise: true true -- yields: assuming value of DATE_OF_BIRTH is blank or null...

    • Type: Article
    • Author: Joel Lipman
    • Category: XML Stylesheet Language Transformations
    • Language: *
  13. Tagliatelle alla Carbonarahttps://joellipman.com/component/content/article/tagliatelle-alla-carbonara.html?catid=96&Itemid=165

    cooking water. 5. Immediately add the pasta to the prosciutto mixture, then stir in the egg mixture - the heat of the pasta will cook the egg. 6. Add the reserved cooking water if the sauce seems too thick, then stir in the remaining prosciutto and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  14. How To Make Chocolate Chip Cookieshttps://joellipman.com/component/content/article/how-to-make-chocolate-chip-cookies.html?catid=96&Itemid=165

    chip cookies, and with VideoJug's special recipe, it's easy to make the perfect chocolate chip cookie every time. You Will Need: 150 g sugar 160 g brown sugar, , packed 220 g butter 2 eggs, , large 2 tsp vanilla extract 280 g all-purpose flour 1 tsp...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  15. 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

    How? It's likely that you already know how to submit a HTML form to a server via your Mobile application so the following will only document the process of sending data under the server IP address. We're going to use a PHP script with the cURL function...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  16. 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

    Position..." Paste the same height value as the one that worked Repeat for all heading textboxes that weren't appearing This will yield something like the following: A few other things that I did to this report that may have contributed to it working:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  17. Excel PivotTable Filter List Orderinghttps://joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    if the year dropdown has a list of 2010, 2011, 2013; then if you add an entry which has year 2012, then the dropdown list will be in the following order: 2010, 2011, 2013, 2012. The Solution Bring up the field list of the report (so you see the fields...

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

    without VBCode and other suggestions. Instead I add a newline in front of and after the smallest data value (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  19. MS Excel - Sort pivottable column headings by datehttps://joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    as the 008th of April? What if we didn't use parentheses? Then it wouldn't be evaluated as an expression and perhaps Excel will be forced to treat it as a string: Another alternative to round brackets, square brackets! Additional: I have made this work...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  20. Excel - Check a column for values found in another columnhttps://joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

    not relative). Sheet1!A1 is the cell to search for those words. Note how I don't add a dollar, this is so that the formula will apply to each row and increment based on how you copy the formula to other cells. You should end up with something like this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 321 - 340 of 362