Assuming first is required, the following 215 results were found.
-
DECLARE @StartTime datetime, @EndTime datetime, @GivenDate datetime; SET DATEFORMAT dmy; SET @GivenDate = '23/03/2011'; --First slot of the day SET @StartTime = @GivenDate + ' 08:00:00'; --Last slot of the day (30 minutes before the end) SET @EndTime =...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
IE7 standalone breaks the IE6 standalone and none reported the fix... If you only want Internet Explorer versions 7 & 8 First install Internet Explorer 8 as per usual (from Microsoft's site) Then download and install IE7 Standalone (from...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to a number only retrieves the first value before the first comma. Consider the following, the first query is how MySQL interprets the query and the second is...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
7 seconds // full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually we just want the first two words of those strings: 3 days ago // where event is 3 days ago or just over but less than 4 days ago 1 week ago // where...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
we want 01 to equal 1 StringSplit, DaysPerMonth, DaysInMonth, `, DaysInThisMonth:=DaysPerMonth%ThisMonthNum% ; get the first day-of-week of this month FormatTime, firstDayBlankNum, %A_YYYY%%A_MM%1, WDay ; add blank spaces in front of this first day...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
folders named "Profile 1", "Profile 2", etc. Scan the preferences file for JSON key "name" and extract value. Hide the first column in the list view (contains "Profile 1", "Profile 2",...) Sort the second column (contains "Joes Personal Profile", "Joes...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
This is an article serving as documentation for my first ever app on the Android Operating System. For tablets and phones. The app in a nutshell displays flight restrictions in a given area Description As a quadcopter flier myself, I wanted an app to...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet of code below is using the functions to read data from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: en-GB
-
5 letters. Why? Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How? The first note is that there is something that can emulate a random number... well it's not really random, it involves getting the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
!important;} 2. Trigger the notification There are several ways to display this as a popup, the first use example is on report workflow (click of a button in a report row) but I've also used this on the submission of a stateless form, in deluge:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
is deprecated (so no authtokens) and API OAuth2.0 is in full swing... we're still going to cheat. How? 1,2,3 steps really. First we're going to set up a Creator form to receive the JSON. Secondly, we'll create the endpoint URL for the webhook. And...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
appointment is at 10am. How? So adding a datetime field and calling this one the "Customers Appointment Time" is the wrong first step. Reason being is that datetime fields hold the time zone they are set in (ZohoCreator > Settings > Date and Time...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
are: Setup recurring FTP connection. Make data readily available to ZohoCRM. How? Well, let's setup the FTP connection first in Zoho Analytics: Login to Zoho Analytics Click on "Data Sources" in the left sidebar then click on "Add Data Sources" in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
app function. How? If we're not going to use loops, then the next best thing I'm aware of is a regular expression. So the first expression I came up with worked to a certain point but didn't round up the numbers, in other words, it didn't remove the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// init l_Pages = {1,2,3,4,5}; v_PerPage = 200; // // get other products with the same name (set in order of oldest first and keep only first one, delete the others) m_Params = {"select_query":"select id, Product_Name from Products where Product_Name =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
"Which_rate_card_is_this_based_off". The expected outcome is the appending of a row to the subform based on the start date (first field in the subform) match in which case it should re-add the row with an "End Date" specified (blank or not)....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
either. How? In the example below, we are going to document how to import files associated to CRM Contact records. There's first the preparation of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
with the code to download image attachments from a Zoho Ticket and then to upload the attachment to Zoho Analytics. Why? First of all, we couldn't find how to sync attachments from ZohoDesk to ZohoAnalytics using the integration. Other tables will sync...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
back to the 90s. The code snippet below is just for a standard template with a modern design. How? Ok, admittedly, when first designing the template, there could have been a fair few improvements right out of the gate. Then the client comes back and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
record [DEPRECATED: Please use Generic Webhook at the bottom of this page] For this, we'll create the webhook function first (this one I've called Fn - ZohoSign - Document Completed) and then make it into a REST API function for ZohoSign to send the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *