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 ...
... Color']
Add another single line field, I'm calling it "RGB Value" [Optional: not required for the functionality of this demo but used in later application when including CSS opacity]
Step 1: Cod ...
...
Repeat these steps to add another rule:
Call it "If Mobile Blank then Email Required"
Select the Mobile/Phone field as the primary field to control this rule
Set the condition that the ...
... the document. I know this exists in ZohoSign already but we don't expect staff to go to another app to check on this and would rather see it directly in ZohoCRM on the relevant record.
So the more ...
...
Pre-amble
Have all the images you want to use ready for uploading into the system stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section ...
... a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent to another supplier for grading, and then sent on to the end user/customer. ...
... but according to documentation (to be taken with a grain of salt), the scope should be ZohoInventory.settings.READ. I have another connection called "zinventory" which is used here to retrieve the item/product ...
... = User Acceptance Testing) to ensure this behaves as expected. So I found another function was being run when a contact record is created and I appended this snippet of code to the end of it. Note tha ...
... for a customer who simply wanted a quote template to be rendered for PDF or print format. I have another article for a different client who wants a pretty advanced HTML template (well it's a HTML table ...
... 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 ...
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.