Assuming correct is required, the following 46 results were found.
-
the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results: SELECT DISTINCT StudentDetail COLLATE Latin1_General_CS_AS FROM StudentTable WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
DnYa ** ** Row2: RegionCode DnYa ** ** -> Only Row1 will display in column source as this is first alphabetically. ** ** Correct the value for EthnicCode and re-run the code. ** ** ** ** Link to other SQL Server collations:...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
good, doesn't it? The advantages of this is that you can send this data to your developers and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
up the wrong tree. If I padded with one more zero so that "008" is before "010": Great! The columns are displayed in the correct order but who's ever seen a date written as the 008th of April? What if we didn't use parentheses? Then it wouldn't be...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
(dd/mm/yyyy)? See the following: -- assuming value of DATE_OF_BIRTH is blank or null yields // -- errors How? I could correct this using SSIS but with all the data in XML, we might as well stick with the technology and we're going to keep our XSLT with...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
your weblink categories: -- Adding the weblinks using the Joomla admin interface and then -- updating the database with the correct IDs is easier than the script. -- Use this if there aren't many to do. In this example, I am applying -- this to the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
know how), I'm going to call mine myZohoConnector, with the scope: ZohoCRM.settings.fields.READ Then check your URL is correct. The format for API v2 is: https://www.zohoapis.{eu or com}/crm/v2/settings/fields?module={module-name} You can then use the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to perform this operation"}: If you connect via a Zoho OAuth connection, check that the portal (Top Level Domain: TLD) is correct [EU for Europe // COM for USA] so books.zoho.eu for Europe and books.zoho.com for US. {"code":2,"message":"The request...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Zoho Books. Why? The use-case here is that we are creating a Sales Order in Zoho Books from Zoho CRM and want to map the correct currency and tax by their ID numbers. How? Using the REST API and InvokeURL in Zoho Deluge to look at Zoho Books. This uses...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
data","status":"error"} correct Call_Start_Time to CRM format of yyyy-MM-ddTHH:mm:ss-05:00 or have you mapped the field twice? {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"Call_Type","json_path":"$.data[0].Call_Type"},"message":"Empty Call...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ v_CustomerTimeZone = r_TimeZone.get("display_value"); break; } } } } } } // // if not blank then we found the correct timezone picklist option if(v_CustomerTimeZone != "") { m_UpdateLead.put("Customer_s_Timezone",v_CustomerTimeZone); } // // if not...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to search by product SKU. The new version, taking advantage of GraphQL, will be able to search by SKU and retrieve the correct product ID, variant ID, and inventory ID from Shopify. How? The below details on how we set up an access token in Shopify...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
again. How? This largely depends on whether you are using the Google Chrome web browser. In this case version 100 and is correct at time of print. Open Chrome Web Browser Click on the vertical ellipsis/3 dots icon int the top right Click on “Settings”...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
import files associated to CRM Contact records. There's first the preparation of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
scope. Error(s) Encountered: {"code":"4401","message":"Unable to populate data, please check if mandatory value is entered correctly."}: Check your connection string. {"code":"9832","message":"Mandatory parameter(s) missing"}: Not sure why as the only...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
MidJourney AI text-2-image discord tool. Why? The results from the MidJourney bot are beyond unpredictable however with the correct prompts you can direct it to focus on the elements you want from a brief. How? A "prompt" is a text-to-image expression...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
approved 00 Payment Approved 01 Payment Declined // call issuer code 05 Payment Declined Generic 55 Payment Declined Incorrect Pin 65 Payment Declined withdrawal_count_limit_exceeded 75 Pin try exceeded...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if(m_OrgDetails.get("business_days") != null) { // // let's format a little as the business days are given in the correct order m_ShiftRow = Map(); m_ShiftRow.put("open","00:00"); m_ShiftRow.put("close","00:00"); m_ShiftBuildUp = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_Blank, "my_creator_connection"); // // FAILS: with r_Create = {"code":2945,"description":"EXTRA_KEY_FOUND_IN_JSON"} The correct code // initialize m_QuoteRecord = Map(); // // build quote request m_SellerName = Map(); m_SellerName.put("first_name",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
up the fields, we'll then use a client script to automatically read the user's record, retrieve the department, and set the correct pipeline option. Setup: Department Field on User Profile Login to ZohoCRM as a system administrator > Go to Setup > Users...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF