Search - Joel Lipman .Com

21. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; What A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE ...; Created on 20 March 2019
22. CSS Printing - Page Break Inside with Headers and Footers: / Cascading Stylesheets /; What? I saw a lot of articles that would cover this but I wanted an example which includes headers and footers and how to get an automatic page-break-inside to not overlap these. Fine on screen but ...; Created on 22 February 2019
23. Zoho Templates - Font size is inexplicably tiny: / Zoho /; ... I have other templates that work fine. How? The error is one of those that you wouldn't consider relevant in this case, after all, all styling was removed... Here are two screenshots to demonstrate ...; Created on 22 February 2019
24. GDPR Privacy Policy: / Static Items /; ... that the laws of the state of DEFINE_STATE, DEFINE_COUNTRY, without regard to principles of conflict of laws, will govern these Conditions of Use and any dispute of any sort that might arise between you ...; Created on 14 February 2019
25. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
26. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... text translation.- Date Uploaded: Wed, 2nd Nov 2011 1.5.3.4 - Fixed Bug: More variables now defined- Date Uploaded: Fri, 30th Sep 2011 1.5.3.3 - Fixed Bug: Undefined variables now defined- Date Uploaded: ...; Created on 07 September 2015
27. Copy a Wordpress Site for Development: / Wordpress /; ... values and just for myself to quickly modify a Wordpress configuration file. // ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', ...; Created on 08 March 2015
28. Excel: Extract hyperlink from link: / Excel /; ... a new module (Insert > Module) Copy and Paste the Excel user defined function belowSub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value = HL.Address Next End ...; Created on 06 November 2014
29. Basic Android App using Google Maps and Current Location: / AndroidOS /; Applies to: Android Studio (Beta) 0.8.6 Google Android Maps API What? I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely ...; Created on 10 October 2014
30. XML Schema Reference: / Extensible Markup Language /; ... by the schema appinfo Specifies information to be used by the application (must go inside annotation) attribute Defines an attribute attributeGroup Defines an attribute group to be used ...; Created on 13 August 2014
31. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... top 100 of your search -- then you must be limited on what you know about this person... Refine your search. -- This "where" clause returns zero rows if dob, reference, -- forename and surname parameters ...; Created on 07 March 2014
32. Export Joomla Users script: / Joomla /; What? Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which ...; Created on 28 February 2014
33. Oracle: order by subquery missing right parenthesis: / Oracle PL/SQL /; ... error. So you can see my parentheses are fine. Working Solution: SELECT ps.person_id, ps.person_name, ( select txt from ( select pa.person_text as txt, pa.person_reference ...; Created on 05 December 2013
34. Regular Expression Basic Usage Examples: / Web-Development /; ... sequence in your regular expression. The element you specify must be a defined collating sequence in the current locale. This operator lets you use a multicharacter collating sequence in your regular ...; Created on 28 October 2013
35. Creating a custom form field type for Joomla XML fieldset: / Joomla /; What? I'm writing a Joomla 2.5.x component for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom ...; Created on 25 October 2013
36. Joomla Component: Set default params on installation: / Joomla /; ... access to this file defined('_JEXEC') or die; // com_XXX is your component name class com_XXXInstallerScript { function postflight($type, $parent) { // $type (install, ...; Created on 24 October 2013
37. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; ... contains H,R,S ; continue This works fine at home on your local host on a local drive. Try using this over a networked drive and more time will be spent counting the files then the actual processing ...; Created on 04 June 2013
38. Change the default Joomla Error template: / Joomla /; 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, ...; Created on 04 April 2013
39. Parse a HTML Table into a ListView: / Hypertext Markup Language /; ... is the string of code you want to parse (all content). Function ExtractText extracts text given a unique string to mark the start of the extract (1a), a second string (1b) to refine the starting position ...; Created on 30 March 2013
40. Export/Import Database using MySQL Workbench: / MySQL /; ... If you're confined to use this product then this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. ...; Created on 05 February 2013