... Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps.
How?
We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it.
v_XeroTime="/Date(1586995200000+0000)/";
v_StartIndex ...
... r_Response;
// yields: }
info r_Response.get("item");
// yields: "item_id": "2124100000000081031", ....
info r_Response.get("item").get("item_id");
// yields: Value is empty and 'get' function cannot ...
... ID,Name,Phone,Record ID
1457102000000135533,Joel,00441234567890,1457102000000165989
1457102000000135566,Stanley,01709123456,1457102000000167543
1457102000000135608,David,00331234567890,1457102000000166795
My ...
... = "aaaabbbbccccddddeeeeffff111122223333444455";
v_RedirectUri = "https://www.zoho.com/books";
//
// enter the code received in the previous step
v_Code = "1000.00001111222233334444555566667777888899990000aaaabbbbccccddddeeeef";
v_EndPoint ...
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 ...
... Capital International Airport 40°4′20″N 116°35′51″E 40 4 20 N 116 35 51 E 40.07222222 116.597500000 40.07222222 116.5975
Beijing Shahezhen Air Base ...
Applies to:
Android Studio (Beta) 0.8.6
Google Android Maps API
What?
I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely ...
... for some reason the code does not exist the code lookup will fail:
-- If CODE=0000 and 0000 does not exist in table to lookup name,
-- Using &G[COD.SRS:•|•]
-- yields:
-- But if CODE is not populated,
-- ...
... What I have
Image00001 (Copy).jpg
Image00002 (Copy).jpg
-- What I want
Image00001.jpg
Image00002.jpg
How?
Before I continue, the undo may work in MS Windows (Control key + Z) but don't count ...
... its extension (eg. "C:\Temp\SourceFiles\File00001.txt" - although I used a network share without any issues)
Add a Connection Manager
Right-click in "Connection Managers"
Select "New Flat File Connection..." ...
... 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 separate ...
...
For example:
rm_f1st('0','280','true','false','000000','3sv7MUqXeMI','true','ff0000');
or
The Unique ID code would be "3sv7MUqXeMI" (without the double-quotes)
How to do this without ...
... the second based on the first will error this procedure.
One Issue
I just kept getting this error over and over again:
ORA-00936: missing expression
00936. 00000 - "missing expression"
The ...
... TOP 1
'' AS Name,
CONVERT(uniqueidentifier,'00000000-0000-0000-0000-000000000000') AS ItemID
FROM
ExecutionLogStorage
) AS d1
ORDER BY d1.Name ASC
Additional Modifications:
For ...
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.