Search - Joel Lipman .Com

1. MySQL Transactions in PHP: / MySQL /; Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account ...; Created on 14 December 2016
2. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... silly T-SQL concatenation which requires plus signs and thinks it's super clever when it tries to add a number and a string together; then remembers it's a Microsoft by-product and realises it can't. Solved ...; Created on 14 May 2013
3. Deserialization and cannot checkout files in TFS: / Team Foundation Server /; Why? So I get back from annual leave and I can't check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those ...; Created on 03 January 2013
4. Stop Excel Row Height Self-Adjust on Refresh: / Excel /; ... report after they've already gone through the hassle of clicking on the big fat refresh button... Keeping It Simple Silly. So the suggestion of selecting all cells and then right-clicking and selecting ...; Created on 30 September 2011
5. Excel PivotTable Filter List Ordering: / Excel /; ... summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a ...; Created on 05 September 2011
6. Inserting incremental weeks in MySQL: / MySQL /; Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different ...; Created on 15 April 2011
7. SSRS Use T-SQL Like with a Parameter: / SQL Server Reporting Services /; This must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date ...; Created on 04 April 2011
8. Border settings not saving in SSRS: / SQL Server Reporting Services /; This may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells ...; Created on 24 March 2011
9. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... 1.5), it's just the silly number of client websites I have to upgrade. This I find a lot simpler, my day job involves working with SQL so this script was rather basic and quick to write. You have ...; Created on 30 January 2011
10. Error during processing - Converting Date/Time: / Transact-SQL /; ... try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen in Report Builder 2.0 which I've stopped using as my day job wants ...; Created on 13 July 2010