Search - Joel Lipman .Com

21. 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
22. Administrator Program Shortcut without Prompt: / Windows OS /; ... Create Task... Under the General tab, for "Name" give it a general name with no symbols/special characters and preferably no spaces (I tend to give it an all lowercase name with no spaces). tick the ...; Created on 25 February 2013
23. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... @p_SearchTable VARCHAR(max), @p_SearchColumns VARCHAR(max), @p_UseCollation VARCHAR(max) = 'Latin1_General_CS_AS' ) AS /***************************************************************************************************************** ** ...; Created on 26 October 2012
24. Search a database with SOUNDEX: / Databases /; ... Cursor1 CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column_value, ''' + TABLE_SCHEMA + '.' ...; Created on 11 October 2012
25. T-SQL example of Case-Sensitive Soundex: / Transact-SQL /; ... DISTINCT StudentDetail COLLATE Latin1_General_CS_AS FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not Yet Available') -- yields StudentDetail ----------------- Data ...; Created on 10 October 2012
26. Search a database for a string (MySQL, T-SQL): / Databases /; ... @mySearchString varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column1 FROM ' + (TABLE_SCHEMA + '.' + TABLE_NAME) ...; Created on 08 October 2012
27. Joomla article modal with clear button: / Joomla /; Applies to Joomla 1.6+ What? This is an article to describe how to add an article modal button in the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important ...; Created on 27 August 2012
28. How to change local folder for TFS: / Team Foundation Server /; ... would continuously check-out files and store these in the home directory. I tried the general settings (Tools > Options) but to no avail. How? The way to change this was: Connect to your Team ...; Created on 08 March 2012
29. SSRS Dropdown parameter cannot be blank!: / SQL Server Reporting Services /; ... all Parameters: » General - Untick "allow blank value" and "allow null value" (so these checkboxes are empty). » Available Values - "Get values from a query" = Select the dataset of the dropdown options. ...; Created on 14 December 2011
30. Joes DNS Correction (JDC): / Product Documentation /; ... red if failed. License Details: This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software ...; Created on 25 November 2011
31. Joes Bug Tracker (JBT): / Product Documentation /; ... versions per entry) --- Project Name --- Category Name (dropdown of categories) --- License (textarea / option require or not) --- Specify Joomla! Article (for General Description) --- Specify Joomla! ...; Created on 07 July 2011
32. Basic Webpage Controls with JavaScript / COM: / AutoHotkey /; ... WebPage Contents - HTML DOM To understand how to use Javascript to control a webpage, you need a general understanding of the HTML DOM. It is similar to a "map" or "heirarchy" ...; Created on 05 July 2011
33. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... and the sites I link to don't generally change their website design everyday... It's 100% FREE Open Source, (well as long as you have your own internet connection) mainly because it's not just my code. ...; Created on 28 June 2011
34. Code Troubleshooting Checklist: / Web-Development /; So I've started this list to make sure I don't spend so long anymore on debugging code. The aim of this article is to quickly suggest ways of pinpointing the source of the problem: In a database/web ...; Created on 03 June 2011
35. Creating a Profile Plugin for Joomla 1.6: / Joomla /; ... - Profile - JoelLipman.Com Joel Lipman April 2011 (C) 2011 JoelLipman.Com. All rights reserved. GNU General Public License version 2 or later; see LICENSE.txt ...; Created on 27 April 2011
36. Formatting a date in an MDX query: / Transact-SQL /; ... other formats are: =FormatDateTime(Fields!BirthDate.Value, DateFormat.GeneralDate) =FormatDateTime(Fields!BirthDate.Value, DateFormat.LongDate) =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) =FormatDateTime(Fields!BirthDate.Value, ...; Created on 11 January 2011
37. Returned a data type that is not valid: / Transact-SQL /; Thought I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during ...; Created on 06 January 2011
38. Is it a scam? Gumtree.com's warning sign: / IT Support /; What? This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work. Requests to use money transfer services like Western ...; Created on 12 October 2010
39. Language Codes: / Joomla /; Having started developing multi-language components, it was important that I get a general idea as to what languages are abbreviated to. Usually I only write english files (en-GB) but it's not very international ...; Created on 13 September 2010
40. Changing the yourdomain.com for phpBB3: / Joomla /; This is related to the issue of renaming yourdomain.com as your title page in phpBB3. You need to login to the phpBB admin control panel (ACP). On the General tab, look under Board Configuration ...; Created on 01 October 2009