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: *
-
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
-
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: *
-
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
-
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: *
-
you may want to find: Company Name: Father & Sons (Incorporated) Contact Name: O'Reilly How? Well I've tried various replace methods with regular expressions but the only method reliable enough I have found to work each time is using the CRM Object...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- 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
-
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: *
-
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
-
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
-
use this number in a second query which we're hoping will be quicker than a straightforward table join. Syntax CREATE [OR REPLACE] PROCEDURE stored_procedure_name [ (parameter [,parameter]) ] IS | AS [declaration_section] BEGIN executable_section...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- 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
-
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: *
-
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
-
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
-
if the received XML is a string. // setting XML value $string = ' 2/13/2013 10:37:24 PM Failure Incorrect Contact ID '; // Replace UTF-16 with UTF-8 $xml_string = preg_replace('/( urlencode($last_name), 'fname' => urlencode($first_name), 'title' =>...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF