Assuming contains is required, the following 61 results were found.
-
= m_Node.get("product").get("updatedAt"); v_VariantModified = m_Node.get("updatedAt"); // // transforms if(v_ProductTitle.contains(",")) { v_ProductTitle = "\"" + v_ProductTitle + "\""; } if(v_ProductHandle.contains(",")) { v_ProductHandle = "\"" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
text file to be sent to a bank and downloads it to the staff member's workstation. Why? Why is this a challenge? The file contains bank details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
public URL of a subform row other than making the subform link to an existing form and not a blank form. The document form contains the fields: Ticket (lookup to Ticket form), Image, File, Local Image, Subform Row ID (prevents duplicates). Note: I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= v_CssStyle; Code for On User Input of Color Picker: if(!isNull(input.Color_Picker) && !input.Color_Picker.contains("button")) { v_HeximalRef = input.Color_Picker.getsuffix("background-color:").getprefix(";"); input.Hexadecimal = v_HeximalRef; //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Extract the folder "Template Name" into this directory ^ If in the package the folder "lib" contains, extract the files in the directory \components\com_kunena\lib\
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html
that any products, services or information available through this website meet your specific requirements. This website contains material which is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look,...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
-- Step 2) Re-associate banner clients (in case J30 already includes new clients) -- - Re-associate if description contains migration notes UPDATE `my_new_database`.my_prefix_banners a INNER JOIN `my_old_database`.jos_bannerclient c ON a.cid=c.cid INNER...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html
= $00080000 ;// hidden Object Const SFGAO_DISPLAYATTRMASK = $000F0000 Const SFGAO_FILESYSANCESTOR = $10000000 ;// It contains file system folder Const SFGAO_FOLDER = $20000000 ;// It's a folder. Const SFGAO_FILESYSTEM = $40000000 ;// is a file system...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
same parameters) and another link which leads to our report containing the call to the Stored Procedure. This page itself contains a basic dataset query just to check with the end-user: Note that this an ordinary report as per usual. It will act as a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
my code How? Open a MS-DOS Command Prompt (Start > Run... > Type "COMMAND" > Enter) [Optional] Browse to the folder that contains the file (or use full path in path reference). This example assumes the file is in C drive (C:\). Create an empty text file...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
** ** 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
-
about the failure. All this blab actually means is that there is a chance one of your date values is BLANK, NULL or contains a non-numerical value in a number such as COMMA (,) and therefore the parsing (to extract year for example) will fail and stop...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
come as I'm really happy with what the above already improves! Download the above modified files. The following ZIP file contains the default Joomla v3.4.x core files and then a copy with my modifications above. I use this to quickly add the relevance...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
if required -- Method #1 count := 0 Loop, %UserFolder%\*.*, 0, 1 count++ -- note for future use: ; if A_LoopFileAttrib contains H,R,S ; continue This works fine at home on your local host on a local drive. Try using this over a networked drive and more...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which employee, on what date, and for how many days they were off sick. When migrating to a new system, the destination...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
ReCaptcha) Login to your Joomla Administration panel Extensions > Plug-in Manager > Captcha - ReCaptcha Check "Public Key" contains your key. STEP #3: Enable admin option dropdown This is a code change to allow the admin to select recaptcha. Open the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
name of your choice Under Collection, select as Enumerator the "Foreach File Enumerator" Select the source folder which contains all the files to loop through Specify the file name convention with wildcard to indicate which files (in this example...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
the decimal point to only 7 decimal places (for importing to a database where DECIMAL(10,7) ). Merging the lot If B1 contains the coordinates and there is a space after the first letter (N or S): // for latitude =IF(MID(B1,FIND("″",B1)+1, 1)="N",...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
yyyy"); info v_ContractDateFormatted; // yields Tuesday, 6th of November, 2018 Method #5: if a list contains: v_NextRenewalDate = '2018-11-06'; v_EnglishOrdinal = if("123".contains(v_NextRenewalDate.toString("dd").right(1)) &&...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF