Copy a Wordpress Site for Developmenthttps://joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 replace any other occurrences in the `wp_options` database table (note: include `wp_postmeta` and `wp_posts` if you want images and attachments) Done Sample Configuration PHP Note that the following are sample values and just for myself to quickly...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

04 October 2013 else throw new Exception(e.ToString()); } } } } Allowing me to simply tick columns to apply this to (note that some of the images have been censored due to this project containing sensitive data): Script Component Task: Select Type Script Component...

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

SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

13 June 2014 with an example. As my work was for a Personnel/HR project, and data confidentiality is somewhat important, some of the images will be censored or data changed in the example below. Add a variable (preferably to the scope of the package) called...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

19 January 2012 in my example as I didn't end up using them) 4. Add a dataset Follow these steps carefully. I've added some screenshot images to help and highlighted areas which you should ensure are correct (or which applies to your report) 4a. Add a dataset: query...

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

Windows Live Messenger: Error 80048820https://joellipman.com/component/content/article/windows-live-messenger-error-80048820.html?catid=80&Itemid=165

08 March 2010 error. Basically you start up windows live messenger and get the following error: {rokbox title=|Messenger Error 80048820|}/images/screenshots/windows_live_error_80048820.png{/rokbox} Basically you need to check that the time on your windows clock is...

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

Getting the mysql where in delimited string to workhttps://joellipman.com/articles/else/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to...

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

CSS keeping the footer at the bottomhttps://joellipman.com/articles/cms/website-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 0; width: 900px; margin: 0 auto; min-height: 500px; /* to stop footer coming up on empty pages */ background-image: url("../images/bg_contentbox.png"); /* semi transparent background */ } #footer { position: relative; bottom:0; margin:0; padding:0;...

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

Add default to a picture buttonhttps://joellipman.com/component/content/article/add-default-to-a-picture-button.html?catid=48&Itemid=165

10 November 2009 effects afterwards. Add the image for your GUI: Gui, Add, Picture, x600 y70 w90 h90 vSearchButton gSearch, %A_ScriptDir%\images\program\search_button.png Add the input field where you type the text: Gui, Add, Edit, x55 y95 r1 w550 vSearchTextInput,...

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

Advanced RokStories Stylinghttps://joellipman.com/articles/cms/joomla/advanced-rokstories-styling.html

01 July 2009 you see on this demo. The module adapts depending on your image size, so no need to manually create rounded corners on your images, RokStories will do the rest. The custom features are also available in the standalone version. Lorem ipsum dolor sit...

• Type: Article
• Author: Webmaster
• Category: Joomla
• Language: *

SSRS Change Background Color of Imagehttps://joellipman.com/component/content/article/ssrs-change-background-color-of-image.html?catid=75&Itemid=165

08 April 2014 Why? I want an image to display per row as a status marker for 3 different types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I want the first column to display an image based on the status result....

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

SharePoint 2007: Change profile picture with minimal permissionshttps://joellipman.com/component/content/article/sharepoint-2007-change-profile-picture-with-minimal-permissions.html?catid=77&Itemid=165

07 November 2013 change your profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given. Why? Because I can How? Setup an...

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

Strip HTML in MySQLhttps://joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html

06 December 2011 migrate old content to a new system. From a MediaWiki CMS to a SaaS called Service-Now. The previous interlinking between images could no longer be used. How? There were a few functions out there. One called "strip_tags" crashed in the running of the...

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