Search - Joel Lipman .Com

21. SSRS Display question mark when date is blank: / SQL Server Reporting Services /; ... "dd/MM/yyyy HH:mm:ss") -- yields 11/02/2014 11:21:32 Sounds good, where's the problem? The problem Putting the date in an IIF (if-then-else) statement displays "#Error". You should get errors ...; Created on 15 April 2014
22. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... in 0.4 seconds. So where's the problem? How? Left to its own devices, a search for "SMITH" as a surname would make the report spin for about 10 minutes without the possibility to cancel (link not ...; Created on 07 March 2014
23. Registered Users Cannot Login - Super Users Can: / Joomla /; ... account, none of the Joomla groups, not even "Administrators" could login. However set the same test account to a "Super User" and they would be able to login. Was the problem authentication? Restricted ...; Created on 26 February 2014
24. ReCaptcha disappears from Joomla 2.5 Registration: / Joomla /; What? This is an extract from a forum which solved our problem for why the ReCaptcha part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin ...; Created on 24 November 2013
25. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; ... it isn't. This is one of those rare situations when the Microsoft error is describing the exact problem. If you include linked images in the report (as in images not in the report itself but referring ...; Created on 22 November 2013
26. Call to a member function mark() on a non-object in Joomla CMS: / Joomla /; ... suspected that part of an auto-update process had corrupted all the files. In our case, the problem was that the system tried to update Akeeba (a 3rd party component to do backups) simultaneously or prior ...; Created on 17 November 2013
27. MS Excel: Convert a text to a number: / Excel /; ... to British pounds (sterling). When I multiply the Philippine peso by the conversion rate, it returns #VALUE! How? The problem is that I have a column which includes the currency symbol as per the ...; Created on 15 November 2013
28. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... DMExtractEmployeeTable e2 LEFT JOIN DMExtractReferenceTable r2 ON e2.CodeType=r2.MapIn -- THIS IS THE LINE CAUSING THE PROBLEM!!! ...; Created on 14 May 2013
29. Things to Check if Joomla Password Reminder email not being sent: / Joomla /; ... web-based, then ensure you are using a separate instance of the browser to your Joomla one. Check that your template isn’t the problem: If you have a test site that has the same error, change ...; Created on 09 May 2013
30. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... problem also happens when you have a Data File of varying column numbers. My solution below will also fix this. How? My data file had some empty rows amongst the data. The easy fix is by dealing ...; Created on 23 April 2013
31. Joes Syntax Styler (JSS): / Product Documentation /; Before you ask, I tried Google Prettify and Alex Gorbatchev's Syntax Highlighter but both were causing problems for the sites I wanted to use it on. Mainly because of JavaScript frameworks (like jQuery ...; Created on 06 April 2013
32. SSIS Convert a string into a date: / SQL Server Integration Services /; ... problems here relate to when our datasource was a flat file connection. We had to change the Format under General to Ragged Right (I had been setting it to "fixed width" but then got problems with it not ...; Created on 14 March 2013
33. Administrator Program Shortcut without Prompt: / Windows OS /; ... double-click and it will run the above programs in administrator mode without confirmation by the Windows operating system. At home this may not be a problem but this is intended for those in an office ...; Created on 25 February 2013
34. Set up Desktop SlideShow in Windows 7: / Windows OS /; ... "clicking on Desktop Background", "browsing to the Picture Location". The problem happens when browsing to the picture location and it doesn't seem to remember which folder you selected. At home, this would ...; Created on 22 January 2013
35. Three boxes, two roll over, one falls out: / Cascading Stylesheets /; ... was simply calculating with 33% as the third of the page width. Changing this to 990 pixels in width fixed the problem. I'm guessing this was because 990 divided by 33 leaves a remainder of zero but ...; Created on 21 January 2013
36. Battery Constantly Drained on iPhone: / Apple /; ... app until red minus buttons appear, tap red button)... I wouldn't usually take notice but I think this is a brilliant example where trying to fix the problem is the very cause of the problem in the ...; Created on 27 November 2012
37. Background Gradient Disappears on Long Pages: / Cascading Stylesheets /; ... Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but when visiting a long page, it would initially display properly but then the white background would disappear ...; Created on 20 November 2012
38. Vertically align an asterisk on a line: / Cascading Stylesheets /; ... size of the asterisk, this often increases the line-height and causes the overall line height to change for other objects in the same row. The problem afterwards was that the asterisk character would ...; Created on 02 September 2012
39. MySQL day of week ending on Friday: / MySQL /; ... Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following Sunday. The solution below is for the ...; Created on 26 April 2012
40. How to change local folder for TFS: / Team Foundation Server /; ... Foundation Server (for me this was already done) Go to File > Source Control > Workspaces Edit... the workspace which is causing the problem Change the local folder All the files on TFS ...; Created on 08 March 2012