Search - Joel Lipman .Com

21. Copy a Wordpress Site for Development: / Wordpress /; ... Delete any files in DEV except for "wp-config.php" Copy all files except for "wp-config.php" from LIVE to DEV Copy the salt and secret keys from LIVE\wp-config.php to DEV\wp-config.php Backup the ...; Created on 08 March 2015
22. Android OS: Add GoogleMap as fragment: / AndroidOS /; ... mMapView.onResume();// needed to get the map to display immediately try { MapsInitializer.initialize(getActivity().getApplicationContext()); } catch (Exception e) ...; Created on 25 November 2014
23. Android Java: Remove first two entries from Google News feed in SimpleRssReader: / AndroidOS /; ... replace with private List readFeed(XmlPullParser parser) throws XmlPullParserException, IOException { parser.require(XmlPullParser.START_TAG, null, "rss"); String title = null; ...; Created on 24 October 2014
24. Convert to Proper Case in T-SQL: / Transact-SQL /; ... first attempt based on snippets around the web. This one has two sections, the first part capitalizes any letter after a non-alpha letter. The remainder of it is to deal with exceptions to the rule, ...; Created on 04 June 2014
25. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... /P Prompts you before creating each destination file. /S Copies directories and subdirectories except empty ones. /E Copies directories and subdirectories, including ...; Created on 23 February 2014
26. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... string[] exceptionArray_this; string[] exceptionArray_that; // get the value we want to transform string ValueToConvert ...; Created on 04 October 2013
27. SSIS Convert a string into a date: / SQL Server Integration Services /; ... + "/" + SUBSTRING((DT_STR,8,1252)StartDate,3,2) + "/" + SUBSTRING((DT_STR,8,1252)StartDate,5,4)) Error: Description: "Invalid character value for cast specification". Exceptions for text file ...; Created on 14 March 2013
28. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... DOS REG Query!!!) All oracle utilities and connections working on my computer (except for TNSPING). TNS_ADMIN is another environment variable used that we must maintain (current value at "C:\app\\product\11.2.0\client_1\bin") ...; Created on 04 March 2013
29. Setup a copy of your Joomla website: / Joomla /; ... on the server itself. (ie. Fast & Reliable) Compress/backup LIVE files to ZIP file. Export LIVE database to SQL file. (Export > Custom > Save output to file) Except for configuration.php, delete ...; Created on 19 December 2012
30. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; ... to 01/01/2001 (Julian Days) v_returnedval := TO_DATE(TRUNC(DBMS_RANDOM.VALUE(v_rand_param1,v_rand_param2)),'J'); END IF; RETURN v_returnedval; EXCEPTION ...; Created on 22 August 2012
31. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... -- ending that second begin I had after my variable declaration END; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR (-20001, p_STUDENT_ADNAME || ':$:' || SQLERRM, ...; Created on 19 January 2012
32. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; ... [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [stored_procedure_name ]; Example CREATE OR REPLACE PROCEDURE sp_get_studentdetails_from_ad ...; Created on 16 January 2012
33. Basic Oracle Function Structure: / Oracle PL/SQL /; ... user parameters. Syntax: CREATE [OR REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS [declaration_section] BEGIN executable_section [EXCEPTION ...; Created on 15 January 2012
34. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; I'm storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to ...; Created on 02 September 2011
35. Creating a Profile Plugin for Joomla 1.6: / Joomla /; So there is other documentation out there. I'm basing most of this article on the official Joomla 1.6 documentation: http://docs.joomla.org/Creating_a_profile_plugin and I want to use an example that ...; Created on 27 April 2011
36. SSRS Use T-SQL Like with a Parameter: / SQL Server Reporting Services /; ... for it to auto-scroll down to the desired name. Our advanced users are exceptions to the rule. Problem Consider the following query: SELECT rb.[GivenDate] , rb.[DateStart] ...; Created on 04 April 2011
37. URL passed settings in Reporting Services: / SQL Server Reporting Services /; ... Reporting Server URL. Note: Change "" to the name of your Reporting Server Change "%2fMYREPORTS%2fDemos%2fRB+Report+for+Me" to the name and folder of your report. To hide all except ...; Created on 11 February 2011
38. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... to do the following: -- 1) Migrate all users except any matching the new admin in J30 -- 2) Migrate user who's ID in J15 matches the new admin ID in J30 -- 3) Recover odduser's ne ...; Created on 30 January 2011
39. Windows Live Messenger: Error 80048820: / Windows OS /; ... you need to check that the time on your windows clock is accurate or close to real Internet time: Quit/close all desktop gadgets except the CPU monitor and your analogue clock. Make sure your ...; Created on 08 March 2010
40. Project Plan for Freelance Website: / Web-Development /; ... material (can include fonts, images, word documents, etc) We can accept most formats except for those exclusive to the Apple Mac operating systems. Webspace Setup For JoelLipman.Com to do: ...; Created on 25 February 2010