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 ...
... and add funds to another:
$mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'");
$mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'+1000000 WHERE 'user' = 'Fred'");
What ...
Applies to:
TravelPort Universal API
PHP 4 or 5
cURL
What?
An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...
... close without warnings or notifications.
We found that if the query only returned 1000 rows, it completed and displayed in just under 1 minute. If limited to 500 rows, it would complete in just under ...
... + 1000 pts if in title x1 (eg. if word is twice then 2000pts)
// + 60 pts if in introtext
// + 40 pts if in fulltext
$sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false)));
$query->select('
(1000*((LENGTH(TRIM(a.title)) ...
... getdate()))
Seconds to Time SEC_TO_TIME( seconds ) CONVERT(varchar, DATEADD(ms, seconds * 1000, 0), 114)
Add/Subtract Date DATE_ADD(date,INTERVAL number datepart) DATE_SUB(date,INTERVAL number datepart) ...
... from dual;
-- yields values between 0 and 1
select dbms_random.value(1,1000) myAlias from dual;
-- yields number between 1 and 1000
select dbms_random.string('U', 10) myAlias from dual;
-- ...
... right-pane and type the following c:\windows\system32\cmd.exe /c "ECHO > c:\temp.txt | FC /N /LB 1000 %L c:\temp.txt > c:\results_file.txt | start c:\results_file.txt"
Right-clicking on a text file now ...
Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum:
Quick Count
=INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&"")))
...
... error usually returns in the format of -12345. If we want to look them up the error is ORA-12345. Unfortunately Oracle also returns errors of less than 10000 so ORA-00201 would actually be returned as ...
Just a quick note as I use this function in various scripts. This adds the 1000th separator comma:
FormatAddCommas(val) {
Result:=val
StringLen, OutputVar, Result
NumLoop ...
... go down the route of uploading 10000+ images into a Sharepoint database though we are still considering it; so this article is more about just getting external images to display when they are provided ...
... and used for the best of 2 years. But 1000 downloads in 10 days caused it to crash my Joomla! website. It was very plain and basic, needed tweaking to get rid of adverts and to integrate with a website' ...
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.