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

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

    was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling....

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  2. Generate Academic Calendar using MySQLhttps://joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

    year for referencing by staff/students. How? Let us assume that we have a system holding a calendar in the following table (called "joes_weekstructure"): ID AcademicSet WeekNumber StartDate --------- ----------------- --------------- ------------------...

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

    So this is an article to note an oddity when I was working 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...

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

    file upload processing won't work. The name of the file is important but you can call it what you want, in my case I've called it 'uploaded_file'. 2. Check that the destination directory is writable by Apache. This is the full path to the folder that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  5. URL Alias uniqueness with PHP & MySQLhttps://joellipman.com/articles/cms/website-development/php/url-alias-uniqueness-with-php-mysql.html

    any character that isn't a letter, a number or an underscore. How? Suppose the following exists as a MySQL database table called my_table_name: What we have: /----------|-------------------|----------------------\ | id | name | url_alias |...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  6. Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    Version Platform ChangeLog Options 3.2.4 - Fixed Bug: Some systems report "Strict Standards: Non-static method called" - Note: not included in auto-update as it only applies to certain environments. - Note: this version is also backwards compatible...

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

    another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence...

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

    as quick commands Type /prefer option list to see what custom options you already have. By default you should have one called "wallpaper": /imagine a flower // returns 4 square pictures of a flower /imagine a flower --wallpaper // appends "--w 1920 --h...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  9. Passwords: Did-you-knowhttps://joellipman.com/component/content/article/passwords-did-you-know.html?catid=116&Itemid=165

    following is a list of items I use to include on password checker pages: A program called LC4 (formerly L0phtCrack) used by governments and the military boasts being able to crack 90% of user passwords in under 48 hours on a Pentium II/300....

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  10. After installing rokstories, get invalid argument 106https://joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

    I did this just to follow along with the solution. You need to make a menuitem to just one of the articles. I have a menu called "unused menuitems" (named unusedmenu), which isn't displayed anywhere on my site. I'm guessing the reference in the database...

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

    the menu manager > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in your Menu Item called "Home" must be set correctly for the article ordering you set in your Front Page Manager to take effect. To set them, do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. JComments errors in PHP 7: plgContentJComments and JCommentsACLhttps://joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

    During a site upgrade, the commenting extension for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  13. VBScript to retrieve Windows Product Keyhttps://joellipman.com/component/content/article/vbscript-to-retrieve-windows-product-key.html?catid=80&Itemid=165

    one). How? I'm going to use my trusty notepad program, copy the following code to it, and run it: Create a notepad file called read_product_id.vbs Copy the following code to the file: Set wshShell = CreateObject("Wscript.Shell") MsgBox...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  14. Regular Expressions in SQLhttps://joellipman.com/articles/else/database/regular-expressions-in-sql.html

    use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows: SELECT *...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  15. The Sandpithttps://joellipman.com/component/content/article/the-sandpit.html?catid=115&Itemid=165

    I saw this on BBC News Click and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 101 - 115 of 115