Search - Joel Lipman .Com

41. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... data using the student ID number found in the first query. The stored procedure compiles successfully and without any warnings. So What? The problem is that if the student does not have a username ...; Created on 24 January 2012
42. Getting the mysql where in delimited string to work: / MySQL /; What? 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)", ...; Created on 02 January 2012
43. Strip HTML in MySQL: / MySQL /; Just putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? ...; Created on 06 December 2011
44. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... this is not the solution to our problem. This is the solution that I initially used but my end-users were asking why is it always 0 seconds. This was because we were using the following MDX statement ...; Created on 17 November 2011
45. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; ... is the student to update. The confirm button links to a 3rd report which will actually execute the stored procedure which updates the student record as well as an audit table. The Problem The last ...; Created on 04 November 2011
46. SSRS Repeat Headers in PDF Report: / SQL Server Reporting Services /; The Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header ...; Created on 26 October 2011
47. Migrate Joomla Users to WordPress: / Wordpress /; ... easier since it uses nested categories like Wordpress. There are lots of commercial migrators out there and they all seem to have this problem. I'm really keen not to ask all my users to have to change ...; Created on 03 October 2011
48. Stop Excel Row Height Self-Adjust on Refresh: / Excel /; ... Problem We can select all cells and set row height to be 30 for example, but everytime we refresh the data in the Excel spreadsheet, all the rows get re-adjusted to fit the data and lose that consistency. ...; Created on 30 September 2011
49. SSRS External Images don't displa: / SQL Server Reporting Services /; ... Development Studio 2008 (BIDS) SQL Server 2008 R2 Reporting Server (SSRS) running on Windows Server 2003 Team Foundation Server 2010 (TFS) Problem #1: Image does not appear within SSRS When ...; Created on 19 September 2011
50. Excel PivotTable Filter List Ordering: / Excel /; ... dropdown appears with all available values listed. The Problem The values are listed in alphabetical order at first. If any new values come along then they get added to the bottom of the list... ...; Created on 05 September 2011