Assuming count is required, the following 76 results were found.
-
off the invoice module to initiate your Stripe terminal to take a payment. Why? Just to make it easy on the staff at a counter or on the phone. They bring up the invoie in ZohoBooks, click on the button, and the Stripe terminal will ask for the amount...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
== v_TicketRef]; for each c_TicketRecord in c_TicketRecords { info "Ticket Ref: " + c_TicketRecord.Ticket_Number; v_CountImages = 0; v_CountNew = 0; for each c_ImageRow in c_TicketRecord.Images { v_ImageRowID = c_ImageRow.ID.toString(); v_CountImages =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
// // selecting a record which has a file upload field that we want to upload to c_Check = My_Form[ID == 123456]; if(c_Check.count() > 0) { // // A quick CSV line f_TestFile = "Test 1,Test 2,Test 3".toFile("test.csv"); f_TestFile.setParamName("file");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Modified: ??? - ??? More Info: - ******************************************************************************* */ // v_CountUnique = 0; v_CountTotal = 0; v_CountDeleted = 0; // // pagination v_PerPage = 500; // // loop through pages to fetch as many...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
release Date Modified: ??? - ??? ******************************************************************************* */ v_CountTotal = 0; m_OutputAll = Map(); v_Endpoint_Goals = "https://people.zoho.com/api/forms/P_Goals/getRecords"; r_GoalsData = invokeurl...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
be able to login, despite their status in the admin panel saying "enabled" and "activated" (not blocked). If I used a test account, none of the Joomla groups, not even "Administrators" could login. However set the same test account to a "Super User" and...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
is the data series from an outer join where the joining index value is null. The chart below has 3 series or data fields: Count the total number of incidents logged (Y-axis - data fields) Invidividual the incident(s) are assigned to (Labels - series...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
then add them in the order you want them to load) to get the timestamp of when the queries started. IIF your result row count, if it's zero, just display blank, else, do the rest of the query. Blank out the textbox basically (execution time is kinda...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the SQL for the Select statements EXEC SearchTables @Tablenames = 'T1' ,@SearchStr = '%TEST%' ,@GenerateSQLOnly = 1 */ SET NOCOUNT ON DECLARE @CheckTableNames Table ( Tablename sysname ) DECLARE @SQLTbl TABLE ( Tablename SYSNAME ,WHEREClause...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
1, 0)) 'CS', SUM(IF(t1.VisitorBrowser='Smartphone', 1, 0)) 'Smart', SUM(IF(t1.VisitorBrowser='Other', 1, 0)) 'Other', COUNT(t1.VisitorBrowser) 'Total' FROM (SELECT a.DateTimeStamp Date, CASE WHEN INSTR(a.VisitorUAgent, 'MSIE ') THEN 'MSIE' WHEN...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
FROM 5), '/', SUBSTRING(YEARWEEK(s.DateTimeCreated,1), 1, 4)) AS ActivityWeek, CASE COUNT(*) WHEN 1 THEN '(1 Event)' ELSE '(Multiple Events)' END AS DataAccuracy FROM StaffActivities s INNER JOIN Users u ON u.UserID=s.StaffUserID INNER JOIN Resources r...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other side of the midnight hour... Now bear...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
templates and want the HTML to be indented neatly. Other examples out there will work, but I found that once the list count increased the number of digits (eg. 1.10) the text would be more indented (relative) to 1.1. I need all list elements to be all...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
= "((SELECT LENGTH(t.PageContent)-length(replace(LOWER(t.PageContent),LOWER('$term'),'')))/LENGTH('$term'))"; } if (count($terms)==0) { $terms=array(); $terms[]=strtolower($sanitized_search); $terms_db = search_db_escape_terms($terms); $terms_db_sql =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
// set the url, number of POST vars, POST data curl_setopt($ch,CURLOPT_URL, $url); curl_setopt($ch,CURLOPT_POST, count($fields)); curl_setopt($ch,CURLOPT_POSTFIELDS, $fields_string); // execute post $result = curl_exec($ch); // close connection...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
index - Re-fixed module class suffix parameter ??? - Reworded "Display SQL Query" to "Debug Mode" - - Added word frequency count checker in debug mode - Date Uploaded: Sat, 9th Apr 2011 1.5.1 - Modified core script for PHP4 compatibility. - Functions...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *