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

  1. Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

    AS [DB1_Table], t2.TABLE_NAME AS [DB2_Table], t1.COLUMN_NAME AS [DB1_Column], t2.COLUMN_NAME AS [DB2_Column], t1.COLUMN_DEFAULT AS [DB1_ColumnDefault], t2.COLUMN_DEFAULT AS [DB2_ColumnDefault], t1.IS_NULLABLE AS [DB1_ColumnNulls], t2.IS_NULLABLE AS...

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

  2. Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    - Applies to Joomla 2.5.x +, 3.4.x What? So I can't stand the way the default "Search" component in Joomla works. The default is to sort the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in...

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

  3. Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

    Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is 3306. Specifying port Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Named pipes...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *

  4. Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    It took a few google searches until I could find out how to change the default weblinks order. A lot of websites showed how to do this via the admin back-end panel in the advanced configuration... I can't see this panel, there is no advanced parameters...

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

  5. MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

    destination :: Destination Dir (drive:\path or \\server\share\path). file :: File(s) to copy (names/wildcards: default is "*.*"). :: :: Copy options : :: /S :: copy Subdirectories, but not empty ones. /E :: copy subdirectories, including Empty ones....

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

  6. Joomla Component: Set default params on installationhttps://joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    I'm making a custom component for Joomla CMS 2.5.x which is restricted to registered users only. On installation, and by default, the menu item returns a 500 - Server Error because the parameters haven't been set. I need to go into the Joomla Admin...

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

  7. Add default to a picture buttonhttps://joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

    I couldn't get any of these working and they looked more confusing then anything else. My solution is to set up the default button and the image to respond to the ENTER key after you typed something (this is for a search feature) in addition to having a...

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

  8. Windows 7 and Google Chrome incognito mode by defaulthttps://joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

    as you can just right-click on the google chrome icon and select "New Incognito Window". This is just how to set it by default (useful if you do online banking, shopping, etc). Right-click on the Google Chrome icon in your taskbar Right-click on Google...

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

  9. Set default parameter dates to start and end of monthhttps://joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

    and reading up on is asking for an article on my own site. Besides this is how I did it and what worked for me... Set the default values for your from and to date respectively: -- From Date (european format - dd/mm/yyyy) =CDate("01/" +...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  10. Change the default Joomla Error templatehttps://joellipman.com/articles/cms/joomla/change-the-default-joomla-error-template.html

    What? This is a quick article on what I change the error page for Joomla websites to. I like a clean error page, for a demo visit http://www.joellipman.com/my_error_page. Applies to Joomla 1.6.x, 1.7.x, 2.5.x How? Backup the file...

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

  11. SSRS Expand specific drilldown by defaulthttps://joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

    I thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  12. K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html

    Warning: Invalid argument supplied for foreach() in /home/public_html/administrator/components/com_k2/views/items/tmpl/default.php on line 80 If I went to K2 Comments, I'd get an additional error: Warning: Invalid argument supplied for foreach() in...

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

  13. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    -- Step 1) Import banner clients from J15 and insert into J30: -- - Assign a default state of published (state did not exist in J15) INSERT INTO `my_new_database`.my_prefix_banner_clients ( `name`, `contact`, `email`, `extrainfo`, `state`,...

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

  14. Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

    Const SW_SHOW = 5 Const SW_MINIMIZE = 6 Const SW_SHOWMINNOACTIVE = 7 Const SW_SHOWNA = 8 Const SW_RESTORE = 9 Const SW_SHOWDEFAULT = 10 Const SW_FORCEMINIMIZE = 11 Const SW_MAX = 11 ;#End Region ;#Region SetWindowPos Z Order Const HWND_TOP = 0 Const...

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

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

    bulk of this work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN DECLARE i INT DEFAULT 0; -- total number of delimiters DECLARE ctr INT DEFAULT 0; -- counter for the loop DECLARE str_len INT; -- string...

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

  16. Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

    TABLE table_name MODIFY COLUMN misplaced_column AFTER other_column; NOTE that annoyingly the column doesn't retain the default properties it had before the move so I guess this has to be included: ALTER TABLE table_name MODIFY COLUMN misplaced_column...

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

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

    FUNCTION UFN_DATASCRAMBLE ( p_original_value IN VARCHAR2, p_original_datatype IN VARCHAR2, p_original_range_1 IN VARCHAR2 DEFAULT NULL, -- no effect on strings p_original_range_2 IN VARCHAR2 DEFAULT NULL -- no effect on strings ) RETURN VARCHAR2 IS...

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

  18. T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data Not Yet Available". Unfortunately the end-user reported these default values sometimes...

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

  19. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    Joel Lipman) - Initial release More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetNotificationPreferences Documentation:...

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

  20. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

    video on how to do this: Youtube - Matt Wolfe - Install Stable Diffusion Locally. Ok it isn't MidJourney... But it's free. Defaulting some parameters to be added to every prompt /prefer suffix This defaults certain arguments to any prompt you submit. I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 1 - 20 of 119

Joes Word Cloud

Please publish modules in offcanvas position.