Assuming each is required, the following 209 results were found.
-
m_Blank = Map(); // // evaluate v_BooksOrgID = organization.get("organization_id"); // // loop through line items for each m_LineItem in salesorder.get("line_items") { r_BooksItem = zoho.inventory.getRecordsByID("items", v_BooksOrgID,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= 0; v_CountDeleted = 0; // // pagination v_PerPage = 500; // // loop through pages to fetch as many as possible for each v_Page in {1,2} { info "Page #" + v_Page; v_PageFactor = v_Page - 1; v_Offset = v_PageFactor * v_PerPage; // // get unique product...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of each line. function clean_cron_lines() { while read line ; do echo "${line}" | egrep --invert-match '^($|\s*#|\s*[[:alnum:]_]+=)' |...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in the row - unless there's a faster way) and instead of color, click on the expression button (fx) and use the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
1 mega dataset query, problem solved… Another workaround exists where if I added the OR part to all my datasets (so where each one says if studentreference is blank then compare to studentadaccount)… Both solutions have the issue where they will return...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times taken for "data retrieval",...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
** Description : This function returns a table populated with a row for each string value in the space separated string ** Assumptions : None ** Inputs : @StringInput = the space separated string values ** Outputs : Single table ** Output Rows : One row...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
- incoming, outgoing servers) Send Webmail URL Allocate space for mailbox(es) Assign passwords and instructions on changing each password Website Initiation For JoelLipman.Com to do: Download latest Joomla, MediaWiki, Wordpress or other CMS version (if...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
of your data (eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each data exists, sort it in reverse order so that the most frequent is at the top of the list print out each row with the number...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
fields, column header text objects, and summaries or subtotals) in the column by holding down the Shift key while clicking each field, until all the fields are highlighted. Right-click any of the fields, click Size, and then select Same Width. This...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
my_col2_val: 'item2c,c' } ]; What I want again: Read a CSV file already uploaded with JavaScript Populate a JS array with each row Account for strings containing double-quotes (and commas to ignore) Sort the resulting object array How? The function with...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
users = userResp.executeXPath("/users/user"); if ((users != null) && (users != "")) { userList = users.toList("-|-"); for each user in userList { emailNode = user.executeXPath("/user/@email"); email = emailNode.executeXPath("/email/text()"); if (email...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
{ // remember remember the 5th of november l_RememberLookup = List(); if(input.myLookup.size()>0) { for each v_SelectedLookup in input.myLookup { l_RememberLookup.add(v_SelectedLookup); } } } // // clear lookup clear myLookup; // // get list of all...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
2 fans from the 3rd pack of the CoolMoon 120mm Crystal - - The Result: Monitor cable connections I need to practice what I preach: "it's a poor workman who blames his tools". Let's make do with what we have. The 2 Acer monitors only have DVI and VGA...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
COM Support (recommended) the COM Standard Library - for use with AHK Basic Purpose The purpose of this tutorial is to teach the intermediate AHK user how to start using COM to control webpages. My goal is to provide methods for controlling webpages,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
copyright... Basically this is the third time I wrote this program, simply because I reghost all my computers (Home & Work) each year and can't be bothered to retrieve accidentally deleted programs from my backup drives. I downloaded a load of media...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Generation" is set to "NO". (Important! remember to switch this to YES when you have updated all your thumbnails as each thumbnail is one entitlement of the first 100,000 for free. After that there may be a charge or images may come back...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
// // build up a reference map from the line items of the newly created sales order m_NewLineItems = Map(); for each r_NewLineItem in r_NewSoDetails.get("line_items") { v_NewSoItemID = r_NewLineItem.get("item_id"); v_NewSoLineItemQuantity =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Put the link name that we will use in code later (preferably in lowercase as it will lowercase it anyway) Scope: Enter each scope you need and click on the plus icon to add each one. Keep "Use credentials of login user" ticked. You should have something...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the code to loop through all these matching records (and approved) and determine if it clashes with the requested dates: for each r_TimeOff in l_AllTimeOffs { if(!isnull(r_TimeOff.get("Employee_ID"))) { v_ThisStatus = r_TimeOff.get("ApprovalStatus");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *