Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 in my day job so the Oracle SQL developer is already a pre-approved software for our work computers. We have SQL Server Management Studio (SSMS) as well for our SQL Server instances but it wasn't practical to link this to mySQL databases. How? So this...

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

Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 that I have obscured my personal settings in the following screenshot): In this screen, I've opted for Do not use Remote Management as I only want to export/import my database: Connected! Now click on Data Export in the left hand panel: In the screen...

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

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

04 March 2013 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 because I make do with what I have available and I've yet to fail in...

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

Client Services: Website Development Agreementhttps://joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 my own: I can keep costs low, I have scripts which have sped up development on similar projects, I have bespoke project management systems which manage my work accurately (eg. my Project Analysis Manager - dubbed PAM - can tell me how long it took to...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Generate a Timesheet in MySQL https://joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and activity logging. The example...

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

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

07 March 2014 in the real world. Where do the extra 9 minutes come from? Not the SQL as this runs in 00:00 seconds in SQL Server Management Studio. Not the internal processing and rendering as the report server says it did this in 0.4 seconds. So where's the problem?...

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

Include a carriage return in a column headinghttps://joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server Management Studio resultset. Remember to format the cells (column headings) in the Excel spreadsheet for it to wrap text and save the...

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

Joes Google Map for Joomla (JGM)https://joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 This article serves as documentation for a module extension I made for the Joomla Content Management System versions 2.5 or later. Why? Could have probably used someone else's. I think there's loads out there but thought making my own to do exactly what...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

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

13 June 2016 statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other...

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

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

17 October 2021 // deprecated // use inventory_levels m_Variant.put("inventory_policy","deny"); m_Variant.put("inventory_management","shopify"); m_Variant.put("inventoryItem",{"cost":ifnull(input.Shopify_Unit_Cost_Price,0).toDecimal().round(2).toString()}); // not...

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

Zoho CRM: Schedule a Task: Timesheet Reminderhttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-task-timesheet-reminder.html

02 December 2021 we're keep account of our time and we are currently logging time in our CRM. We're meant to do 40 hours, not just for Management, but for deducting from project and support bundles. How? The following snippet of code is on a CRM schedule set to run...

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

Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 'Rate_Year_3_0': v_DealRate3 }); ZDK.Page.getForm().setValues({ 'Rate_Year_4_0': v_DealRate4 }); // start subform management // ***************************************** // declare the new row and JSON argument var json_Row = new Array(); var json_Arg =...

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

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

29 March 2023 we retrieved the eBay active listings (see article link above), we're going to use the GetOrders call for order (sales) management. /* Function: fn_GetEbayOrders() Purpose: Queries eBay for all orders for a specified year Date Created: 2023-03-29 (Joel...

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

Zoho Deluge: Determine your Statement Execution Limithttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

31 July 2024 to the subscription will likely to have to be asked directly to Zoho rather than using the online subscription plan management section. Statement Execution Limit is 5000 The following will run resulting in the error "Number of statement execution limit...

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

Thank You for your donation!https://joellipman.com/thank-you-for-your-donation.html

08 August 2010 have their benefits and neither should go. My day job doesn't involve any Joomla! material but has many Content Management Systems (CMS) commercial equivalents. I use any donations to justify working on Joomla! specifically; but like to add things I...

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

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

03 August 2012 Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I...

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

Joomla field types clear my htmlhttps://joellipman.com/articles/cms/joomla/joomla-field-types-clear-my-html.html

09 August 2012 to store HTML code when the save command is clicked (ie. submitted from a PHP form). This is for the Opensource Content Management System (CMS - phew what a mouthful) Joomla! version 1.6.x to 2.5.x; no wonder customers have difficulty following. How? So...

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

SELECT COUNT(DISTINCT name) FROM tablehttps://joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT...

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