Formatting a date in an MDX queryhttps://www.joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 Noticed this when setting date as the parameter and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with "=Today()" [yields:...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 AND ref.[RefSheet] = 'myPayrollCategory' AND ref.[RefSystem] = 'myPayrollSystem' Yes well obvious to some but then you google the above and you get half a million results. That's a lot of reading so here's the simple fix for my issue: Returning an...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 Do not use MySQL WorkBench!!! Seriously, your pride will slow you down or get you sacked! Instructions: Go to Google Search Search for "Free MySQL database manager" (preferably add the keyword "portable") Avoid links to MySQL Workbench and download an...

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

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

20 November 2012 #f7f7f7; background-clip: padding-box; border-radius: 0 0 5px 5px; Example Additional The above issue happened when using Google Chrome v23 or MS Internet Explorer v8 (so Webkit and MSIE appear to be affected). If your website consists of small pages...

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

Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/cms/website-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 viewed normally on a 15" Laptop, all was good using Chrome and tolerable using MS Internet Explorer. If we maximized the Google Chrome browser, the row would split and there would be 2 boxes on the top row and the third would pop under these. As for...

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

Joes Revolver Map (JRM) Downloadshttps://www.joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=105&Itemid=165

07 September 2015 Joomla 2.5.x - Date Uploaded: Thu, 27th Dec 2012 1.2 - Checked compatibility: Internet Explorer v6+, Mozilla Firefox v3.5+, Google Chrome v5+ - Added alignment parameter ("float") relative to its container. - Added div and parameter "module class" so...

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

TravelPort Universal API - Ping Request with PHP-cURLhttps://www.joellipman.com/component/content/article/travelport-universal-api-ping-request-with-php-curl.html?catid=109&Itemid=165

27 April 2015 didn't help. The error I'm going to address has to do with getting the latest schemas but as I couldn't find anything using Google regarding these errors or how to set up a basic ping request, I thought I'd write this article. How? Using PHP and cURL,...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho Deluge - MD5 functionhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-md5-function.html

19 November 2018 create a MD5 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention of using MD5 in an encryption task. Why? I'm trying to create an ETag for a synchronization...

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

Zoho Deluge - Pad with leading Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-pad-with-leading-zeros.html

07 February 2020 There may be other articles out there documenting this but I can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though writing...

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

Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

11 April 2020 built-in search engine to also ignore permissions so that the article can still be indexed in global search engines such as Google. How? It's been difficult to search for the right words but heres the method to restrict the introtext to the public and...

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

If Then Else in Report Builder 2.0 Expressionshttps://www.joellipman.com/component/content/article/if-then-else-in-report-builder-20-expressions.html?catid=75&Itemid=165

06 May 2010 Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0)...

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