Search - Joel Lipman .Com

21. Convert to Proper Case in T-SQL: / Transact-SQL /; ... -- get the delimited word SET @CaseLen = CHARINDEX(',', @CaseExceptions, @i+1) - @i SET @CaseValue = SUBSTRING(@CaseExceptions, ...; Created on 04 June 2014
22. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... close without warnings or notifications. We found that if the query only returned 1000 rows, it completed and displayed in just under 1 minute. If limited to 500 rows, it would complete in just under ...; Created on 07 March 2014
23. Creating a custom form field type for Joomla XML fieldset: / Joomla /; ... Joomla component and needs some SQL dependent on some dynamic variables. Why? In Joomla, the XML type of "sql" is extremely limited. The component I'm making has to ensure user's can only see their ...; Created on 25 October 2013
24. Improve Default Joomla Search: / Joomla /; ... and its database. Or, if space is limited, you can backup the files I have listed here (the ones we will be modifying): \plugins\search\content\content.php \components\com_search\views\search\tmpl\default.xml ...; Created on 07 May 2013
25. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... DECLARE @ColToProcess varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT ...; Created on 26 October 2012
26. Search a database with SOUNDEX: / Databases /; ... containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by 4000 characters in a variable (so I couldn't store it in a local variable). So the idea here is to run the below ...; Created on 11 October 2012
27. Basic Webpage Controls with JavaScript / COM: / AutoHotkey /; ... on limited criteria, you can use the following 3 methods:getElementById(id) - returns a reference to the first object with the specified ID getElementsByName(name) - Returns a collection of objects ...; Created on 05 July 2011
28. Joes Quicklist Weblinks (JQW): / Product Documentation /; ... which only the authorized "service group" has access to (Special?). Free Website Thumbnail Services Thumbnail Services will give you a limited number of free thumbnail generations. About 100,000 ...; Created on 03 July 2011
29. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... morning, in the afternoon, once, twice, however and whenever YOU want. Unlimited: You are only limited by the resources of your environment setup, in terms of processing and disk space. The program ...; Created on 28 June 2011
30. Passwords: Did-you-know: / IT Support /; ... we use today are free to download and use. This includes but is not limited to: recovering all passwords stored in Internet Explorer or Firefox; most Messenging programs with auto-login features; account ...; Created on 15 November 2010
31. Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparison: / Joomla /; ... 1 license Unlimited YOOtools 39 € ($53) 12 months 3 licenses Unlimited YOOtools 79 €* ($106) ...; Created on 08 April 2010
32. Project Plan for Freelance Website: / Web-Development /; ... these be primarily used for (restricted on space allocation - usually ~100Mb)? List all email addresses please (limited as these include reply-from - eg. This email address is being protected from spambots. You need JavaScript enabled to view it.) Webmail or do you ...; Created on 25 February 2010
33. Uninstalling AEC Central and installing Community Builder: / Joomla /; The reason I did this is because AEC is now a commercial package and it is somewhat limited in terms of good customer service. It only really manages the payment side and the complicated tasks of invoicing, ...; Created on 20 January 2010
34. Forum Rules: / Static Items /; ... so long as you do not flame anyone. If this thread gets out of hand, it will be closed, and you may not complain elsewhere on the board, or by other means including, but not limited to: private messages, ...; Created on 31 May 2009
35. Terms & Conditions: / Static Items /; ... available through this website meet your specific requirements. This website contains material which is owned by or licensed to us. This material includes, but is not limited to, the design, layout, ...; Created on 30 May 2009
36. Licence GNU/GPL: / Static Items /; ... and are irrevocable provided the stated conditions are met. This License explicitly affirms your unlimited permission to run the unmodified Program. The output from running a covered work is covered by ...; Created on 03 April 2009
37. Feature Box: Created on 08 October 2015
38. Button Group: Created on 08 October 2015
39. Pricing Table: Created on 17 April 2015
40. Slideshow Addon: Created on 30 November -0001