Search - Joel Lipman .Com

21. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; ... DATE_OF_BIRTH is blank or null yields // -- errors How? I could correct this using SSIS but with all the data in XML, we might as well stick with the technology and we're going to keep ...; Created on 18 August 2014
22. 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
23. Export Joomla Users script: / Joomla /; What? Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which ...; Created on 28 February 2014
24. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... copying even if errors occur. /I If destination does not exist and copying more than one file, assumes that destination must be a directory. /Q Does not display ...; Created on 23 February 2014
25. Call to a member function mark() on a non-object in Joomla CMS: / Joomla /; ... file. Comment that out and you will get errors regarding other elements of the CMS. This error could have been caused by many things but in the case of one of my clients, the error was due to an update ...; Created on 17 November 2013
26. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... return DTSValidationStatus.VS_ISVALID; } // This method repairs any errors identified during Design Time validation that caused the component to return VS_NEEDSNEWMETADATA ...; Created on 04 October 2013
27. htaccess Rewrites SEF URL and submits to PHP: / Personal Home Page /; ... for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example http://www.mysite.com/blog/videos/2010/january/21.html // ...; Created on 05 September 2013
28. Quickly update all content in mySQL database replacing a string: / MySQL /; ... = REPLACE(`fulltext`, @stringtoFind, @stringtoReplaceWith) WHERE `introtext` LIKE CONCAT('%',@stringtoFind,'%') OR `fulltext` LIKE CONCAT('%',@stringtoFind,'%') You might get some errors ...; Created on 03 February 2013
29. Delete related records from multiple tables: / MySQL /; ... to use the system you were given. Given a Relational Database Management System (RDBMS) where deleting some erroneous rows in one table will cause errors because the existence of those rows is stored in ...; Created on 11 January 2013
30. Connect to Joomla database in standalone script: / Joomla /; ... realpath(dirname(__FILE__).'/../..' )); // print this out or observe errors to see which directory you should be in (this is two subfolders in) define( 'DS', DIRECTORY_SEPARATOR ); require_once ...; Created on 17 August 2012
31. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... but has an ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty ...; Created on 24 January 2012
32. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... but not -- mentioned in the above OUT variables: DECLARE p_STUDENT_REF number(8); p_STUDENT_DETAILS varchar2(255); -- putting a begin within otherwise I get warning errors ...; Created on 19 January 2012
33. SSRS Zero Padding: / SQL Server Reporting Services /; ... have a database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment. My use for this was when displaying an audit log displaying the oracle errors. Oracle Errors An Oracle ...; Created on 10 November 2011
34. The ReportServer Database: / Databases /; ... 2=Cache, 3=Snapshot, 4=History) Status nvarchar(32) NOT NULL either rsSuccess or an error code; if multiple errors occur, only the first error is recorded ByteCount bigint NOT NULL Size of rendered ...; Created on 08 August 2011
35. Win32 Constants: / AutoHotkey /; ... TVE_EXPANDPARTIAL = $4000 Const TVE_COLLAPSERESET = $8000 ;#end region ;#region WinErrors Const NOERROR = $00000000 ;#end region ;#region TreeViewHitTest Const TVHT_NOWHERE ...; Created on 05 July 2011
36. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... Website Errors Be on the lookout of websites that generate popup script alerts (just switch these off in MS Internet Explorer - Internet Options - Advanced - Untick "display notification of each error") ...; Created on 28 June 2011
37. Checklist for the local computer repairs: / IT Support /; ... documents/programs to do this? Same errors on another computer? What are your workarounds? Protocol for Troubleshooting: Check system properties for RAM and CPU speeds Reduce visual effects ...; Created on 28 April 2011
38. Developer's Checklist: Taking over a projec: / Web-Development /; ... errors per use of a feature over 4 seconds. Do some developers never check the errors log? By the time, I started maintaining the project, a revamp had been agreed with another web team. This has ...; Created on 01 March 2011
39. Accessing a MySQL Database with Business Intelligence Development Studio: / MySQL /; ... the local server machine, or enable remote errors I fixed this by repeating stages 1 and 2 (above) on the Reporting Server. Ensure you name them the same thing as you did in the report. I am looking ...; Created on 05 January 2011
40. Running Internet Explorer 6, 7, 8 as standalones: / Windows OS /; ... IE7 Standalone (from http://ie7-standalone.en.softonic.com/) Your IE7 standalone will return a few errors but for basic browsing it will navigate to other pages and it will identify itself as IE7 ...; Created on 18 May 2010