Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 protect your rights with two steps: (1) assert copyright on the software, and (2) offer you this License giving you legal permission to copy, distribute and/or modify it. For the developers' and authors' protection, the GPL clearly explains that there...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://joellipman.com/articles/crm/zoho/zoho-crm-permission-denied-for-quote-conversion-mapping.html

02 September 2021 A really quick article for anyone experiencing the same issue: As a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing street 2 and shipping street 2 from the Account module to the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 name or trademarks without the express written consent of JoelLipman.com. Any unauthorized use terminates the permission or license granted by JoelLipman.com. You are granted a limited, revocable, and nonexclusive right to create a hyperlink to the home...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Privacy Policyhttps://joellipman.com/static-items/privacy-policy.html

30 May 2009 to safeguard and secure the information we collect online. How we use cookies A cookie is a small file which asks permission to be placed on your computer's hard drive. Once you agree, the file is added and the cookie helps analyse web traffic or lets...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: en-GB

DataJumble - Shuffling characters in a data valuehttps://joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again you need permission to create this function. Don't forget to GRANT permission to execute this function for whatever user/system account that will run...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Copyrighthttps://joellipman.com/static-items/copyright.html

30 May 2009 use, but only if you acknowledge the website as the source of the material You may not, except with our express written permission, distribute or commercially exploit the content. Nor may you transmit it or store it in any other website or other form of...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 this error as the problem was down to not having a "unattended user account" who could access the images. Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed....

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 THEN RAISE_APPLICATION_ERROR (-20001, p_STUDENT_ADNAME || ':$:' || SQLERRM, TRUE); END sp_get_studentdetails_from_ad; Permissions on this SP Might need to give permission for your SSRS user (specified credentials in data source) to run this stored...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Split a row into multiple rows based on a column valuehttps://joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 002 1.00 2000-02-20 003 1.00 1999-02-25 003 1.00 1999-02-26 Some thing(s) to consider: User running the SQL query needs permission to read the master database. If run by a service account, ask a DBA to emulate the user for testing. the Items column may...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 number for each of these as a response. Failing this you should check your security and privacy and ensure that you have permission to install the above, then re-install. Install the Zoho Extension Toolkit (ZET) via command line interface (CLI) In the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 help as some of the options should be selectable. Two separate fields weren't quite right either: 1 as read-only (permission only to higher level) and 1 picklist as selectable means that the first-line agent would be referring to 2 status fields and not...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 code snippet to get the item record from the price book Note that I'm using a connection called "zbooks" and it has every permission under the sun (the naughty ZohoBooks.fullaccess.all) but according to documentation (to be taken with a grain of salt),...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *