Assuming almost is required, the following 25 results were found.
-
AS VARCHAR), 3)=q.Employee -- yields EmployeeNo QualificationRef -------------------------------- 001 00101 001 00101 Almost useful... but the qualification reference has to be unique. We're going to add the ROW_NUMBER() to the employee number to create...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
to 244 F4 U+2320 ⌠ top half integral 245 F5 U+2321 ⌡ bottom half integral 246 F6 U+00F7 ÷ division sign 247 F7 U+2248 ≈ almost equal to 248 F8 U+00B0 ° degree sign 249 F9 U+2219 ∙ bullet operator 250 FA U+00B7 · middle dot 251 FB U+221A √ square root...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
are grouped into the one desktop. If you have a multiple monitor setup (ie. more than 1 monitor), then MS Windows will almost remember which apps were open on which screen but always on Desktop 1. In addition, there are some developments on AutoHotkey...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
system AMCharts.com. AMCharts.com provide a flash-based interactive chart which you can zoom in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
and to convert images. Autohotkey (my favourite automation tool) to combine the two into an executable and interface (almost as quick as google's chrome :c). Version 0.6 beta is ready. I've left it in BETA stage without an official release because I'm...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
data","status":"error"} Solution: The above ALMOST works for API and Deluge Shortcode, but we're missing the colon in the TimeZone value: v_TimeZone = zoho.currentdate.toString("Z"); v_TimeZoneStr = v_TimeZone.substring(0,3) + ":" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
show Tab_Section_6; } else if(input.Tabs == "eBay Preview") { show Tab_Section_7; } else { show Tab_Section_1; } Done! Well almost Set Clicked Tab to Selected One niggling issue I had was that when selecting a tab, the selected tab didn't stay a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
title handle } updatedAt } } } } I found this is the same as the inventoryQuantity so might as well reduce those costs (by almost a half!). Source(s): Shopify Partners - How to Generate a Shopify Access Token (legacy) Shopify Community - API To Search...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
m_ScheduleMeeting.put("Owner",123456789012345678); // // related to what (in this example, a lead record but can be almost any kind of record) m_ScheduleMeeting.put("What_Id",98765432109876543); // // the subject...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
bring up the invoie in ZohoBooks, click on the button, and the Stripe terminal will ask for the amount on the invoice. Well almost. We've gone the extra step in that we added a custom field that can override the full balance, to allow partial payments...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
and a body. The 2nd caveat is a concern around security. It is difficult to guess a customer's Zoho ID; some might say almost impossible. To use other fields that could be sent via the URL as a verification to be checked at the webhook endpoint would be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
some additional fields/columns added to it. Turns out, it's a system report you can't change. Enter Zoho Analytics... well almost, Analytics will sync with Zoho People but I wasn't able to select the performance modules (Client Review and Placement Tech...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
line. Notes and findings: Integration locks: The “Accounts associated with Integration cannot be marked Inactive” message almost always refers to a stuck bank feed token, not a third-party app. This can only be cleared by Zoho’s backend support. Yodlee...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
work. They even add a note to say that Joomla 1.6 uses a different version of Mootools and handles forms differently. Demo Almost forgot this, you can view my example at:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
the all important clear button. What I found was that no one posted this solution which I found is compatible with almost any site and with all my components without having to modify the below script. Why? The article modal is a much easier way for the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
in nearly all cases, is to use the "conditional split" task and test one of the columns for a length of greater than 1: Almost! A problem not covered by many sites was happening to me when I had blank rows in a flat file, where it appeared to add the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
my second select query (the one preceded with "open cursor for") didn't match my SSRS report field name mapping. Done! Well almost as you still need to design your report. At least this article should have got you to the part where you're simply...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
SUBSTRING(@Haystack, LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)), LEN(@Haystack)) -- yields "3.String4" Almost there, counting backwards and forwards it seems the index is just two characters off (as I don't want to include the period):...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
If you have more than 999 items in the column, then you may need to increment the 3 in the above statement "LEFT(..., 3)". Almost there, but in the above example, the dates are wrong for subsequent days off sick: SELECT EmployeeNo , DaysOffSick ,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *