Assuming accounts is required, the following 35 results were found.
-
procedure to return no rows without erroring (ie. where rownum/rowcount = 0). Consider the following: SELECT NVL(student_accounts.studentID, 0) INTO v_studentreference FROM student_accounts WHERE student_accounts.studentUsername =...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
into this field. Authorize URL: Enter the Zoho authentication URL based on the client's datacenter: US datacenter: https://accounts.zoho.com/oauth/v2/auth EU datacenter: https://accounts.zoho.eu/oauth/v2/auth CN datacenter:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// can be any endpoint that does not redirect or reformat the resulting URL // // get Grant Token v_EndPoint = "https://accounts.zoho.com/oauth/v2/auth"; v_Scope = "ZohoBooks.contacts.ALL,ZohoBooks.invoices.ALL,ZohoBooks.purchaseorders.ALL"; v_State =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
Yields: { "TEST001": 6, "TEST002": 1 } Counting total products per account: // // count total products per account m_Accounts = Map(); m_Products = Map(); // // loop through each row for each r_StockRecord in Stock_Upload[ID != 0] { // // create map...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
and pass the record ID via a button to it, I'm adding it here in case I need to refer to it in future. Why? We have an Accounts module which holds all the companies we deal with in our Zoho CRM. I want our sales team to be able to click on a button off...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Zoho Apps. Prerequisites: Setup a connection called "joel_books" that has the necessary scopes to view taxes and chart of accounts Setup a connection called "joel_inventory" that has the necessary scopes to do everything under the sun Setup a function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
But to flesh that out a little more along with setting the other options under "Advanced Tracking" // // get chart of accounts to use r_ChartOfAccounts = invokeurl [ url :"https://books.zoho.eu/api/v3/chartofaccounts?organization_id=" + v_BooksOrgID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
only one open parameter, the OR clause just compares against the same parameter. So for example: Instead of... (student_accounts.student_name=@StudentName or student_accounts.student_id=@StudentID) I set this to......
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
errors (with an end!) BEGIN -- initial query to get me the student ID based on the inputted parameter SELECT student_accounts.student_id INTO p_STUDENT_REF FROM student_accounts WHERE student_accounts.student_username = p_STUDENT_ADNAME; -- opening...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
) ) AS "Status" FROM "Accounts" ORDER BY "Modified Time" DESC /**** Pseudo: Select Modified Time of Record If Modified Time is greater than yesterday's date (today) Use URL of the image representing OK Else If Modified Time is greater than 5 days ago...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
server space - expected size of website including all uploaded files. Add domain folder to the server. Setup FTP Accounts (just one username/password). Setup automated backup system. Create test space with same access details. Database Setup For...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
you should run the respective commands to update the Installer ID in these as well. Copy over users (but with disabled accounts): CHANGE the value of @v25_admin_id to the number (in my example "42") to the admin ID of your installer ID. --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
"Success" } Method #2: Using API v1 (using JSON not XML) Generate AuthToken: Browser Mode: Open a browser to https://accounts.zoho.com/apiauthtoken/create?SCOPE=ZohoCreator/creatorapi OR API Mode:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
type the value in the 2nd column "App to Run" then OK to run it: Settings Page App to Run Settings Homepage ms-settings: Accounts Access work or school ms-settings:workplace Email & app accounts ms-settings:emailandaccounts Family & other people...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
for latest endpoint) v_Endpoint = "https://" + v_Account_SID + ":" + v_Auth_Token + "@api.twilio.com/2010-04-01/Accounts/" + v_Account_SID + "/Messages.json"; // // build up the JSON request m_Data = Map(); m_Data.put("Body",v_Message);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to get your Client ID and Client Secret. (Login as the client super admin or ascentcloud admin account) Log in to https://accounts.zoho.com/developerconsole Click on Add Client ID Select "Self Client" Provide the details and register your application...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= v_CandidateGraduatingNextCount + 1; } } } } // m_Blank = Map(); l_SchoolSearch = zoho.crm.searchRecords("Accounts","Account_Name:equals:" + v_SchoolName,1,10,m_Blank,"zcrm"); for each r_School in l_SchoolSearch { // check no search error and valid...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of code to get dynamic maps of system values Purpose: Taxes, Currencies, Payment Terms, Sales Persons, and Nominal Accounts Inputs: - Outputs: - Date Created: 2021-09-24 (oel Lipman) - Initial release Date Modified: 2024-05-21 (Joel Lipman) - Change of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html
the involvement of a parent or guardian. JoelLipman.com and its associates reserve the right to refuse service, terminate accounts, remove or edit content, or cancel orders in their sole discretion. Reviews, Comments, Emails, and Other Content Visitors...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF