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

  1. JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    $user_record, 'id'); // equivalent to UPDATE #__users SET name='Joel', username='jlipman' WHERE id=42 DELETE Note: for Joomla v3.x, use db->execute() instead of db->query() $db = JFactory::getDbo(); $query = $db->getQuery(true);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. Export Joomla Users scripthttps://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

    of your Joomla website. Access the page from a browser and you should get all your users listed... For security reasons, delete the file after you have used it. IT IS A SERIOUSLY BAD IDEA TO LEAVE THIS FILE ON YOUR WEBSITE FOR ANYONE TO ACCESS!!! DELETE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

    ways of doing this, the example below uses a command prompt to a) create a batch file b) use it to rename the files c) delete the batch file. Open a command prompt: Method #1 Open windows explorer to the folder you want to apply this to Hold down the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  4. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

    equipment • Your photos/pictures • Your preferences/settings • A private key to use JoelLipman.com data Note: You should delete/uninstall this app or clear its data before giving your device to someone else as it can login to your online account...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  5. AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

    } SplitPath, sFile, _FileExt, _Dir, _Ext, _File, _Drv If ( p[p.length()] = "xInfo" ) ; Last parameter is xInfo { p.Pop() ; Delete parameter fex.SetCapacity(11) ; Make room for Extra info fex["_Attrib"] := A_LoopFileAttrib fex["_Dir"] := _Dir fex["_Drv"]...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  6. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

    by icons relevant on your cPanel dashboard and then click on the "SSL/TLS" icon Click on the "Generate, view, upload, or delete SSL certificates" link in the right sidebar Scroll down and click on "Choose File" button under the "Upload a new...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  7. Migrate MediaWiki to another serverhttps://www.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

    database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new files to wiki...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  8. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

    into the format with the quality/size that is set in the program options. Consider this file temporary and if you want to delete/rename this and the images folder, the program will just create another one. Question How does the thumbnail name generating...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

    on install or something like that. I have not got the upgrade server for J16 working yet but soon. Also there's no need to delete a previous version of this module, just download the updated one, and install as per usual. IMPORTANT NOTES: All images in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

    Configuration) ipconfig /all IP Configuration (Display DNS Cache Contents) ipconfig /displaydns IP Configuration (Delete DNS Cache Contents) ipconfig /flushdns IP Configuration (Release All Connections) ipconfig /release IP Configuration (Renew All...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  11. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

    There are two options here: Create another dataset (would have to be the first dataset to load so you would need delete your current datasets then add them in the order you want them to load) to get the timestamp of when the queries started. IIF your...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

    the field that says "Columns". Right-click on the grey left margin and select "Insert Row" then "Outside Group - Below". Delete the row with the left parenthesis Click on the dropdown of "Data" and select "TimeStamp". Click in the left of that column...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

    SET SQLStatement = 'SELECT * INTO SearchTMP FROM ' + Tablename + ' WHERE ' + substring(WHEREClause,1,len(WHEREClause)-5) DELETE FROM @SQLTbl WHERE WHEREClause IS NULL WHILE EXISTS (SELECT 1 FROM @SQLTbl WHERE ISNULL(Execstatus ,0) = 0) BEGIN SELECT TOP...

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

    files to ZIP file. Export LIVE database to SQL file. (Export > Custom > Save output to file) Except for configuration.php, delete all files in TEST folder. Drop all tables in TEST database. Copy all files from LIVE to TEST (Do not overwrite...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  15. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    Create a new setup project - File -> New Project... Under Other Project Types | Setup and Deployment, select Setup Project Delete User's desktop and User's Project Menus folders from File System (setup) screen. On Application Folder, set the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  16. Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    $defaults = '{"core.admin":{"2":0},"core.manage":{"2":0},"core.create":{"2":1},"core.delete":{"2":1},"core.edit":{"2":1},"core.edit.state":{"2":1},"core.edit.own":{"2":1}}'; // JSON format for the parameters, see PHP serialize()...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  17. Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

    To only restrict Guest or a Specific User: So undo the above if you didn't want this applied to the current logged-in user (delete the NoDrives DWORD). The concept of creating the NoDrives registry entry is what you need to remember. In the example...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  18. Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

    "dev1" (eg. dev1.myexample.com). How? A quick copy from copy 1 (LIVE) to copy 2 (DEV): Backup all files in LIVE environment Delete any files in DEV except for "wp-config.php" Copy all files except for "wp-config.php" from LIVE to DEV Copy the salt and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  19. AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

    ; Subroutine: ClearTreeView: Clears the current TreeView ClearTreeView: TV_Delete() Return ; -------------------------------------------------------------------------------------- ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  20. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    GenerateList: Generate/Populate list of files and their proposed new names GenerateList: SB_SetText("Generating...") LV_Delete() v_RowCount := 0 GuiControlGet, SelectedDir v_FilesPath := SelectedDir "\*" Loop, Files, %v_FilesPath% { ; skip if file ext...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
Results 21 - 40 of 51

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.