Assuming cases is required, the following 18 results were found.
-
Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html
designed or sold for incorporation into a dwelling. In determining whether a product is a consumer product, doubtful cases shall be resolved in favor of coverage. For a particular product received by a particular user, “normally used” refers to a...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
form, on a change of a field or on the validate process. And because info can only be displayed to an admin and even in some cases only as an additional link in the form. The example below is for use in a customer portal on the click of a report button...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
only have to update the code for 1 workflow rather than 20 workflows every time we want to tweak the code. There are also cases we don't want to use a standalone function as we want the code to read from the input fields dynamically and in real-time. To...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to be written across multiple lines, as long as the statement ends with a semi-colon. This has a limited number of use cases, but is useful to be aware of if you have not come across it before. Why? In many Deluge scripts, assignments are often more...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to resolve the issue. If you have shared SSL your hosting company should have given you your secure URL which in most cases will be a domain with folder allocated to you. e.g. https://secure.example.com/username By going to the address given by your...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
We don't have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. On the system that used to do this, we could use the HTML...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
build a system that thinks of everything from day one? How? Check all required values to escape have been escaped. In all my cases this has been the percent sign (%) but I'm listing what needs to be escaped in SQL for future use: Character Description...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
come across clients who have the one version of their website. They experiment on their customer-facing website and in most cases, they are paying for a hosting package which would allow them to have several copies of their website. Why? In my job, it...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
rows amongst the data. The easy fix is by dealing with any empty rows. The best way I've seen that has worked 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
to be applied to names and titles rather than addresses, but here it is anyway, add this after the "loop through exception cases" while clause: -- Now for some UK (British) PostCode recognition SELECT @i=1, @CaseExceptions = @Ret; WHILE CHARINDEX(' ',...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
function on pressing the word GO handled = true; } return handled; } }); Other Noteworthy Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No suggestions/autocorrect...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
"ISO-8859-1" to "UTF-8". So if you get null from htmlspecialchars or htmlentities..." Source: PHP Manual My fix (in some cases): $my_description = html_entity_decode(htmlentities($my_description, ENT_COMPAT, 'ISO-8859-1', true), ENT_COMPAT, 'UTF-8'); A...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
= zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss") + v_TimeZoneStr; // value is "2020-02-10T11:49:12+01:00" // OR in some cases v_TimeZone = "Europe/London"; v_InsertDateTime = zoho.currenttime.toString("yyyy-MM-dd HH:mm:ss",v_TimeZone); Problem:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the ALT key and save the change to your code. This will not display a character but is a new line... Used in certain cases v_NewLineChar = hextoText("0A"); Thought I needed to add the following but this makes absolutely no difference:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
~all Check using the toolkit: Some registrars will say this can take between 24 to 72 hours to propagate. In our cases, a working example can return within the hour as authenticated. Use the following link to continue monitoring for when this has taken...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to display on their estimates in Zoho Books; such as product image, product name, product description. Granted that in some cases, the design should go in the other direction, as in enter the products in Zoho Inventory and this feeds the website. More...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Trim in T-SQL and SSIShttps://joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html
REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
and two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF