Assuming function is required, the following 184 results were found.
-
I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Anything that still needs addressing?) System Requirements (in case you need to transfer/move to another server) Critical functions used in the system? (do this yourself anyway and use theirs as a guide only) Site Authentication Method(s) (will this...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of each line. function clean_cron_lines() { while read line ; do echo "${line}" | egrep --invert-match '^($|\s*#|\s*[[:alnum:]_]+=)' | sed...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) {...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and basic Oracle...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
FolderCount := ItemCount - FileCount TotalFileCount += FileCount TotalFolderCount += FolderCount } Method #3: Standard Function with Loop -- input parameters: -- -- Folder=folder/file pattern. -- -- Subfolders=1 or 0 (recurse into subfolders or not)...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
No direct access to this file defined('_JEXEC') or die; // com_XXX is your component name class com_XXXInstallerScript { function postflight($type, $parent) { // $type (install, update or discover_install) if ($type == 'install') { $db =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
for ReCaptcha: 1. Open the file: /plugins/captcha/recaptcha/recaptcha.php 2. Find the following string in the OnDisplay function: return ' '; 3. and replace with: // Replace YOUR_KEY with your public key return ' window.onload = function() {...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
values my_records.sort(); Iterate through and output these in HTML for(i=0;i y ? 1 : 0; }); // use built-in JSON stringify function newSortedArrayObject = JSON.stringify(my_records_copy); // note: will convert single apostrophes to double-quotes //...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
(enable these during testing - malformed XML but more info) curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1 ); // curl_exec function will show the response directly on the page (if set to 0 curl_exec function will return the result) curl_setopt($ch,...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
JS then takes over and runs the time var seconds_remaining = ; var seconds_elapsed = ; setInterval('showTime()', 1000); function showTime(){ seconds_remaining--; seconds_elapsed++; if(seconds_remaining>=0){...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
in column B of Sheet1 is as follows: =SUMPRODUCT(--ISNUMBER(SEARCH(Sheet2!$A$1:$A$4,Sheet1!A1)))>0 Where: SumProduct( is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
this and can still be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)];... Lastly, there is a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
invokeurl [ url :v_DataEndpoint type :PUT parameters:m_CreateRecord headers:m_Header ]; Problem: Value is empty and 'get' function cannot be applied Following a post similar to the above example by InvokeURL and then getting a JSON response back, the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
You can then use the following snippet to get all the fields for the module. In our case, for "Invoices": /* Function: fn_Button_CloneInvoice Purpose: This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
article as I couldn't find anything on the WWW to document this error. Why? During a data migration, I was using a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a subform with a product...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Zoho Deluge to look at Zoho Books. This uses up an extra 2 calls so you could run them once, store them as a map on your function if you don't want to use up these 2 every time your sales team push a CRM Sales Order to Zoho Books. Or leave as 2 calls at...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
It should be auto-populated... How? As mentioned, we're going to use the address on the Lead record; use Zoho's GeoCode function to convert this into a latitude and longitude, then we're going to use a free TimeZone API (one that returns a timezone...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get the XML of a GetItemTransactions request to eBay. How? You'll need...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
such as zoho.encryption.htmldecode(string). But at time of print, it doesn't exist and in the meantime, I've made a function that does this. How? Not sure how else to do this but I simply wrote a function in Zoho Creator for each instance that I knew a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF