Assuming replace is required, the following 100 results were found.
-
JOOMLA v1.5.x TO JOOMLA v2.5.x -- -------------------------------------------------------------------------------- -- NOTE: Replace string "mydb_livecopy_j15" to your Joomla 1.5.x database name -- -- -- (example: "anolddatabase") -- 9 occurrences --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
keytool -list -v -keystore c:/Users//.android/debug.keystore -alias androiddebugkey - storepass android -keypass android (replace with your windows login) Should be something like: To get the App SHA1 code: You have to add the correct SHA1 to the Google...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
and converts it to a date: -- Assuming EndDate is optional (can be null) and in format DDMMYYYY: -- Derived column task 1: Replace 'Date' TRIM(Date) != "" ? TRIM(Date) : "00000000" -- Derived column task 2: Add as new Column 'DC_Date' -- (note this is a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
to MySQL. So the following query will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Count by Split+Count took : 0.44112181663513 Seconds Count by Preg_Match+Count took : 0.46423101425171 Seconds Count by str_replace took : 0.23512482643127 Seconds Count By str_ireplace took : 0.39766597747803 Seconds Count By Explode+Count took :...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
function getUrlAlias($p_Name){ // lowercase and trim preceding/trailing spaces $v_Output = strtolower(trim($p_Name)); // replace all non alphanumeric characters (except underscore) to an underscore $v_Output = preg_replace("/[^a-z0-9\_]/",...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
it was rather rewarding to achieve and I hope will be of some use to others in the same boat. This article details how to replace jComments built-in kCaptcha with Google's ReCaptcha. Note that I have an article on how to do this with a ReCaptcha...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
columns: Flat File Source: Ignore failure on Truncate, Output "KeyColumn" and "DataColumn". Derived Column Task: Trim and Replace special characters from "DataColumn" and "KeyColumn". Conditional Split Task: Check keycolumn is not null and data column...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
memory aids for me so that I don't have to keep looking them up: MySQL T-SQL Strings String Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [, offset])...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
the command prompt and a bit of string manipulation. This example will rename files which contain the string " (Copy)" and replace it with nothing (so removes it). The challenge here is the space character and delimiting by a string. The Gist -- What I...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
Implicit TLS/SSL, and SFTP - SSH File Transfer Protocol on a Port number of your choosing: Set for new imports to append, replace, or check if exists then insert/replace: Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly: Schedule with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
file: /plugins/captcha/recaptcha/recaptcha.php 2. Find the following string in the OnDisplay function: return ' '; 3. and replace with: // Replace YOUR_KEY with your public key return ' window.onload = function() { Recaptcha.focus_response_field(); } ';...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
allow the admin to select PlayThru. Open the file \administrator\components\com_jcomments\admin.jcomments.php (line 1066) Replace the line $captcha[] = JCommentsHTML::makeOption('kcaptcha', 'KCAPTCHA'); With this $captcha[] =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
the admin to select PlayThru. Open the file \administrator\components\com_jcomments\models\forms\settings.xml (line 398) Replace the line KCAPTCHA With this KCAPTCHA PLAYTHRU STEP #4: Set to PlayThru in admin setting We've made the change, now login and...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
FROM wikimedia_categorylinks WHERE wikimedia_categorylinks.cl_from=p.page_id) AS PageCategory, (SELECT GROUP_CONCAT(TRIM(REPLACE(ccg.GroupName_Friendly, '_', ' '))) FROM custombu_category_restrictions ccr INNER JOIN custombu_category_groups ccg ON...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
in Oracle Stored Procedure. Oracle: Grant another user permissions /* on the table: ssrs_audit_table */ CREATE OR REPLACE PUBLIC SYNONYM ssrs_audit_table FOR base_table_owner.audit_table; GRANT SELECT, UPDATE, INSERT ON ssrs_audit_table TO ssrs_sp_user;...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
IN ('' ,'%') BEGIN INSERT INTO @CheckTableNames SELECT Name FROM sys.tables END ELSE BEGIN SELECT @sql = 'SELECT ''' + REPLACE(@Tablenames,',',''' UNION SELECT ''') + '''' INSERT INTO @CheckTableNames EXEC(@sql) END INSERT INTO @SQLTbl (...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
the outputs. Method #2 Enhancing the above which does a little more of the work, requires in the following query for you to replace the terms "myDB1" with the first database name and "myDB2" with the name of the second database to compare to: -- columns...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
word SET @CaseLen = CHARINDEX(',', @CaseExceptions, @i+1) - @i SET @CaseValue = SUBSTRING(@CaseExceptions, @i, @CaseLen) -- replace it in the original text SET @Ret = REPLACE(@Ret, ' '+@CaseValue+' ', ' '+@CaseValue+' ') -- get position of next word SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
performance on some SSRS queries which accept either an ID number or an AD name as user parameters. Syntax: CREATE [OR REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS [declaration_section] BEGIN...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB