... as `total`, `value`
FROM (
SELECT count(*) AS `total_count`, REPLACE(REPLACE(REPLACE(x.`value`,'?',''),'.',''),'!','') as `value`
FROM (
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(ExtractValue(t.`introtext`, ...
... v_Output;
}
This is my preferred method and it will return a string of 5 random uppercase letters.
Method #2: Convert time to letters
I've previously used substring to extract the milliseconds ...
What?
This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...
What?
This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again.
Why?
I want to modify a picklist and fill ...
... XML declaration from results
$output = substr($output, stripos($output, '?>') + 2 );
// remove leading spaces, carriage returns
$output = trim($output);
// process if type specified was xml
if($apimo_type=='xml'){
...
...
AND t1.`extension`='com_content'
AND t2.`extension`='com_content'
SET
c1.`catid`=t1.`id`;
-- Joe-Code: LIST Rows to be affected (for test purposes)
-- SELECT SUBSTRING(a.`name`, 1, INSTR(a.`name`, ...
What?
An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value:
-- What I have:
//
-- ...
Applies to:
Microsoft Windows 7 Enterprise
SITS:Vision Students (v8.7.0)
What?
You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the ...
... for Oracle:
-- -- REGEXP_REPLACE(country_name, '(.)', '\1 ')
-- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0
-- -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1, 'x')
Microsoft T-SQL
Note the ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.