Assuming given is required, the following 76 results were found.
-
are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a date, the date format was reverting to US format as opposed to European Given a Campus as a text value, the SQL query was ignoring...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
from source after copying). /MOVE :: MOVE files AND dirs (delete from source after copying). /A+:[RASHCNET] :: add the given Attributes to copied files. /A-:[RASHCNET] :: remove the given Attributes from copied files. /CREATE :: CREATE directory tree...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
alert user if no email was specified) v_OutputMessage = ""; v_TemplateID = "123456789012345678"; // // get the quote details given a record ID r_QuoteDetails = zoho.crm.getRecordById("Quotes",p_QuoteID); // // check target email is not null/blank...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to eBay Listings. Getting the Orders in XML format: /* Function: fn_eBay_GetOrders() Purpose: Queries eBay for all orders given a from and till date Date Created: 2023-02-28 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
date; DECLARE @TimeVal time; DECLARE @DateMatch int; DECLARE @TimeMatch int; DECLARE @ColumnTypeIsDate int; -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
DECLARE @TimeMatch int; DECLARE @ColumnTypeIsDate int; DECLARE @IntOptions int; DECLARE @CharOptions varchar(max); -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
I was asked "... how do you find out where the positions are, like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after your website URL:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Just a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
a 3 or 6 character hexadecimal color and returns the RGB values for you. How? Very quickly, we take each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to run the unmodified Program. The output from running a covered work is covered by this License only if the output, given its content, constitutes a covered work. This License acknowledges your rights of fair use or other equivalent, as provided by...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
workflow that runs exactly 4 days after the lead creation time and assigns it to the specified user (full name of user was given in the brief but removed here for privacy). Finally, we delete any of these tasks when they get transferred to the contact...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
12 steps of 30 is 40% progress eg. ($8 / $10) * 100 = 80% ie. $8 of $10 is 80% To determine the percent (adjustment level) given the RRP and the price you're selling at: ((Agreed Price - Usual Price) * 100) / Usual Price = % eg. ($10 - $8) * 100 / $8 =...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
= Cursor ) { CursorHandle := DllCall( "LoadCursor", Uint,0, Int,CursorID ) Break } } If CursorHandle = ; invalid cursor name given { Msgbox,, SetCursor, Error: Invalid cursor name CursorHandle = Error } } Else If FileExist( Cursor ) { SplitPath,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
"eTag_Title", check if the new MD5 is different, if it is then I proceed with the automations otherwise I stop it. // get given eTag v_eTag = zoho.encryption.md5(input.Title.trim()); // // now compare to stored eTag if(v_eTag != input.eTag_Title) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
to convert this into a latitude and longitude, then we're going to use a free TimeZone API (one that returns a timezone given a lat/lng). The added feature is that we are going to loop through picklist options (500 timezones) in CRM to select the most...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
accept the previous solution. I wanted to use a regex rather than treat the number as a string and truncate it that way. Given the possible options of numbers given, it has to work with every number so here's both in Zoho Deluge Tryout: v_Rate =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
tabs. Then we'll make an OAuth function that can be executed by the client script which returns the value of the Pipeline given a deal record ID. Finally, we'll have client script execute this function, then show/hide tabs based on the value. Assuming I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
crmAPIRequest) Label: Fn - Accounts - Get Credit Safe Details Trigger: On-Demand / Widget Purpose: Given an account ID returns the credit safe details from CreditSafe Connect API. This function is used by a JS Widget. Inputs: string crmAPIRequest...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
query... Well it's for the radar chart and what it does is group all the responses per page (per survey attempt) so that given a survey reference, it will give me the sums per page. SELECT i."Attempt ID" AS "Survey Response", max(i."Survey") AS...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *