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 ...
...
Reminder: The script only affects data already in UPPERCASE. Change the IF (UPPER(@Text)=@Text COLLATE Latin1_General_CS_AI) line if you want to change this.
OriginalProper-Cased
JOHN SMITH-JONES ...
What?
A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name.
-- What I have
John Smith
Fred.Bloggs
-- ...
... in 0.4 seconds. So where's the problem?
How?
Left to its own devices, a search for "SMITH" as a surname would make the report spin for about 10 minutes without the possibility to cancel (link not ...
... -----------
1 John Smith 1988-06-24
2 Fred Bloggs 1972-11-17
3 Another User 1964-02-18
After:
ID Name DateOfBirth
--------- ------------ -----------
1 ...
What?
This is an article to demo the crudest form which uses Joomla's version 2.5 core mootools (uncompressed?). This is intended for absolute novices (like me) who just want to see an example of an ...
... NVL(student_details.studentSurname, 'Smith') "SURNAME"
FROM
student_details
WHERE
student_details.studentID = v_studentreference;
This errors when ...
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.