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

  1. Run commands for Windowshttps://joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

    Version (to show which version of windows) winver Windows XP Tour Wizard tourstart Wordpad write Source: 156 Useful Run Commands @ MyPCHell.com

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  2. MySQL Commands to display all columnshttps://joellipman.com/articles/else/database/mysql/mysql-commands-to-display-all-columns.html

    The scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. Zoho CRM: Remove Duplicate Product Recordshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    and will attempt to delete the other records which match on product name. I would recommend commenting out the delete commands and leaving the info commands to preview what records it will delete. I also recommend doing a data backup beforehand. Adapt...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    etc. The thing to watch out for is associating the categories with respect to the assets table. To do this via DB commands, refer to how the weblinks categories are added. Copy over Content: We want to maintain the same IDs for articles in case SEO...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Basic Oracle Stored Procedure Structurehttps://joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    A standalone query is faster in the eyes of SSRS, however within SSRS we don't have the capability to run standard PL/SQL commands... unless they're run from within a stored procedure. Our aim is to run a small query first to return the ID of the...

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

    victorian, detailed, full body hyperrealistic female" without the quotes to get the left image here). Type /help for other commands Stealth Mode To keep images private, send these as direct messages to the Midjourney Bot. Just bear in mind that any...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  7. Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

    using COM to control webpages. My goal is to provide methods for controlling webpages, similar to how the 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  8. Licence GNU/GPLhttps://joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    may convey the work under this License, and how to view a copy of this License. If the interface presents a list of user commands or options, such as a menu, a prominent item in the list meets this criterion. 1. Source Code. The “source code” for a work...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  9. Joes DNS Correction (JDC)https://joellipman.com/component/content/article/joes-dns-correction2.html?catid=53&Itemid=165

    As I love automation and reducing processes to single-click fixes, I made this teeny tiny program to run the above commands and check the error levels. Installation: 1) Decompress to a folder of your choosing 2) Run the EXE (there is no install process,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    like “/Users//joels_awesome_app” It will then initialize some NPM dependencies and it will ask you to type the following commands; to change current directory to the app directory and then to run the toolkit cd joels_awesome_app zet run The terminal...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. ZohoCreator: Basic Widget with Zoho Datahttps://joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-basic-widget-with-zoho-data.html

    which talks to Zoho, then setup an externally hosted web app with the usual JavaScript frameworks and have it send AJAX commands to a server which reads/writes information to your Zoho instance via API. No need for the Zoho Widget SDK. Why? At time of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html

    and should be repaired The Quick Fix I managed to fix this with this SQL command . Note: you need to be able to run SQL commands against your database. My client had phpMyAdmin installed so I click on "jos_k2_items" table and then click on the "SQL" tab...

    • 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

    "migrate_j15_to_j25_new_v1_6_pt3.sql". Part 2 is dedicated to content migration, the commands are split to do about 5000 articles on each iteration so as to avoid session timeouts and memory issues. Edit the script, renaming the database and table names...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  14. MacOs: Transcribe Training Video using OpenAI Whisperhttps://joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    It whisper --help Run the whisper on the original MP3: whisper output_audio.mp3 --model small Error(s): PATH breaks, no commands work: echo 'export PATH="/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Users//Library/Python/3.9/bin"' > ~/.zshrc...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  15. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    any of the variables and responses for debugging purposes. I can also unset multiple branches of variables with fewer commands than unsetting specific variables. Let's specify the output page to be in JSON format: // set content type of this page...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  16. Reorder Columns in a Tablehttps://joellipman.com/articles/else/database/reorder-columns-in-a-table.html

    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; Make sure you have the INSERT INTO commands if this includes website data!!! Drop the table Reload the script you just modified.

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  17. PHP & MySQL Search Enginehttps://joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    Strip out javascript '@ @si', // Strip out Inline Stylesheets '@[{].*?[}]@si', // Strip out Internal Joomla Curly Brackets commands? '@@si', // Strip out HTML tags '@([\r\n])[\s]+@', // Strip out white space '@&#(\d+);@e' ); $str = preg_replace($search,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  18. MySQL Oracle equivalentshttps://joellipman.com/articles/else/database/mysql-oracle-equivalents.html

    that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle - See if a table exists SHOW TABLES Select table_name from sys.dba_tables -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  19. Trim values along with the tabhttps://joellipman.com/articles/else/database/mysql/trim-values-along-with-the-tab.html

    rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` =...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  20. MySQL Transactions in PHPhttps://joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    } $mysqli->close(); mysqli->begin_transaction() requires PHP 5.6 and above. For lower versions you can issue the MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK") Important note: Our...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB
Results 1 - 20 of 21