Assuming contain is required, the following 24 results were found.
-
Why? This has taken me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: en-GB
-
first the preparation of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets of code or screenshots...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html
of intellectual property rights, or otherwise injurious to third parties or objectionable, and does not consist of or contain software viruses, political campaigning, commercial solicitation, chain letters, mass mailings, or any form of "spam." You may...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
such that it does. 5) The directory /etc/virtual/hostname must exist.. (eg: /etc/virtual/server.domain.com). It must not contain any files. 6) Any domains that you want to use for email (eg: domain.com) must be in both the /etc/virtual/domains file and...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and sometimes it won't. Escaping the ampersand with a backslash or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
When you use "equals" for multiple conditions, and if one of your conditions is (Company:equals:ABC), the response will contain records with ABC as well as ABC Inc in their Company fields. When you use "equals" with a single condition and search for a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
rows: SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9]') -- returns all rows where the student surname contains non-alphanumeric characters -- eg. O'Brien will be returned SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html
found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html
if you prefer. This may prevent you from taking full advantage of the website. Links to other websites Our website may contain links to other websites of interest. However, once you have used these links to leave our site, you should note that we do not...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: en-GB
-
should have been renamed). Save the SQL file, this is now unique to your website and this process. It does not contain usernames or passwords but has the real database names and all website content, so do not redistribute without taking security...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
and features found inside the room. Problem #1: More of an aesthetic problem than functional but when the room didn't contain equipment (or the admins had not added the equipment info on the system), it just showed the heading "Equipment". Iteration in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
A file which is available for download from your site, each version is its own file. - Project = A project or solution will contain all files and its versions for this particular project on one page. CHANGELOG v? (?) - Support for Joomla! FTP upload. -...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html
-- insert some empty rows to blank out later as separators (select from your existing table, needs to contain data to order by so that it's the last row of each day -- if grouping by day -- basically insert a row that when ordered will fit where the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
** ** Revision: v1.0 ** ** Description: Stored Procedure to return counts of records per staging database ** ** table that contains a specific value. ** ** NOTE: This script can be run separate to a stored procedure by ** ** declaring @p_Value and...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html
reasonable legal notices or author attributions in that material or in the Appropriate Legal Notices displayed by works containing it; or c) Prohibiting misrepresentation of the origin of that material, or requiring that modified versions of such...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Advanced Web Statistics (awstats) but this was so that you could have your own country lookup script. The Download Should contain the following: create_countriesipranges_table.sql: SQL to create a pre-populated table into a MySQL database....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
to rename multiple files using the command prompt and a bit of string manipulation. This example will rename files which contain the string " (Copy)" and replace it with nothing (so removes it). The challenge here is the space character and delimiting...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
key, this should be the JSON file that you generated at Google's developer console - service accounts section. It also contains the public key under the guise of a URL (x509 certificate) but we don't need it for this script. Note that the key should not...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
again, just compare on the workflow of the audit change. Something along the lines of: Add an Audit Change field: This will contain the code triggered when one of the fields is changed Add an eTag field: Will hold a 32 hexadecimal character string / a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF