What?
This is an article to document how to output the most frequently used words in a MySQL database column.
How?
Note this only applies to MySQL.
So the following query will return a count ...
What?
A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine ...
What?
A quick article just as a note to get the users country information from a third-party API based on the given IP address.
How?
Well this is just a list of free 3rd-party APIs and the below ...
What?
This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive.
This is ...
... statement.
Why?
The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it.
How?
Method #1: Add ...
Applies to:
Microsoft Windows 7 Enterprise
AutoHotkey (see code for AHK version)
What?
Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better ...
... allocated country. Our use here was to create a refreshable country by IP address list that we can use when parsing our website logs to check where visitors were from.
Note: we also use and love ...
What?
We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called ...
... columns.
How?
IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL
DROP PROCEDURE [usp_ListDistinctValuesAndCounts];
GO
CREATE PROCEDURE [usp_ListDistinctValuesAndCounts]
(
...
I added this article because when I was only trying to look up how to do this, this nut "the Storyteller" went and carried out a benchmark test on the most popular ways of counting the occurrence ...
What?
Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page.
Why?
Cos
How?
The below is a template ...
... the Add button below it
Link it if applicable to your super admin account
Create an app, a form and publish it in Zoho Creator
Create an app by clicking on Create App
then go into the app and ...
... up to 2, right through 3 to 1, then down to 5... Now it all blends together:
Error(s) Encountered:
DisplayPort to DVI cable doesn't work: I get what I pay for I guess... I went for a slightly more expensive ...
... Admin API scopes": This will be dependent on what your app needs to do. In this example, mine needs to sync orders, products, customers, and some reports; the other things like discounts, fulfillment ...
... loop through all pages
for each v_Page in l_Pages
{
r_SearchResults = zoho.crm.getRecords("Accounts",v_Page, v_PerPage, m_SortCriteria);
// loop through all results per page
for each r_Result i ...
... Deluge - Some Useful Regular Expressions list but I felt this deserved its own article.
Why?
A client wanted the discount displayed on a template and if they gave 10% discount, it would display ...
... the header section) but then they changed address and couldn't change the template. So they had something like:
$
$
$
$
$
11 My Street, My City, My State, My Zip, My Country
They wanted to get ...
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.