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

  1. Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

    midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for those that it's obvious to... Compare the two timestamps, if the "To date" is less than the "From date" then add 1 day to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  2. Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

    Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...

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

    passwords) Level of Security Testing (XSS and SQL-Injection at least?) Referenced common files / global assets (especially those used in every page) Expert/Testing/Resistant users (contact details and informally their technical knowledge/skills)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  4. Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

    "profiles". So I should end up with the following file/directory structure: ./profile5 ./profile5/profiles Also copy one of those handy blank "index.html" files into each of these folders in case "directory listing" gets enabled on your server.I'm going...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. List all cron jobs for all usershttps://www.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

    "s/^ //" done; } # Given a stream of cleaned crontab lines, echo any that don't include the # run-parts command, and for those that do, show each job file in the run-parts # directory as if it were scheduled explicitly. function lookup_run_parts() {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  6. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

    AHK Control Commands can control Windows Applications. This tutorial is going to be high level, but will provide links to those who want to dig deeper into these concepts. You don't need to have much programming experience, but I will assume you feel...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  7. Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

    in the order that I entered them in the datasheet. Googling this led me to browse MSDN for an hour before I realised all those experts were using programming solutions that seemed a bit over the top for something that should be so simple. Hey presto, I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  8. Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

    can use the Chr() function: msgbox % Chr(24) ; upwards arrow msgbox % Chr(25) ; downwards arrow, unstable Generate list of those that work for you: loop 255 fileappend,% a_index . A_Tab . A_Space . Chr(a_index) . "`n",ascii-chartable.txt A bunch of...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  9. Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

    acyear WHERE NOW() >= acyear.StartDate ORDER BY acyear.StartDate DESC LIMIT 0,1 ) ORDER BY calendar.weekNumber For those of you who are familiar with this, I am simply using an alternative to the DATE_FORMAT() function in mySQL. Should yield:...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  10. Error 1065: Query was Emptyhttps://www.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

    Developers will have told the system what 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  11. Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    More for others than for myself, but this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  12. Delete related records from multiple tableshttps://www.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

    Management System (RDBMS) where deleting some erroneous rows in one table will cause errors because the existence of those rows is stored in another table, how do we delete from all the related tables as well? How? You need to refer to the tables just...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  13. Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

    For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is shady and varies from language to language, I've written this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  14. Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

    mode without confirmation by the Windows operating system. At home this may not be a problem but this is intended for those in an office environment and we get prompted to login (with the same account as we're currently logged-in with???) instead of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  15. Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    different products/services and these run off various instances of Oracle 9i, 10g, and 11g. This article was written for those that need to support these kind of systems and not as an invite for suggestions on how my business should be run. How? So...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  16. Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

    to see ALL connected processes as well. Why? For every DBA this is a doddle and doesn't warrant its own article but for those of us who merely use SQL Server Management Studio (SSMS) and Microsoft's SQL Server 2008 R2 for development purposes, the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  17. Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

    agreement between joellipman.com and you: Once I have the domain names, I will configure my server to receive requests for those domains (along with webspace and emails). Please wait up to 3 hours for these changes to cascade across my servers (average...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  18. Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

    the error was due to an update process gone wrong. Not really the fault of Akeeba, Joomla or anyone, it's just one of those things. Check the sizes of the PHP files on your site and hope that they're not at 0 bytes. Excluding the HOME folder - only...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  19. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    if I didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the new phone (not fun). The Apple documentation iOS: Transferring information from your...

    • Type: Article
    • Author: Joel Lipman
    • Category: iOS
    • Language: *
  20. XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

    within the containing element in an instance document keyref Specifies that an attribute or element value correspond to those of the specified key or unique element list Defines a simple type element as a list of values notation Describes the format of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: en-GB
Results 21 - 40 of 64

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.