Search - Joel Lipman .Com

21. Regular Expression Basic Usage Examples: / Web-Development /; ... sequence in your regular expression. The element you specify must be a defined collating sequence in the current locale. This operator lets you use a multicharacter collating sequence in your regular ...; Created on 28 October 2013
22. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... Microsoft.SqlServer.Dts.Pipeline.Localization; using Microsoft.SqlServer.Dts.Runtime.Wrapper; using System.Globalization; // for cultureinfo and textinfo using System.Reflection; // for looping ...; Created on 04 October 2013
23. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; ... contains H,R,S ; continue This works fine at home on your local host on a local drive. Try using this over a networked drive and more time will be spent counting the files then the actual processing ...; Created on 04 June 2013
24. Country Lookup by IP address CSV: / MySQL /; ... credentials, $db_host = "localhost"; // Database host name $db_user = "my_database_user"; // User for database authentication $db_pass = "my_database_password"; ...; Created on 17 March 2013
25. Administrator Program Shortcut without Prompt: / Windows OS /; Applies to: - Microsoft Windows 7 Enterprise - User with Local Administrator Privileges (required for setup) Why? Our work has group policies and two of our programs, Visual Studio 2010 ...; Created on 25 February 2013
26. Set up Desktop SlideShow in Windows 7: / Windows OS /; ... be a breeze, but that's because I don't implement group policies at home. Why? We get problems with this because none of our staff are full administrators of their local workstation. As IT staff ...; Created on 22 January 2013
27. List last modified files using FTP Command-line: / File Transfer Protocol /; ... to the root folder containing your website. Type pwd to confirm the remote working directory is the current directory. Type lcd to confirm what the local working directory is (when you download or print ...; Created on 20 November 2012
28. 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
29. SSRS AlphaNumeric Parameter Validation: / SQL Server Reporting Services /; ... ' ' ) ) )) AS NotAlphaNumeric FROM YourDataSetTable WHERE ThisRecord = :UserSpecifiedID -- where :UserSpecifiedID is one of the report parameters (Oracle local variable) -- ...; Created on 07 November 2011
30. Migrate Joomla Users to WordPress: / Wordpress /; This is for Joomla 1.5.x sites! Note that this article is for Joomla 1.5.x sites to be converted to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot ...; Created on 03 October 2011
31. List MediaWiki Articles: / MediaWiki /; ... associated with local wiki groups (required to view the category): Page ID, Title, Content, Category, Groups SELECT p.page_id AS PageID, CONVERT(p.page_title USING latin1) AS PageTitle, CONVERT(t.old_text ...; Created on 22 September 2011
32. SSRS External Images don't displa: / SQL Server Reporting Services /; The Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet ...; Created on 19 September 2011
33. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... in the order that they are accepted by your stored procedure (eg. MyStoredProcedure(param1,param2,param3) -> param1=@param1, param2=@param2, param3=@param3): Local Variables Note that we were ...; Created on 02 September 2011
34. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... either. I'm using an Oracle/PLSQL database for this so whether you're using T-SQL or MySQL you'll need to use the appropriate variable references (eg. T-SQL is @localvariable, Oracle is :localvariable). ...; Created on 19 July 2011
35. Unix Date Format Specifiers: / Linux /; ... Month %m mm month 07 %h Mon Jul %b Mon, locale's abbreviated Jul %B locale's full month, variable length July Year %y ...; Created on 05 July 2011
36. Win32 Constants: / AutoHotkey /; ... = 15 Const CF_LOCALE = 16 Const CF_MAX = 17 Const CF_OWNERDISPLAY = $0080 Const CF_DSPTEXT = $0081 Const CF_DSPBITMAP = $0082 Const CF_DSPMETAFILEPICT ...; Created on 05 July 2011
37. Run commands for Windows: / Windows OS /; ... Configuration (Modifies DHCP Class ID) ipconfig /setclassid Java Control Panel (if installed) jpicpl32.cpl Java Control Panel (if installed) javaws Keyboard Properties control keyboard Local Security ...; Created on 05 July 2011
38. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... about 10 mp3 songs or 5000 pictures) Checks your computer can connect to the Internet (accesses http://news.google.com/) Checks you are a local administrator on your computer (should just need normal user ...; Created on 28 June 2011
39. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... returned, it is reading only and not making any -- changes. It will show you what data the query is planning to migrate. -- EXAMPLE: -- SET @exampleLocalVariable=1; ...; Created on 30 January 2011
40. Parameters not being used in report processing: / SQL Server Reporting Services /; ... was reverting to US format as opposed to European Given a Campus as a text value, the SQL query was ignoring this completely Hardcoding the scalar local variables worked I have two parameters ...; Created on 07 January 2011