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

  1. Set up Desktop SlideShow in Windows 7https://www.joellipman.com/component/content/article/set-up-desktop-slideshow-in-windows-7.html?catid=80&Itemid=165

    to the picture location and it doesn't seem to remember which folder you selected. At home, this would be a breeze, but that's because I don't implement group policies at home. Why? We get problems with this because none of our staff are full...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB

  2. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    in MS Windows, you may need to find someone who is. How? As a proof of concept, let's see how to hide a specific drive. Note that this section applies to the currently logged-in user. To restrict other users, see the example after this one: Open the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  3. Apple Magic Trackpad with Windows 11 Intelhttps://www.joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

    but those instructions seemed only for those on an AMD or ARM processor. The process demo'd by LinxHype is the one that worked for me. Windows Intel These are the instructions that worked for me so I'm just storing these in case I need to do it again:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  4. Search a database for a value and count matching rowshttps://www.joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  5. Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

    came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  6. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    have 1 director, 2 managers, and 3 tape-monkeys Now suppose we had a convoluted query which needs to join the two tables so that we get the "MapOut" value: SELECT r1.MapIn ( SELECT (COUNT(e2.EmpType)-1) AS MyCount FROM DMExtractEmployeeTable e2 LEFT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  7. T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

    in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  8. Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

    This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of data. Why?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  9. MySQL Data Type Reference Tablehttps://www.joellipman.com/articles/else/database/mysql/mysql-data-type-reference-table.html

    Max length 4294967295 characters (4GB of text) Length of string + 4 bytes String Enum ('value','value2',...) String object that can have only one set of allowed values 1 or 2 bytes String Set ('value','value2',...) String object that can have one or...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  10. Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    I don't use the `id` columns of the tables as I'm quite content with just the two columns I requested. And for those of you that don't know, the alias "AS" is optional in MySQL (think it's optional for most SQL forms). I found that to add further...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  11. Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/else/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  12. MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    and users) rather than trying to join these, and to let PHP do a bit more of the work: User Query $t_value = $the_team_id_that_i_want_to_look_at; $user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, ' ', u.LastName) AS 'Fullname' FROM Users...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

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

    In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  14. Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

    your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  15. Convert foreign characters to English alphabethttps://www.joellipman.com/articles/else/database/mysql/convert-foreign-characters-to-english-alphabet.html

    to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other countries. This is nice but...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  16. Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    This is because the script is not changing the date at the stroke of midnight. Take the last row as an example, the equation that's happening is: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession'])); $this_time_from1 = date("H:i",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  17. 301 Redirect using htaccess filehttps://www.joellipman.com/articles/cms/website-development/301-redirect-using-htaccess-file.html

    There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  18. List of Font Awesomehttps://www.joellipman.com/articles/cms/website-development/list-of-font-awesome.html

    I needed to use these in a template I was working on. Font awesome is a brilliant tool for webdevelopers who want icons that can be any size of any color without compromising on image quality or overhead maintenance. It's basically a font set that has...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  19. CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/cms/website-development/css/css-background-without-causing-scrollbars.html

    webpage with background (where left is 0 [zero] because your width is 100%). Position the background image bearing in mind that your layer is 100% of the viewable browser page. .templateclouds { position: absolute; top:60px; left:0; background:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB

  20. Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

    what methods in AutoHotkey could you use to separate out the HTML Tables into a ListView. Why? I want a snippet of code that replicates any HTML table. How? I've been trying various ways so I'm posting them here. My opinions on them change with the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
Results 301 - 320 of 493