Assuming second is required, the following 68 results were found.
-
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 in old database but not in new SELECT t1.* FROM [myDB1].[INFORMATION_SCHEMA].[COLUMNS] t1...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
it may automatically modify the range. So the formula in the first row will be =COUNTIF(A2:A100, B2) but the formula in the second row will be =COUNTIF(A3:A101, B3): =COUNTIF(A2:A100, B2) -- Returns 1 if value in B2 was found in range A2:A100 -- Returns...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
Event_XML.query('/STAFF/EMPLOYEE_NUMBER') FROM [dbo].[XML_EVENTS] -- value() returns single value, specify data type as second parameter SELECT Event_XML.value('(/STAFF/EMPLOYEE_NUMBER/@name)[1]','varchar(20)') FROM [dbo].[XML_EVENTS] Issues: XQuery...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
- Map: lock map orientation to device compass - Map: replace map compass - Map: tap once to start a waypoint - Map: tap a second time to end waypoint - Map: drag markers for precision - Map: horizontal sensor level - Map: display gallery of screenshots...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
// In my case, the XML form that will be submitted curl_setopt($ch, CURLOPT_TIMEOUT, 15); // Target API has a 15 second timeout curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE); // TRUE to return the transfer as a string of the return value of curl_exec()...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
in a file, then the JWT is also in the file. A JWT is a three part value delimited by a period/dot. Base64 decode the second part and this will reveal the user's name and email (along with other profile settings) which you will have to be careful on...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
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 of code below is using the functions to read data from Zoho CRM and to write data back to the system. Why? I've...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
check your base64 encoded strings at JWT.io then it's hard because the timestamps, included in the encoding, change every second. You can get it verifying the signature successfully if you go get your public key, paste both keys into jwt.io (these don't...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
Search( is a case-insensitive search with the first parameter being the text to search for (can be a range) and the second the string to search (in this case a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from Sheet2. Note that...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
In addition, there are some developments on AutoHotkey forums where people are having difficulties opening an app on their second monitor. So I thought I'd jot down some notes here on how I've achieved this across multiple monitors... and now multiple...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
occurrence if(v_InputSwitch.toString().indexOf("First") >= 0) { v_DayOccur = 1; } else if(v_InputSwitch.toString().indexOf("Second") >= 0) { v_DayOccur = 2; } else if(v_InputSwitch.toString().indexOf("Third") >= 0) { v_DayOccur = 3; } else...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
subform when I need to use "INSERT" method twice and not the equals sign: once to add the row to the collection, and the second time to add the collection to the subform. Syntax for inserting a row into a subform: // declare a variable to hold the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
same popup will appear if you click on the edit icon in the header "Tax" (applies to subtotal). Note: If you do not do the second section as per this article, even having customized the tax rates, when selecting a product that has no tax rates against...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ // info "New Token Generated"; r_Api.Access_Token=r_eBayResponse.get("access_token"); v_AccessSeconds = r_eBayResponse.get("expires_in").toLong(); r_Api.Access_Token_Expiry=zoho.currenttime.addSeconds(v_AccessSeconds); v_Output = r_Api.Access_Token; }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
re-installing each year despite it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again, I'll add it to this article. How? I know there...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
for the upcoming week. How? As mentioned, using leftpad takes 2 parameters, the first is the string to start with, the second is the number of spaces to pad with. // // set number of times to iterate through loop (plus 1) v_CheckDaysAhead = 7; // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
disassociating it from the attachments), will remove the file permanently. You only need to run either of these as the second one runs both (disassociate and delete): // disassociate as attachment (removes attachment from the Bill but keep in ZohoBooks...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
The robot proceeds to chat with him about subatomic physics, black holes, and game theory. Curious, the guy comes back a second night. "What'll you have?" says the robot and the guy again receives the best martini of his life. "What's your IQ?" "100."...
- Type: Article
- Author: Joel Lipman
- Category: Jokes
- Language: *
-
wasn't. There is an additional/repeat action to add tags; the first attempts to copy over the color on a new tag; the second is if this fails to copy over the color (because there is an existing tag with the same name), then it only copies over the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
) AS r3 ON r3."Respondent ID" = r."Respondent ID" WHERE p."Title" 'GENERAL' ZohoSurveys - Page Responses Query This is a second query which queries the first query... Well it's for the radar chart and what it does is group all the responses per page...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF