Vertically align an asterisk on a linehttps://joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 beneath it (in this case #2) so when a user clicked on #2 they would in fact be clicking on the item containing the asterisk above it. Objective Box List Before: Box List After * 1 2 3 * 1 2 3 How? Decrease the line-height of the asterisk and vertically...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Background Gradient Disappears on Long Pageshttps://joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 !!! */ background-color: #f7f7f7; background-clip: padding-box; border-radius: 0 0 5px 5px; Example Additional The above issue happened when using Google Chrome v23 or MS Internet Explorer v8 (so Webkit and MSIE appear to be affected). If your website...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 can simply select all files in LIVE (except for configuration.php) and copy these to TEST using the web-based file manager. Above & Beyond Creating subdomains allows your developers to simply change the http://www.mysite.com to your development...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 manage to do what you want them to do. What? I want to create a desktop shortcut that I can double-click and it will run the above programs in administrator mode without confirmation by the Windows operating system. At home this may not be a problem but...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 value C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The affecting TNSNAMES.ORA file for the above setup is located in "C:\app\\product\11.2.0\client_1\Network\Admin". I also checked that the data therein matched the...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

SSIS Skip Rows in Excel Source filehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 you should see the name of the Excel worksheet you specified as the datasource (eg. "Sheet1$"). Using the example above: Sheet1$A11:AL12 Selects all data from column A, row 11 up to Column AL, row 12 (so 2 rows will be returned). Sheet1$B11:AL Selects...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

MS Excel - Sort pivottable column headings by datehttps://joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 "Row Labels" and sum "Values". But because the next time this happens, I would have to repeat this, I would advise the above steps to remove parentheses.

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 both databases and you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the above which does a little more of the work, requires in the following query for you to replace the terms "myDB1" with the first...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Call to a member function mark() on a non-object in Joomla CMShttps://joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 This is a quick note on one reason you may get the above error in a Joomla CMS environment. Call to a member function mark() on a non-object in /public_html/index.php How? Not really a solution here because this is indicating that the system can't find...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

T-SQL: Parse an XML valuehttps://joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 *' This is because more than one record was returned so you need to surround with brackets and append a [1] as per the above example. Retrieving nodes -- to get all below nodes from root node - STAFF SELECT Event_XML.query('/STAFF') FROM...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 on "Apply" Include any additional entities as sub-entities under the parent one (not used in this demo) and repeat the steps above to select the exchange fields. Check/ensure the "In Use?" is ticked. Store/save your XET Setting up the Stu-Talk Message...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 map.animateCamera(CameraUpdateFactory.newCameraPosition(cameraPosition)); Just in case: AndroidManifest.xml The example above should have populated this correctly but if you are still getting problems, I have the following fields that I also use related...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Excel: convert degrees minutes seconds to decimalhttps://joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 formula: =IF(J1="E", L1, L1 * -1) There we go! Column M has your latitude and Column N has your longitude. With the example above, this should return: A B C D E F G H I J K L M N -------------------------------------- ---------------------- ------...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 or simplexml_load_string, it doesn't solve my problem. I'm receiving XML data within a cURL result but I get the above error with using either "SimpleXMLElement" or "simplexml_load_string". Returning the XML with cURL isn't a problem, but I want to...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Protecting your Joomla Administrator Sectionhttps://joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 admin images (joomla 3.x) RewriteCond %{HTTP_COOKIE} !JoomlaAdminSession=1234567890 # change this to the code to match the above PHP script RewriteRule .* - [L,F] How-to-use: Browse to the folder you created in step 1 and this will be your new...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 = htmlentities($my_description); $my_description = htmlspecialchars($my_description); Did I miss anything? So none of the above worked. If there is another solution out there, I didn't find one that worked otherwise I'd have included it in this article....

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Convert foreign characters to English alphabethttps://joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]' Joomla! Additional My Joomla website needed the following code to display the above foreign characters as entered into the Joomla administrators console with accents and all:...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

URL Alias uniqueness with PHP & MySQLhttps://joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 a value that already exists in the table, you will get an error in which case you could probably add another trigger like above but with BEFORE UPDATE ON my_table_name. Source(s): Online regex tester and debugger: PHP, PCRE, Python, Golang and...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 which blocks out swear words and the such. Experimental - DO NOT USE: string generateRetrievalCode() { //... refer to above functions } string generateKidSafeRetrievalCode() { // init v_Output = ""; l_BadWords = {"My","Bad","Words"}; l_TimesTried =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Convert Past Date to Time Ago in PHPhttps://joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 Thursday) $v_Str = getTimeAgo('first day of this month'); // yields "15 days ago" (it's the 16th) The same PHP function as above but somewhat minimized function getTimeAgo($p){ $s = strtotime('now') - strtotime($p); $a1 =...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB