Search - Joel Lipman .Com

1. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... following stored procedure (or part of). What? This will copy a given table into a temporary table all the while maintaining the structure and data. Thinking inside of the box I think everyone ...; Created on 03 August 2012
2. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; Previously For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in ...; Created on 16 January 2012
3. Basic Oracle Function Structure: / Oracle PL/SQL /; What? I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function ...; Created on 15 January 2012
4. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... 1.3.1 - Modified code to work with Joomla! CMS versions 1.5.x - Removed parameter: Use Access Levels (does not exist in J15)- Date Uploaded: Sun, 3rd Jul 2011 1.3.0 - Restructured to MVC model for ...; Created on 07 September 2015
5. Joes Word Cloud (JWC) Download: / Downloads /; ... with 3rd-party apps. - Restructured extension into an MVC model (fixes H3 and Module Class Suffix issues) - Removed Joomla! Admin Option: Content Database Length- Date Uploaded: Mon, 13th Jun 2011 ...; Created on 07 September 2015
6. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; Previously titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to ...; Created on 28 March 2015
7. Joes Search Module (JSM): / Product Documentation /; ... far and wide but as usual, I find myself to be the first to address this. How? The module I have made is very basic and not in an MVC structure but it has been tested on Joomla 2.5.28 and Joomla ...; Created on 09 March 2015
8. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... [0.7] Map: API codes and db requests - [0.6] Map: database restructure tweaks - [0.6] Map: add check button - [0.5] Map: connect to database for zones/restricted area - [0.4] Map: include wind and ...; Created on 24 October 2014
9. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... structure, but does not copy files. Does not include empty directories or subdirectories. /T /E includes empty directories and subdirectories. /U Copies only ...; Created on 23 February 2014
10. Client Services: Website Development Agreement: / Static Items /; ... is to host the production and development websites after release date. (see my pricing structure below). This is, of course, merely an initial draft of the agreement. Feel free to query, change ...; Created on 15 November 2013
11. htaccess Rewrites SEF URL and submits to PHP: / Personal Home Page /; ... you don't use in your site structure. Slashes and underscores /_ are good (so regexp: /[^a-zA-Z0-9_\/]/). If you allow percents (%) or apostrophes (*) then you are asking for trouble. Note my redirect ...; Created on 05 September 2013
12. Reorder Columns in a Table: / Databases /; ... Method: phpMyAdmin So in the phpMyAdmin interface, apparently, you can drag the columns by clicking and holding on the headers when viewing a table structure... Though maybe this is derived from ...; Created on 22 July 2013
13. Generate Academic Calendar using MySQL: / MySQL /; ... is to quickly generate a calendar for a full academic year for referencing by staff/students. How? Let us assume that we have a system holding a calendar in the following table (called "joes_weekstructure"): ID ...; Created on 27 November 2012
14. Search a database for a string (MySQL, T-SQL): / Databases /; What? I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone ...; Created on 08 October 2012
15. Connect to Joomla database in standalone script: / Joomla /; ... of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, ...; Created on 17 August 2012
16. DataJumble - Shuffling characters in a data value: / Transact-SQL /; This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...; Created on 01 August 2012
17. T-SQL Record Separator: / Transact-SQL /; ... ASC, t1.Finish ASC) as 'RowNumber' FROM ( SELECT DATENAME(dw, tt.[WeekDay]-1) AS 'Day', dateadd(d, tt.[WeekDay] - 1, (SELECT TOP 1 StartDate FROM [pretendDatabase].[pretendSchema].[WEEKSTRUCTURE] ...; Created on 11 October 2011
18. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... will be category field: So is this doing what I wanted? Well NO. I have a table with the same report mentioned several times but just in a different week. I want a returned table structured ...; Created on 03 August 2011
19. Run commands for Windows: / Windows OS /; ... Import Utility wabmig Windows Backup Utility (if installed) ntbackup Windows Explorer explorer Windows Firewall firewall.cpl Windows Magnifier magnify Windows Management Infrastructure wmimgmt.msc ...; Created on 05 July 2011
20. Creating a Profile Plugin for Joomla 1.6: / Joomla /; ... a subfolder called "profiles". So I should end up with the following file/directory structure: ./profile5 ./profile5/profiles Also copy one of those handy blank "index.html" files into ...; Created on 27 April 2011