Search - Joel Lipman .Com

1. Run commands for Windows: / Windows OS /; What? This is an article intended for IT Support. It is a list of the system tools available in the Microsoft Windows OS that can be run from the "Start > Run" option. How? To Access…Run ...; Created on 05 July 2011
2. MySQL Commands to display all columns: / MySQL /; 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. ...; Created on 28 October 2010
3. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... a solution which sits on an external website and 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 ...; Created on 14 March 2024
4. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... commands Stealth Mode To keep images private, send these as direct messages to the Midjourney Bot. Just bear in mind that any image in a prompt can be accessed if people work out the link. "Stealth" ...; Created on 11 February 2023
5. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... 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 response will advise that it is running ...; Created on 24 October 2020
6. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... arrays. I can also output 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 ...; Created on 02 February 2019
7. MySQL Transactions in PHP: / MySQL /; ... 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: ...; Created on 14 December 2016
8. Trim values along with the tab: / MySQL /; What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. ...; Created on 13 June 2016
9. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... 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 ...; Created on 12 September 2015
10. Reorder Columns in a Table: / Databases /; What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...; Created on 22 July 2013
11. The greatest invention in IT: / IT Support /; ... More? "By [undoing] repeatedly, you can gradually work your way back to a point before your mistake. This is convenient if you've made a mistake four or five commands back. It is marginally useful if ...; Created on 13 September 2012
12. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; ... 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 student, and then to use this number in a ...; Created on 16 January 2012
13. Joes DNS Correction (JDC): / Product Documentation /; ... 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, it should just start) ...; Created on 25 November 2011
14. Basic Webpage Controls with JavaScript / COM: / AutoHotkey /; ... of this tutorial is to teach the intermediate AHK user how to start using COM to control webpages. My goal is to provide methods for controlling webpages, similar to how the AHK Control Commands can control ...; Created on 05 July 2011
15. PHP & MySQL Search Engine: / Personal Home Page /; ... Inline Stylesheets '@[]@si', // Strip out Internal Joomla Curly Brackets commands? '@@si', // Strip out HTML tags '@([\r\n])[\s]+@', // Strip out white space ...; Created on 09 March 2011
16. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... 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 used (DO NOT CONFUSE ...; Created on 30 January 2011
17. MySQL Oracle equivalents: / Databases /; The title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands ...; Created on 27 September 2010
18. K2 Items disappear: / Joomla /; ... 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 ...; Created on 27 August 2010
19. Licence GNU/GPL: / Static Items /; ... 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. ...; Created on 03 April 2009