Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a date, the date format was reverting to US format as opposed to European Given a Campus as a text value, the SQL query was ignoring...

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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 from source after copying). /MOVE :: MOVE files AND dirs (delete from source after copying). /A+:[RASHCNET] :: add the given Attributes to copied files. /A-:[RASHCNET] :: remove the given Attributes from copied files. /CREATE :: CREATE directory tree...

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

Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

18 August 2022 alert user if no email was specified) v_OutputMessage = ""; v_TemplateID = "123456789012345678"; // // get the quote details given a record ID r_QuoteDetails = zoho.crm.getRecordById("Quotes",p_QuoteID); // // check target email is not null/blank...

• 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 to eBay Listings. Getting the Orders in XML format: /* Function: fn_eBay_GetOrders() Purpose: Queries eBay for all orders given a from and till date Date Created: 2023-02-28 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API...

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

DataJumble - Shuffling characters in a data valuehttps://joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 date; DECLARE @TimeVal time; DECLARE @DateMatch int; DECLARE @TimeMatch int; DECLARE @ColumnTypeIsDate int; -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET...

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

DataScramble - Randomizing data rowshttps://joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 DECLARE @TimeMatch int; DECLARE @ColumnTypeIsDate int; DECLARE @IntOptions int; DECLARE @CharOptions varchar(max); -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal =...

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

Joomla - How to preview module positions in a given templatehttps://joellipman.com/articles/cms/joomla/joomla-how-to-preview-module-positions-in-a-given-template.html

02 April 2010 I was asked "... how do you find out where the positions are, like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after your website URL:...

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

Oracle SQL - Convert given list (CSV) into Rowshttps://joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 Just a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows...

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

Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy...

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

Zoho Deluge: Convert Hex to RGBhttps://joellipman.com/articles/crm/zoho/zoho-deluge-convert-hex-to-rgb.html

11 October 2024 a 3 or 6 character hexadecimal color and returns the RGB values for you. How? Very quickly, we take each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to...

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

Calculating Percentagehttps://joellipman.com/articles/ecommerce/calculating-percentage.html

20 May 2010 12 steps of 30 is 40% progress eg. ($8 / $10) * 100 = 80% ie. $8 of $10 is 80% To determine the percent (adjustment level) given the RRP and the price you're selling at: ((Agreed Price - Usual Price) * 100) / Usual Price = % eg. ($10 - $8) * 100 / $8 =...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 to run the unmodified Program. The output from running a covered work is covered by this License only if the output, given its content, constitutes a covered work. This License acknowledges your rights of fair use or other equivalent, as provided by...

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

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

14 May 2024 workflow that runs exactly 4 days after the lead creation time and assigns it to the specified user (full name of user was given in the brief but removed here for privacy). Finally, we delete any of these tasks when they get transferred to the contact...

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

Setting up your store to use SSLhttps://joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 errors please contact your hosting company to resolve the issue. If you have shared SSL your hosting company should have given you your secure URL which in most cases will be a domain with folder allocated to you. e.g....

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Add Image Mouseover effect in AutoHotkey GUIhttps://joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 = Cursor ) { CursorHandle := DllCall( "LoadCursor", Uint,0, Int,CursorID ) Break } } If CursorHandle = ; invalid cursor name given { Msgbox,, SetCursor, Error: Invalid cursor name CursorHandle = Error } } Else If FileExist( Cursor ) { SplitPath,...

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

List all cron jobs for all usershttps://joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 system. CRONTAB='/etc/crontab' CRONDIR='/etc/cron.d' # Single tab character. Annoyingly necessary. tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any...

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

Delete related records from multiple tableshttps://joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational Database Management System (RDBMS) where deleting some erroneous rows in one table will cause errors...

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

Parse a HTML Table into a ListViewhttps://joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 A quick article on if you were given a webpage coded in HTML, what methods in AutoHotkey could you use to separate out the HTML Tables into a ListView. Why? I want a snippet of code that replicates any HTML table. How? I've been trying various ways so...

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

CSS Add Text to Breadcrumb Link with a Transitionhttps://joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 This is an article I hope to refine one day where given a set of breadcrumb hyperlinks, when I hover the mouse over the links, the text changes and the transition between the two is controlled smoothly. Why? At time of print, I couldn't find any clear...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 "eTag_Title", check if the new MD5 is different, if it is then I proceed with the automations otherwise I stop it. // get given eTag v_eTag = zoho.encryption.md5(input.Title.trim()); // // now compare to stored eTag if(v_eTag != input.eTag_Title) {...

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