Assuming return is required, the following 175 results were found.
-
HH:mm:ssXXX") message :"Please see the attached file" Attachments :file:f_AllProducts ] // return v_TotalProducts + " product(s) in " + v_TotalCategories + " categories across " + v_Page + " page(s)."; Additional: Total product count may differ from the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
build up related list rows l_RelatedListData = List(); for each m_DataRow in l_DataRows { // double-check in case books has returned 1st page rather than filtered rows if(m_DataRow.get("SO ID") == v_SalesOrderID) { m_Details = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to a new variable name, it will fail. In other words: m_NewTag = m_Tag.remove("id"); // yields null m_Tag.remove("id"); // returns m_Tag map without the ID key-value pair The use-case This is a snippet that gets the tags of a contact and copies it over...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Action."); } info v_Debug + l_DebugNotes.toString(". "); } if(l_UniqueProducts.size() == 0) { break; } } return "Deleted " + v_CountDeleted + " of " + v_CountTotal; }
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
will run when you resize the app. Syntax: GuiSize: GuiControl, MoveDraw, MainRedBackground, w%A_GuiWidth% h%A_GuiHeight% Return If I just used GuiControl, Move,... then this would be as above but if you are using images, then you will get problems with...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Search The function to receive the data can be: Search: Gui, Submit, NoHide MsgBox, Searching for "%SearchTextInput%" Return
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
MySQL Oracle equivalentshttps://www.joellipman.com/articles/database/mysql-oracle-equivalents.html
that I need in Oracle: Objective MySQL Oracle - See if a table exists SHOW TABLES Select table_name from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10 SELECT * FROM table1 WHERE ROWNUM
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
number_format($bytes / 1024, 2) . ' KB'; } elseif ($bytes > 1) { $bytes = $bytes . ' bytes'; } else { $bytes = '0 bytes'; } return $bytes; } Inline without a function Source: Joes Brain: http://www.joellipman.com if ($this_file_size >= 1073741824)...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
match the results above. The second formula is converting person days into hours and then dividing by 24 (which should return the same decimal number).
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
v1.1 | https://github.com/maaaaark/bcSwipe | MIT License */ !function(t){ t.fn.bcSwipe=function(e){ var n={threshold:50}; return e&&t.extend(n,e),this.each( function(){ function e(t){...
- Type: Article
- Author: Joel Lipman
- Category: Bootstrap
- Language: *
-
to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How? Well a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the forums you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) { return leftpad(toString(input.startingNumber), input.finalStringLength).replaceAll(" ", "0"); } This looks like pretty old code and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
During a site upgrade, the commenting extension for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF