Assuming same is required, the following 183 results were found.
-
bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging to the same school and updates some number fields on the matched CRM account. Why? For reporting purposes. Although Zoho Analytics can use data...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth and Zoho is the data to be overwritten, ensuring that Product...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the OAuth access codes from the client. How? I'm going to split this into 2 code snippets that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only available in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= Document[ID == v_ZC_DocumentRecordID]; info c_ExistingDocument.Document_File; I have all of the above in the same function. I've split it out to explain parts but otherwise it is intended to be all in the same function as there are references to some...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Note that this one is not the "Inventory Item Update" as I get the two muddled up very often and they don't do the same thing. We want this triggered whenever the stock level of a product changes. /*...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
tag present with different colour already.","status":"error"} -> Error was due to someone already giving tags with the same name -> Solution is to remove the color_code key as well... m_Tag.remove("color_code"); */ Considering that neither the color...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
'.$sql_keyword.',\'\'))) / LENGTH('.$sql_keyword.'))) AS relevance '); « Show Me » [Same file again and optional if your search opts to search archived articles] \plugins\search\content\content.php: Insert this between the if ($sArchived && $limit > 0){...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
(and all tabs) once done or this cookie will remain on the computer and will be readable by other users who access the same computer (this is irrespective of whether you have logged out of the CMS). Add an IP filter To include this method, ensure you...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
the activity or layout) and click on Finish: Get yourself a developers' Google Android Maps API Key (not necessarily the same as Google API Key) and enter it as instructed: Change the Java file to open on your current location, find the...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
understand how it works only that it does. I think this could get complicated if you had two dropdowns reading off the same list but needed to list elements in different orders. If you haven't made a dropdown list yet There's other instructions out...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
has to be generic, it should only apply this to columns we specifically tick in a package and we should be able to use the same script in any package... eek! Either of the two following script examples can be included in an SSIS Script Task but this...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
hopefully make all rooms (even empty ones) display. Note the second select statement (to list all the rooms) has to have the same number of fields as the first statement. This is the final script for the events table (DO NOT USE THE BELOW: this works...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
not because "fields cannot be used in report parameter expressions". I tried this with "Default values" and got the same problems. Note: before you try, "Variable values cannot be used in report parameter expressions" either. I'm using an Oracle/PLSQL...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
field1, field2, TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS ReportStartTime FROM... Then add another dataset (using the same data source if you like): -- Oracle 10g: DataSet2 -- a quick dataset following the first (started before the first ends? hope...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
so that you can define the query parameters. 4c. Add a dataset: the "Parameter Names" Under "Parameter Name" type the exact same name for the input variable used in your Oracle stored procedure (in my example: p_STUDENT_ADNAME). Under "Parameter Value"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
+ '/01/2009 01:30:00 PM', Note = 'Event 6' ) SELECT -- Number the records based on the date, if multiple records have -- the same date then they will be numbered the same. Used in -- calculation to determine row record is to display on. [Order] =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
(T-SQL) What? This is a quick article on how to split a single row into multipe rows based 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,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty result set. Furthermore I am using this stored procedure in...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of data. Why? The joy of working with the plethora of applications out there result in me using...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB