Stored Procedure to List Distinct Values and Countshttps://joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 + ''); DECLARE Cursor1 CURSOR FOR SELECT [Value] = T.c.value('.','varchar(max)') FROM @myXml.nodes('/root/s') T(c); -- Create temporary table to hold results CREATE TABLE #ListDistinctValuesAndCounts (myValue varchar(max), myColumn varchar(max), myCount...

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

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

20 November 2012 it would initially display properly but then the white background would disappear when the page finally loaded. How? The root cause was because the template I was using was not actually specifying "white" as the contents background-color and was in fact...

• 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 user account that can access the new database created in the previous step. Modify the configuration.php file in the root of the TEST site to reflect the usernames/passwords created in the previous steps. $sitename - I would suffix this with "TEST" so...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 User's Project Menus folders from File System (setup) screen. On Application Folder, set the DefaultLocation property to the root DTS directory (eg. [ProgramFilesFolder]Microsoft SQL Server\100\DTS) Right-click on the Application folder and add the...

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

Joomla Component: Set default params on installationhttps://joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 change anything. How? Add the following line to the XML installation file: script.php Now create a script.php file in the root folder of your component (ie. same as the XML installation file) Add the install script instructions: // No direct access to...

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

Export Joomla Users scripthttps://joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 get the same result, but this script was more fun. Simply create a text file with the following code and upload it to the root of your Joomla website. Access the page from a browser and you should get all your users listed... For security reasons,...

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

301 Redirect using htaccess filehttps://joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 I raised the alarm but hey-ho. How? I'm going to show you how to do this with a .htaccess file: Upload a text file to the root folder of the old domain's website Rename it as ".htaccess" (or modify the existing one) Add the code as per below. Save the...

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

XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 an external schema restriction Defines restrictions on a simpleType, simpleContent, or a complexContent schema Defines the root element of a schema selector Specifies an XPath expression that selects a set of elements for an identity constraint sequence...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• 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 here we are using SRS as the dictionary and CAP as the entity. (If your change spans different entities, just use the parent/root entity, usually STU) XML is case sensitive so bear this in mind, tick the "Valid for Export" and decide whether blanks are...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 the key should not be stored in a public folder that is accessible via the web but at least stored (eg. outside your web root) where this script can access it. The same goes for the access token, store it off the web but where this script can access it...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 here. One to create a .sql file of the backup but another to copy the contents to a copy of the database accessible only by root and and this database "backuper" user. For both methods, I grant the following to the user doing the backup on the database...

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

Zoho Creator / eBay: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

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

Zoho Creator: eBay: Get Item Transactionhttps://joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 //m_ActiveList.put("Sort","ItemID"); m_Params.put("ItemID",p_ItemID); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 m_Params.put("PictureName","OhBeautifulMe"); m_Params.put("PictureSet","Supersize"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

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

ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 must be a zip of the folder "Attachments" (with capitalized "A") and have no subfolders with all files in the root. File not found. Please check the attachment ID.: The Attachment ID column must contain the unique field names. File name column can...

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

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 m_Params.put("CreateTimeTo",v_timeTill); m_Params.put("OrderRole","Seller"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("","");...

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

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

01 March 2023 m_ActiveList.put("Pagination",m_Pagination); // m_Params.put("ActiveList",m_ActiveList); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

• 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 m_Pagination.put("EntriesPerPage",v_PerPage); m_Params.put("Pagination",m_Pagination); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 l_OrderIDs.add(m_OrderID); m_Params.put("OrderIDArray",l_OrderIDs); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //...

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

How to make your Joomla site use SEO friendly urlshttps://joellipman.com/articles/cms/joomla/how-to-make-your-joomla-site-use-seo-friendly-urls.html

02 April 2010 configuration tab to YES. Note: you need the permissions to rename the file ("htaccess.txt" to ".htaccess" in your website root folder). You'll need ftp access or a file manager with all your website files in). Do not continue if you ONLY have control...

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