Assuming count is required, the following 76 results were found.
-
this employee belongs to Search for employees of the same department (team members) who have booked the same days off (ie count holiday clashes) Prevent an employee for applying for leave if over 80% of the department have already booked the requested...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
}, { "Currency": "USD", "id": "123456789000000005" }, { "Currency": "USD", "id": "123456789000000006" } ], "info": { "count": 200, "more_records": true } } Which isn't what I want because it has returned the same currency several times and thinks...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
123456789012); r_PortalListing = Portal_Listing[Shopify_Product_ID == v_ShopifyProductID]; if(r_PortalListing.count()>0) { v_Filename = r_PortalListing.Main_Photo.getSuffix("/image/").getPrefix("\""); v_ImageSrc = "https://creator.zoho.com/file" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
form: one called "Customer's TimeZone" and the other called "Agent TimeZone", then our code needs to take these into account and will look more like the following: // defaults v_AppointmentType = "Initial Consultation"; v_AppointmentDuration = 30;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ // // fetch the package record c_Package = Zoho_Inventory_Package_Slips[ZI_Package_Ref == v_PackageRef]; if(c_Package.count() > 0) { l_PackagesToAdd.add(c_Package.ID); } } c_Appt.Zoho_Inventory_Package_Slips=l_PackagesToAdd; } Error(s: Previously my...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- 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
- Language: *
-
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
-
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: *
-
= "((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
-
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: *
-
:= 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: *
-
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
-
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
-
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: *
-
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
-
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
-
// 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 for...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- 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
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF