Assuming name is required, the following 275 results were found.
-
on each iteration so as to avoid session timeouts and memory issues. Edit the script, renaming the database and table names used (DO NOT CONFUSE THE FOLLOWING DATABASE NAMES OR YOU WILL END UP WITH NEITHER SITE WORKING!!!) Open the SQL file in your...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
does a little more of the work, requires in the following query for you to replace the terms "myDB1" with the first database name and "myDB2" with the name of the second database to compare to: -- columns in old database but not in new SELECT t1.* FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
respective database tables are prefixed with "v25_" and "v34_". So an example MySQL statement will be: `v25_db`.`v25_tablename` -- with the database name and table prefix of database you are READING from (eg....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
replicating a tax list copy from Xero to Zoho the Client doesn't use the Items module in Xero and instead puts the product name in the description field How? Because my head is a little fried, I'm putting the two functions I used here and I'll document...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing in the last name field and creating a contact called "Firstname...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// Create a new query object. $query = $db->getQuery(true); // build the SQL query $query->select($db->quoteName(array('p.user_id', 'u.username', 'u.real_name'))); $query->from($db->quoteName('#__user_profiles p')); $query->join('INNER',...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
so here's the pull of the first page of invoices by most recent first (invoice date). There is also a table that returns the name of tax rates and then the percent that these equate to which I've copied below this invoices pull function. the Code string...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
links for a more in-depth description of each item. HTML DOM, JavaScript, COM, Methods, document, value, element, form, name, ID, Input, Tag, selectedIndex, checked, innerText, innerHTML Methods - The following Methods will be used throughout this...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
a Sales Order in Books and the documentation leaves certain bits out. Just getting the syntax right and using the . setParamName is key. Let's make it even more interesting: I'm going to use a subform with the file upload field type so our record can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Date", po."Purchase Order Number" AS "PO Ref", poi."Product ID" AS "PO Product ID", poi."Item ID" AS "PO Item ID", poi."Item Name" AS "PO Item Name", poi."Item Price (BCY)" AS "PO Item Price", poi."FCY Tax Amount" / if(poi."Quantity" = 0, 1,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
it is, was not visible in API... How? So we created a custom module called "Candidates x JobOpenings" (with alternative API name as "CustomModule6"). Just to add to the complexity of the task, the client has their own reference for Candidates which they...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
DECLARE @mySearchString varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column1 FROM ' + (TABLE_SCHEMA + '.' + TABLE_NAME) + ' WHERE SOUNDEX(' + COLUMN_NAME +...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
itself but more importantly is the enctype="multipart/form-data" without which your file upload processing won't work. The name of the file is important but you can call it what you want, in my case I've called it 'uploaded_file'. 2. Check that the...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
client library) and is a function sending two requests, the second is the appropriate multipart function which uploads and names the file in a single request, and the third is a 'nice-to-have' upload to the specified folder. Method #1: two requests 1....
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
At time of print, Zoho had recently introduced the ability to have custom fields in your line items, alongside the product name, list price, quantity, tax, etc. In the example below, we have added a column called "Group Name" in the CRM Quote module as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
locking it down for security: Login to ZohoCRM > Setup > Developer Space > Connections > Zoho OAuth Give your connection a name, I'm calling mine "Joels Connector" Select the Scopes: ZohoWriter.documentEditor.ALL and ZohoWriter.Merge.ALL For good...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
be keys later on to link my report to so keep them short without any special characters. I then saved this table with the name "Joels Image Library". I think I closed it and reopened it but now I want a 2nd column. So I click on the "Add" button and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if(!isNull(r_Contact) && !isNull(r_Contact.get("Email"))) { v_RecipientEmail = r_Contact.get("Email"); v_RecipientFullName = r_Contact.get("Full_Name"); // _ m_Parameters = Map(); m_Data = Map(); m_Templates = Map(); m_Actions = Map(); m_FieldData =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
action called "Add_Tags". I'm going to get the tags of the contact record using an invokeurl because shortcode only gives me name and ID; but I want the color code field as well which I only seem to get with an InvokeURL. I'm then going to create a list...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF