MySQL parameters in Excel 2007 PivotTableshttp://mail.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 The last date of this week was: =DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-WEEKDAY(TODAY())+2)+7-1 Note how I'm simply adding 7 to the start of the week date (subtract 1 so this is not inclusive). Crude solution but it works in Excel 2007 Now we...

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

How to Display Report Execution Time in SSRS (milliseconds)http://mail.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 "Dataset2")) - CDate(First(Fields!REPORTSTARTTIME.Value, "Dataset1")) ) // yields // 00:00:02.1543570 -- problems with adding a string to it? CStr will not work, use .ToString ="Time Taken: " & ( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2")) -...

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

Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 correct (or which applies to your report) 4a. Add a dataset: query type "Stored Procedure" Click on the radio button when adding your dataset and then select the stored procedure from the dropdown list. 4b. Add a dataset: the "Refresh fields..." button...

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

Prefix Line Numbers in a Text Filehttp://mail.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 working directory. Above and Beyond: Add to your Context Menu My absolute laziness drives me to write the instructions on adding this to the context menu (right-click menu) when you right-click on a text file: Open the system registry (Start > Run... >...

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

T-SQL example of Case-Sensitive Soundexhttp://mail.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 isn't at all what we set out to achieve other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results: SELECT DISTINCT...

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

Search a database for a value and count matching rowshttp://mail.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 DEALLOCATE Cursor1; -- Generate final query and execute it SELECT * FROM #CountRecordsPerTablePerCol; END Issues Consider adding a drop of the temporary table to the start of this script if you plan on running this successively against several...

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

Improve Default Joomla Search http://mail.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 So I could stop here as Stage 1 substantially improves your Joomla search, but the above files are enough to start adding your own code to make the "relevance" ordering more relevant.... ok still to come as I'm really happy with what the above already...

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

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

04 October 2013 where this BAT is held. CD "C:\Temp" ECHO Done. Deployment Method #?: As a setup.exe Package the visual studio project by adding a "setup wizard" project. This results in a setup.exe and msi file which can be installed on Windows Servers run by accounts...

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

Hide a Drive per User in Windows 7http://mail.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 hex or decimal number from the list below you want to set as restricted, and click on OK. -- Restrict multiple drives by adding the values together -- For Example: To Restrict B & C, enter 6 decimal -- " " E & G, enter 80 decimal or 50 hexadecimal Drive...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Android: Keytool and Google Maps displaying greyhttp://mail.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 This took me a while to figure out so hopefully this will help others. How? The gist is that I was using the Test SHA1 when adding allowed Android Keys to the Google APIs console (there's so many) when I should be using the App SHA1 (I have now added...

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

Android OS: Add GoogleMap as fragmenthttp://mail.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 Maps"); // Changing marker icon marker.icon(BitmapDescriptorFactory .defaultMarker(BitmapDescriptorFactory.HUE_ROSE)); // adding marker googleMap.addMarker(marker); CameraPosition cameraPosition = new CameraPosition.Builder() .target(new...

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

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

13 April 2015 appropriate Overrides to "Yes" Leave blank what you don't want to change. Style away! More Information Google Developers: Adding a Google Map

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

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

12 September 2015 -- METHOD #1 - Use the GUI to create your weblink categories: -- Adding the weblinks using the Joomla admin interface and then -- updating the database with the correct IDs is easier than the script. -- Use this if there aren't many to do. In this...

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

Foreign Characters create symbols in PHP and MySQLhttp://mail.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 shape instead of the foreign character. How does it happen? Have I tried the other solutions on the web? I have tried adding the following to my headers: This does nothing: // add these to the header: DOESNT WORK mb_internal_encoding('UTF-8');...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge - Update Creator from CRMhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 the target fields did not update. This was as a result after changing the owner of the Creator app to another person and adding our previous Super Admin account as a "Developer". How? I'm going to demo two methods here using the Setup the Connection...

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

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

20 March 2019 ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser'; Or via cPanel the following screenshot when adding a user to a database: Method #1: The following command on a cron job: // not recommended: /usr/bin/mysqldump -u dbusername...

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

Zoho Deluge - Get Refresh/Access Token API v2http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 with API v2 when I'm using PHP/cURL and not deluge to get a list of contact records. As I'm listing errors encountered, I'm adding it to this list. If submitting the headers as an array, note that it must NOT be an associative array: // this won't work...

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

Zoho Creator: Retrieve record with case-insensitive queryhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 I'm trying to insert a record for a new product if it doesn't exist in the table but if it does exist then to simply skip adding the product. v_Name = "Myproduct1"; // note the lowercase P l_ProductDetails = Product[Product_Name == v_Name]; b_Exists =...

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

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

15 May 2020 upload field value as attached file You might have tested using the trusty sendmail function and then got an error when adding the "attachments" parameter. As a reminder, content-type in the sendmail is not supported in Zoho Creator and nor is List when...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 form to Create New Client: Client Name: put something descriptive so it is easy to identify if the client has 3rd-parties adding clients. eg. "JoelLipman_BooksConnector". Homepage URL: put our corporate website URL, this is for developers who need to...

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