Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 script. for Yootheme: Warp 6: Yootheme template: -- note that Yootheme warp does not include the mootools-more.js file: -- reminder: check for conflicts Additional Notes You have no idea how long it has taken me to get this code in working order and as...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

29 October 2018 "parents": ["'.$folder.'"], "description": "'.$desc.'", "copyRequiresWriterPermission": true, "writersCanShare": false } Reminder: if you are adding the description, then pass this as a parameter to the above function. Source(s): Google Drive API v3...

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

11 February 2011 temporary files. Do we instruct all users viewing the reports to do this? When does this report automatically expire? Reminder on Paper Sizes A4 = 8.27in (width) × 11.69in (height) Letter = 8.5in (width) x 11in (height) Switch width's for height to...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

29 March 2011 FROM [ROOMEQUIPMENT] re INNER JOIN [EQUIPMENT] eq ON eq.EquipId=re.EquipId WHERE re.RoomId=@GivenRoom AND re.SetId=@setId Reminder: The counter = 1 means that if I call on the sum of these, I can check if zero rows were returned because...

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

SSRS Zero Paddinghttps://www.joellipman.com/component/content/article/ssrs-zero-padding.html?catid=75&Itemid=165

10 November 2011 Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 the string unaffected if it is not in uppercase SET @Ret=@Text END RETURN @Ret END Examples of what this script does: Reminder: The script only affects data already in UPPERCASE. Change the IF (UPPER(@Text)=@Text COLLATE Latin1_General_CS_AI) line if...

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

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

28 October 2013 A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 If field is "Joes Just Joking!" yields "JoesJustJoking!" -- If field is " Space is a big place " yields "Spaceisabigplace" Reminder: -- We're using this for a comparison condition and not trying to change the value.

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

Make bootstrap carousel responsive to swipehttps://www.joellipman.com/articles/cms/website-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

14 December 2016 A quick reminder on how to make the carousel in bootstrap compatible with touch devices like smartphones and tablets. Why? Feed back was that the user was unimpressed with the image slideshow. You have to tap on the left and right symbols... How? Some...

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

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for...

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

Disable User Registration in Joomla 1.5 - Configuration Filehttps://www.joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

08 October 2013 A quick reminder on how to disable user registration in Joomla! CMS version 1.5.x without using the Joomla! CMS back-end panel. Why? Because we're having some corruption issues and simply using the Joomla! administrator panel to navigate to global...

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

MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/component/content/article/ms-excel-open-csv-with-long-numbers.html?catid=110&Itemid=165

23 July 2019 This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID...

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