What?
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook).
How?
So for demonstration ...
What?
A quick article for Joomla CMS version 3.x on resolving a menu item alias conflict:
Warning
Save failed with the following error. Another menu item has the same alias in Root. Root is ...
What?
A quick article on how to populate a database column from another table using a string comparison.
Why?
I have several database tables which replicate country names and I would rather they ...
What?
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...
What?
Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article ...
... like. I like queries against this database because it involves linking a lot of tables and outputting... just articles and their titles.
I have another table holding the audit trail of content approvers ...
Typing an ASCII character
In DOS:
Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178)
In Windows for a DOS character:
Hold ...
Old Server
mysqldump -u root -p wikidb > wikidb.sql
tar -cvf wiki.tar wiki ;this is the wiki folder on document root
New Server:
create database wikidb; this is inside mysql, Note that ...
... API to detect what webhooks exist, it can only detect what webhooks it initialized. If you added webhooks via another app or via the Shopify Admin interface, then the following code won't be able to check ...
... another key)
Zoho Deluge
Here's the code to retrieve all the product categories. We need this to get the count of all products (if there's another way, I'd love to hear it). We don't have more than ...
... HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers):
//
// Generate a CSV of a ...
... for more information. If your widget sits on an external server, it won't connect. I have tried publishing the Creator Widget page (doesn't work); then I have tried embedding the Widget page into another ...
... the photos don't display.
This is because the photos were just links in the Zoho Creator image field, links to another Zoho app that is behind a user wall (ie. login and password as a Zoho User).
...
... or Access
You should be in "My Folders" (left sidebar)
Create a folder, I'm calling mine "Email Signature Images"
Within that folder, create another folder called "_Global".
At the same level, create ...
... you use backslash as the last character in the value for a criteria, you must escape it using another backslash. Further, you must encode the value.
Example:
Consider the search term: (Last_Name:equals:K\)
After ...
What?
Another article on something I learned today despite never running into this issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks ...
What?
This is a very quick article on sending an email with Deluge which needs a dynamic number of files attached to it.
Why?
This came up during a call with another developer and it occurred ...
... t1
PIVOT
(
MAX(t1."Member Status")
FOR t1."Campaign Name" IN ( "Campaign 1","Campaign 2","Campaign 3" )
) t2
The bigger query:
Now create another query (better to refresh the page so ...
What?
Another one of these articles talking about getting all the active product listings from eBay for a specific client.
Why?
Our use-case scenario here is that we want to get an inventory ...
... given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... ...
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.