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

20 August 2012 that Joomla versions 1.6 to 2.5 included in their basic install (vanilla/out-of-the-box). Will not work with Joomla 1.5 or less - Not 100% sure about this but I tried the example in the Official Joomla Documentation and I couldn't get it to work. They...

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

Battery Constantly Drained on iPhonehttps://www.joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

27 November 2012 order to "remind you". The reminder here was to charge the phone but it was the reminder which would drain a full charge in less than a day.

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

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

04 March 2013 databases the same version? It's due to the fact that these aren't our databases, we simply help support them. You say less than ideal, I say realistic. Quit complaining about processes and management and instead prove your worth. I'm good at what I do...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 registration form... There are two solutions I have found that fix the problem: Method #1 I prefer this method as it changes less code and is more likely to be supported in a Joomla update. Open the file /plugins/captcha/recaptcha/recaptcha.php and find...

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 but it's coming out really nicely Sparkly! and Shiny Hmm... wrong way round, the compass cable seems to go across the unit unless I have the top sticker wrong Legs on Checking vents (note I had masked these before painting as per youtube videos)...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 AutoDebug: Display module parameters. - Fix Bug: Removed check for "approved" column in weblinks. - Applies to PHP v5.3 or less - Date Uploaded: Fri, 21st Jun 2013 2.2- Removed popups option - Added Parameter: Optional Registration Key - Added Thumbnail...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 outline of the whole process: Backups Install Users Categories -- unstable Content Weblinks 3rd-party: JComments Here's a less brief outline of the whole process: Pre-Notes: To begin with, ensure that no extra new users are created in the v34 system...

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

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 The parameters you are sending are not in the right format. {"code":15,"message":"Please ensure that the attachment has less than 100 characters."}: The attachment parameter is populated with the file content instead of the internal file name....

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 up. If you have low limits, even 2000, this means you can only upload 100 products a day if they each have 20 photos (even less products then that as the upload of a product costs 1 API call). But I have found you can submit all photos in one go as...

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

Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 messages if(!isNull(r_Result.get("id"))) { // do stuff to each record... info r_Result.get("id"); } } // // stop looping if less than 200 records on this page if(l_SearchResults.size()...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 div.zc-Calendar_Day_Select .choice-table-row{float:left} And finally, I want to make the chevrons (less than and greater than sign) massive: div.zc-Calendar_Day_Select .choice-table-cell span...

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

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 = 1; // // specify the maximum number of products you think you have on eBay // the actual number will be less than this but this is for pagination estimates v_MaximumProducts = 1500; // // now let's generate the page list to have all the available...

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

Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 have on eBay (check eBay homepage and see number of sales [ will be rounded to nearest 1000 ]) // the actual number may be less than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by...

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

Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 // // key here to enable inventory tracking m_CreateBooksItem.put("item_type","inventory"); // // other less important values to include re purchase information m_CreateBooksItem.put("product_type","goods"); m_CreateBooksItem.put("reorder_level",0);...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 task: Create a workflow that runs on lead create (record action) and the criteria can be where "Lead Conversion Time" is less than 4 (4 days not 4 business days?). Though I've removed this condition since go live and simply specified "All Leads". I'm...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 Here's the immediate solution I have applied now until Zoho enable an option to round via API with a 10th of a penny/cent or less. After creating or updating the invoice, add in the response line something like the following: //... UPDATE INVOICE...

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

Can't play music after Firmware Update Version 3.0https://www.joellipman.com/hardware/cant-play-music-after-firmware-update-version-30.html

21 September 2009 Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 it exists IF OBJECT_ID ( '[dbo].[myUserTable]', 'U' ) IS NOT NULL DROP TABLE [dbo].[myUserTable]; GO Types for sys.objects (less used by me) AF = Aggregate function (CLR) C = CHECK constraint D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY...

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