Search - Joel Lipman .Com

21. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... the failure. Why? So the solution must be obvious to you by now. At least that's what Microsoft people think to themselves every time they see the error they programmed in. Apparently this ...; Created on 23 April 2013
22. List last modified files using FTP Command-line: / File Transfer Protocol /; ... will output all files including subdirectories to temp.txt in your local working folder. Additional Notes the switch "-S" does not work on certain systems (at least not accompanied with the ...; Created on 20 November 2012
23. The greatest invention in IT: / IT Support /; ... Miller and John C. Thomas of IBM, noted that "It would be quite useful to permit users to 'take back' at least the immediately preceding command (by issuing some special 'undo' command)." Source: Behavioral ...; Created on 13 September 2012
24. Slideshow div layer through a window: / MooTools Framework /; ... (that's the aim at least). Other objects (mostly text over image) will need to be free flowing and slide in emulating a dynamic showcase slideshow. Using MooTools it's also proven to be responsive and ...; Created on 11 September 2012
25. Basic Joomla 2.5 Mootools Form: / Joomla /; ... stability, you will want this to use an XML file depending on the level of detail you want back. The biggy The following code is basically the least amount of code (or near enough) you will need ...; Created on 20 August 2012
26. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... suggests the following (or at least the idea of): SELECT * INTO #MyTempTable FROM @GivenTable If @GivenTable is a parameter then the above will simply return an error. Also, if it was this easy, ...; Created on 03 August 2012
27. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... "open cursor for") didn't match my SSRS report field name mapping. Done! Well almost as you still need to design your report. At least this article should have got you to the part where you're simply ...; Created on 19 January 2012
28. Migrate Joomla Users to WordPress: / Wordpress /; ... their passwords but that is what the commercial applications are doing. The script to transfer users This is a free solution to at least get your user accounts all migrated. How you deal with the ...; Created on 03 October 2011
29. The ReportServer Database: / Databases /; ... "$#,##0;($#,##0)" Show me the Name! A quick query to show the execution log with at least the report name for us human users: SELECT a.[InstanceName] ,b.[Name] ,a.[UserName] ...; Created on 08 August 2011
30. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... the second solution will mean each dataset must at least join both tables that you are using the OR clause against. There must be a solution that executes a query at report execution time and populates/assigns ...; Created on 19 July 2011
31. Joes Bug Tracker (JBT): / Product Documentation /; ... most viewed --- Report on most downloaded --- Report on most user downloaded --- Report on highest download rates --- Report on least viewed --- Report on lowest rated --- Report on highest rated --- ...; Created on 07 July 2011
32. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... Either use the website to contact me or email me at This email address is being protected from spambots. You need JavaScript enabled to view it.. I will do my best to get back to you as soon as I can so that we at least open a line of communication. If anyone has any ...; Created on 28 June 2011
33. 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
34. F_ck You. Pay Me.: / Web-Development /; To be honest I saw this on some Joomlaworks Blog who appropriately title it "A must see for professional webdesigners". If you're a developer relying on clients for your income, then at least watch some ...; Created on 14 April 2011
35. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... of useless info, at least I'm not just copying and pasting from other sites to add content to my own. And I'm not just adding content, the way I'm doing the below is nothing similar to what I googled (probably ...; Created on 29 March 2011
36. Developer's Checklist: Taking over a projec: / Web-Development /; ... rewritten? eg. clear-text passwords) Level of Security Testing (XSS and SQL-Injection at least?) Referenced common files / global assets (especially those used in every page) Expert/Testing/Resistant ...; Created on 01 March 2011
37. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... script full privileges or at least the same as needed to install Joomla CMS. Cross your fingers and use your DB management tool to run the SQL file (or copy the contents of the SQL file into the input ...; Created on 30 January 2011
38. Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparison: / Joomla /; So this is a comparison chart (at least in my opinion) of 3 major joomla template/extension providers. When I'm less caught up in work I'll try adding to this article. But here's some lazy stats: ...; Created on 08 April 2010
39. Installing phpBB3 for Joomla with a RocketTheme template: / Joomla /; ... Select the "Styles" tab. You should see a row with "Affinity" at the bottom. Click on "Install", set as default and that's it.... Well at least if everything ...; Created on 28 September 2009
40. Licence GNU/GPL: / Static Items /; ... software interchange. b) Convey the object code in, or embodied in, a physical product (including a physical distribution medium), accompanied by a written offer, valid for at least three years and valid ...; Created on 03 April 2009