Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 Navicat or SQLYog), and still there at night editing each field so that it displays correctly... well that's usually me. Found it a bit boring but here's a short bit of code to speed it up which I now use: update table_name set...

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

Comparing two mediawiki siteshttps://www.joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

17 September 2010 have the same article content: Print Special:AllPages from both sites and do an eye-check (I basically highlighted articles found in one but not the other - we had over 2000 articles... I guess I'm a bit geekly like that) This doesn't show modified date...

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

The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 :c) This is "a day in the life of New York City". {module title="Youtube Embedded Video - Sandpit"} More Information can be found at http://aerofilm.blogspot.com/2010/02/sandpit-short-film-by-aero-director-sam.html Personally I can sit there watching it...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Border settings not saving in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 far because I'd even ask the border to be grey and save the project but when I come back to the setting, it's still black. I found that you have to select a color or expression first, then define which border (top, right, bottom, left) the settings...

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

SSRS - Lost window with datasetshttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-lost-window-with-datasets.html

25 March 2011 Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars before I found this. Open a Report solution (or have one open already?) The menu link is "report data" and it's right at the bottom of the...

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

SSRS No Delay for First Report of the Dayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 This article describes a solution our reporting server administrators found to cut the loading time of the first report of the day. Why? Take any SSRS report, if one of us was the first to run it on that day, it would take an additional 60 seconds to...

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

DJI Phantom FC40 - First Flighthttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-first-flight.html

28 August 2014 you see on YouTube: {youtube}xw7WKwbYCZI{/youtube} The YouTube channel or user channel (once I get it figured out) can be found at https://www.youtube.com/user/joeylipman

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

Two icons created on Androidhttps://www.joellipman.com/articles/google/androidos/two-icons-created-on-android.html

20 October 2014 installing an app and it creates two icons: Why? I don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. How? Basically don't have the following declared more than once in...

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

CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 column + Generate interactive flash charts The program was intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file.

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

VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example applicable to Windows 7 Professional. Why? With...

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

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

19 November 2018 multiline but this would defeat the objective of an Etag). How? Well I was going to document writing a Creator function but found a shortcut playing with the base64encode function: v_Etag = zoho.encryption.base64encode(v_Combined_Fields); // returns...

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

Zoho Deluge - Get User Timezone, Country and Locationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-user-timezone-country-and-location.html

03 June 2019 is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The quickest I found [limit 1000 per day | Incorrect Location]: v_Url = "http://api.db-ip.com/v2/free/"+ zoho.ipaddress; v_Response = getUrl(...

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