What?
Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive.
Why?
Consider that I have the following creator table:
Product_Name Product_SKU ...
... eg. "Data not yet available". The final system (qlikview) was case-sensitive despite our server collation being case-insensitive.
Furthermore, we now have the task of finding all the variations of ...
... // get the value of the custom boolean/checkbox field "Extra Confidential"
var b_ContactConfidential = ZDK.Page.getField('Extra_Confidential').getValue();
// if this is a sensitive record, ...
... Zoho Apps are incredibly case-sensitive and consider some records containing people's names as duplicates, when actually they are the same entity but may have uppercased a letter in their name while the ...
... is a function returning a boolean. Returns false if a cell value has been formatted to a text type. Returns true if the cell value is a number AND the cell data type is numeric.
Search( is a case-insensitive ...
What?
This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...
... fix "&".
- Double-check that unicode characters work in exclusion list. (they do)- Date Uploaded: Mon, 8th Aug 2011 1.6.6 - Bug Fix: "Case-sensitive=No" now checks that word in different case is not ...
Applies to:
TravelPort Universal API
PHP 4 or 5
cURL
What?
An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...
... entity. (If your change spans different entities, just use the parent/root entity, usually STU)
XML is case sensitive so bear this in mind, tick the "Valid for Export" and decide whether blanks are ...
What?
So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...
... Exception(e.ToString());
}
}
}
}
Allowing me to simply tick columns to apply this to (note that some of the images have been censored due to this project containing sensitive ...
... to enter the verification code and proceed with resetting your password.\n\n %s \n\nThank you.”
Check that email addresses match (case-sensitive!!!):
Login to your Joomla Admin Panel
Navigate ...
What?
Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the ...
Why?
Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite ...
Applies to Joomla 1.6+
What?
This is an article to describe how to add an article modal button in the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important ...
... sensitive data.
How?
SELECT DBMS_RANDOM.option1[(option2)] FROM DUAL;
option1 can be:
RANDOM
VALUE
STRING
option2 can be:
U (for Uppercase)
L (for Lowercase)
A (for AlphaNumeric) ...
... DataJumble as opposed to my article on Data-Scrambling.
Why?
We want to scramble sensitive data that we send to suppliers for support or analysis. With inspiration from: "Obfuscating your SQL Server ...
Are you getting a lot of spam, or junk messages sent via your Joomla site?
I know certain components of Joomla let you put banned words but I know of even more that don't. If you find all your forms ...
... Important Note: On Linux (Apache), all file names and folder names are case-sensitive, so phpbb3 is NOT the same as phpBB3. Bear this in mind during the installation process.
Before we begin: ...
I've been told of two ways of running a downloaded .RUN file.
Note: Bear in mind that the following is all case-sensitive.
Through the terminal server
Download the .RUN file to your desktop ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.