Search - Joel Lipman .Com

41. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add ...; Created on 24 September 2015
42. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... MySQL statements against your database. For the purposes of this article, we will refer to the live/current/production website running Joomla v2.5 as "v25" and the new Joomla instance as "v34". Their ...; Created on 12 September 2015
43. Joes Word Cloud (JWC) Download: / Downloads /; ... - Minor fixes for previous release- Date Uploaded: Mon, 8th Aug 2011 1.6.7 - Bug Fix: Removed use of Joomla Core db->nameQuote function for old MySQL. - Enhancement: Check for W3C Validation and force ...; Created on 07 September 2015
44. 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
45. Submit form as a server and not the client with cURL: / API Miscellaneous /; ... MySQL and PHP (LAMP) setups. Why? A customer wanted to connect their Mobile App to a third-party API. The third-party only accepts requests from a static and permitted IP address. If the end-user ...; Created on 20 February 2015
46. 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
47. Registered Users Cannot Login - Super Users Can: / Joomla /; ... the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is "root". Login to your Joomla database using your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) ...; Created on 26 February 2014
48. Regular Expressions in SQL: / Databases /; ... surname does NOT contain a letter or number -- eg. O'Brien will NOT be returned as it contains letters MySQL And my favorite. Note the circumflex as we are still excluding non-alphanumeric ...; Created on 09 January 2014
49. Oracle: order by subquery missing right parenthesis: / Oracle PL/SQL /; ... the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g ...; Created on 05 December 2013
50. Modifying columns in a table: / Databases /; ... myColumn -- Reorder a column ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn; MySQL and Oracle PL/SQL ALTER TABLE myTable MODIFY myColumn myDataType Microsoft ...; Created on 24 July 2013
51. Reorder Columns in a Table: / Databases /; ... this: Method: MySQL ALTER 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 ...; Created on 22 July 2013