Search - Joel Lipman .Com

41. Reorder Columns in a Table: / Databases /; ... Open it using a text editor Modify the order of the columns, for example: -- From CREATE TABLE IF NOT EXISTS `Table1` ( `Column1` int(11) NOT NULL AUTO_INCREMENT, `Column3` int(11) NOT NULL, ...; Created on 22 July 2013
42. Things to Check if Joomla Password Reminder email not being sent: / Joomla /; ... to check: Check the email message even exists: Login to your Joomla Admin Panel Navigate to Extensions > Language Manager Click on the “Overrides” label Click on “New” (but don’t create a ...; Created on 09 May 2013
43. Improve Default Joomla Search: / Joomla /; ... \components\com_search\views\search\view.html.php \language\en-GB\en-GB.com_search.ini [IfExists] \modules\mod_rokajaxsearch\mod_rokajaxsearch.xml Stage 1: Add Relevance [Mandatory Stage] ...; Created on 07 May 2013
44. Change the default Joomla Error template: / Joomla /; What? This is a quick article on what I change the error page for Joomla websites to. I like a clean error page, for a demo visit http://www.joellipman.com/my_error_page. Applies to Joomla 1.6.x, 1.7.x, ...; Created on 04 April 2013
45. Free Translator API using Google: / Google /; ... exists. Just don't try to exceed your free quota: Visit http://translate.google.com/manager/website Sign in using your Google APIs developer's account (FREE). Copy the JavaScript they give you (eg. ...; Created on 08 January 2013
46. DataScramble - Randomizing data rows: / Transact-SQL /; ... 1964-08-08 How? Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', ...; Created on 07 December 2012
47. Search a database for a string (MySQL, T-SQL): / Databases /; ... WHILE EXISTS (SELECT 1 FROM @SQLTbl WHERE ISNULL(Execstatus ,0) = 0) BEGIN SELECT TOP 1 @tmpTblname = Tablename , @sql = SQLStatement FROM @SQLTbl WHERE ...; Created on 08 October 2012
48. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... I wouldn't need to post this note on my website. Thinking outside of the box Hooray for you non-sheep! This is what I've come up with: -- Drop Stored Procedure if already exists IF OBJECT_ID ( ...; Created on 03 August 2012
49. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... you need permission to create this function. Don't forget to GRANT permission to execute this function for whatever user/system account that will run it. -- Drop the function if it already exists IF ...; Created on 01 August 2012
50. Prefix Line Numbers in a Text File: / MS-DOS /; ... c:\results_file.txt to %TEMP%\results_file.txt to send the file to your temporary directory instead of using the root c drive. If you do not have c:\windows folder than find where "cmd.exe" exists and ...; Created on 18 July 2012