Assuming often is required, the following 36 results were found.
-
is losing time because of a system clock problem. A workaround in this instance is to change the NTP client to update more often. Note: The following process requires administrator (installation) rights on your computer. Open regedit.exe through the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
A quick article on getting the payment terms in Zoho Books along with their IDs. Why? I often need to send through an automatic payment term on the creation of an invoice but lots of my clients set their due dates differently. How? The following snippet...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Inventory Level Update notification Note that this one is not the "Inventory Item Update" as I get the two muddled up very often and they don't do the same thing. We want this triggered whenever the stock level of a product changes. /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {... } isBlank() can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc). My aim is to do the following: retrieve...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
are interesting but as with a lot of showroom demo sites, "the picture that came with the picture frame you bought can often be nicer than the picture you put in". i.e. it's a showroom and you've got to complement the template with your own visuals. Had...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Calculating Percentagehttps://www.joellipman.com/articles/ecommerce/calculating-percentage.html
I need to often be reminded of how to calculate a percentage. The context here is that I want a progress bar in one of my programs. To determine what percent a number is of a total number: (Progress So Far / Total Progress Units) * 100 = % or (Net...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
or prospective tenant/landlord suggests using an escrow service to complete the transaction. These escrow websites often may look official, but are actually run by fraudsters. They’ll take your money and never send you the product. Payment for...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
row and paste your expression in the "Fill > BackgroundColor" properties row... Done! Borders: I'm putting this here because often enough, if I'm going to make the report pretty with alternating rows, I'm probably going to look at the cell borders as...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
great resource for learning Javascript. In the image above, note the document object - you will be using this object quite often. To access the Webpage, you will need to navigate through the HTML DOM. Here are some simple ways to do this: Object Name &...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html
summing the remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then is it slower? Not necessarily. Like all measures in bytes, I would like a thousand separator, and lose...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
have proposed stupid extensive solutions when all you need is one command-line. Why? Working with programming languages, I often need to write the accompanying documentation. Within the documentation, I may want to refer to a line of code within a text...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
to be the same size as the numbers but not overlap any list item beneath it. By increasing the size of the asterisk, this often increases the line-height and causes the overall line height to change for other objects in the same row. The problem...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
of the article as it is what you should do before running a DELETE FROM statement but I've added it here as I use it quite often: SELECT s.sessionId, ssf.sessionId, sst.sessionId FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Run the first query again and no rows should be returned. Quick Joomla One I use this reluctantly but often necessarily. SET @stringtoFind=' '; SET @stringtoReplaceWith=' '; UPDATE `MYTABLE_content` SET `introtext` = REPLACE(`introtext`, @stringtoFind,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Data Flow task to stop running. There may be error messages posted before this with more information about the failure. -- often when processing a datasource, the function is being applied to a NULL date timestamp. Dealing with Date NULLs: Fix: Put...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
me to reduce the risk of nasty surprises and also allows me not have to Google search every solution. As an IT developer, I often get told I may win the lottery or get run over by a bus, so I am used to needing a backup plan. My aim is always to hand...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
be a space in between the two words "Academic" and "Week" otherwise the system will only understand the carriage return and often return it as "AcademicWeek"). Other Search(es) Format a column alias with new line Using carriage return in column names...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF