Assuming count is required, the following 76 results were found.
-
Layout is "Standard" Event Type is "Page Event" Event is "onLoad" Click "Next" Method 1 This includes a function which counts the number of decimals. I didn't need to use this method for my client; just rounding the decimals would suffice but here is my...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
release Date Modified: ??? - ??? More Info: Error 7008: There are no contact persons associated with this Invoice. - Encountered when trying to use the send an invoice API - Need the generated invoice to pre-select a contact person to email - Superceded...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
'?p=', id) AS guid, '0' menu_order, 'post' AS 'post_type', '' post_mime_type, 0 comment_count FROM my_joomla_db.jos_content ORDER BY id Importing the joomla categories to Wordpress: (still to do: sections as parent categories?) SET...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
nvarchar(32) NOT NULL either rsSuccess or an error code; if multiple errors occur, only the first error is recorded ByteCount bigint NOT NULL Size of rendered reports in bytes. RowCount bigint NOT NULL Number of rows returned from queries. Conversions...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
we had a convoluted query which needs to join the two tables so that we get the "MapOut" value: SELECT r1.MapIn ( SELECT (COUNT(e2.EmpType)-1) AS MyCount FROM DMExtractEmployeeTable e2 LEFT JOIN DMExtractReferenceTable r2 ON e2.CodeType=r2.MapIn -- THIS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
:= COM_CreateObject( "Shell.Application" ) ; Contains reference to all explorer windows Loop, % COM_Invoke( oShell, "Windows.Count" ) { If pwb := COM_Invoke( oShell, "Windows.item[" A_Index-1 "]" ) If ( COM_Invoke( pwb, "LocationName" ) = name && InStr(...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
going to cover the basic code to: 1) get all monitors, 2) open an app on a specified monitor, 3) switch to another desktop. Count Monitors and Check it can see left-most, central, and right-most monitors: ; init DetectHiddenWindows, Off v_LeftMost := 0...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
using an AutoHotkey GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name. What I have EDIT 0_00 0_30 My File 1 00_00...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
} If ( Kind and Kind objDir.GetDetailsOf(objItm,11) ) ; File isn't desired kind { Return } i:=0, nParams:=p.Count(), fex.SetCapacity(nParams + 11) While ( i++...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
I want Image00001.jpg Image00002.jpg How? Before I continue, the undo may work in MS Windows (Control key + Z) but don't count on it. I'm going to use a short batch process but to save time on the different ways of doing this, the example below uses a...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
into the module parameter. Important Note: The ID it installs with is for my demo site. If you want to reset the visitor count and associate it with just your site, you'll need to visit www.revolvermaps.com and take your ID from the script code: For...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
to select the first day of the month and then loop until we find a Monday. Same for the last Tuesday except that we will count backwards from the end of the month: if(input.Switch_Over_Day=="First Monday of Month") { v_NextMonthDate =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
the EU datacenter Note that using this method, you don't have to escape parentheses characters (): // initialize v_MatchedCount = 0; v_MatchedAccountID = 0; v_SearchName = "Father & Sons (Incorporated)"; // // replace apostrophes with double apostrophe...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Ref must match) r_CreatorFile = Download_File[Owner_Email == v_ResultEmail && File_Ref == v_ThisFileCrmID]; if(r_CreatorFile.count()>0) { if(!isnull(r_CreatorFile.File_Download)) { v_LinkToDownload = v_CreatorBaseUrl + "/file" + zoho.appuri +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
per call and using since_id to not list the same one twice. It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map(); m_Header.put("Content-Type","application/json"); // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= ifnull(p_PerPage,200); m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion = r_Api.API_Version; v_Endpoint =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
type: GET connection: "joels_connector" ]; info r_Templates; // // yields something like: /* { "total_count": 5, "templates": [ { "created_time": "2019-08-28T16:30:33Z", "modified_time_ms": 1567009834477, "owner_id": "12345678", "last_opened_time":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_Page = 1; v_PerPage = 10; m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion = r_Api.API_Version; v_Endpoint =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
== v_CrmContactID.toString() && Document_Name == r_Attachment.get("File_Name")]; if(r_CheckIfDocumentAlreadyExists.count() > 0) { r_NewDocumentRecord = Document[ID == r_CheckIfDocumentAlreadyExists.ID]; v_DateAdded =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *