Assuming names is required, the following 57 results were found.
-
// field mapping of quoted items to invoiced items (i console logged out the quote record and used the API names of the invoiced items) // declare new array to store line items for invoice var a_InvoiceLineItems = []; // loop through quoted line items...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
and Times to include timezone of Xero instance for accurate time comparisons - Map Xero tax rates to Zoho tax rates (same names in Zoho) - output to console if debug mode enabled More Information:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
website (at time of print: Jcomments v2.3.0 on Joomla v2.5.4) Copy the below script to a text file Change the database names to match your setup Change the table name prefixes to match your setup Run the modified SQL script against your database. Note:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
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
-
and often return it as "AcademicWeek"). Other Search(es) Format a column alias with new line Using carriage return in column names New line Character in column alias
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
next to public and db_datareader. Confirm by clicking OK. You should get something like the following: Database-level role names from http://msdn.microsoft.com/en-us/library/ms189121(SQL.100).aspx db_accessadmin Members of the db_accessadmin fixed...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
to use DECLARE @SqlToExecute varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid table names) DECLARE Cursor1 CURSOR FOR SELECT TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
16/10/2011 A009 08:00 17:00 Separator Marker */ As I mentioned at the beginning of this article, I am comparing on Day names. The above query generates a last column which is either empty or says "Separator Marker". Based on the CTE above, I now need to...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
my laziness (replace [myDB1] with name of database 1 and [myDB2] with name of database 2): -- Joins on table and column names, lists diffences if any SELECT t1.TABLE_CATALOG AS [DB1_Name], t2.TABLE_CATALOG AS [DB2_Name], CASE WHEN t1.TABLE_NAME IS NULL...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
to return unknown nodes from XML column - Event_XML SELECT Event_XML.query('//* ') FROM [dbo].[XML_EVENTS] Parent/Child Node Names -- to get name of parent node -- returns STAFF SELECT ( SELECT c.value('local-name(.)', 'nvarchar(50)') FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
site and its design is property of SomeoneElse.com Obviously the two above tables are very similar with different column names. I also don't want the data to produce double the number of columns. My Solution SELECT title, intro FROM ( SELECT `title`,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other countries. This is nice but its search engine doesn't work properly as it thinks "riviere" is different...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Registration Services (for .co.uk, org.uk, .net.uk, etc): http://www.123-reg.co.uk/ http://www.oneandone.co.uk/ http://www.names.co.uk/ http://www.ukreg.com/ International Domain Registration Services (for .com, .net, .org, etc) - Note you can use the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
and select "Move to Report Filter") Advanced Sorting So the above works which is great but what if you have a list of month names? January comes before February but not alphabetically, so let's do this as an example: Move the field from "Report Filter"...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B -------------------------------------...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design interface of Report Builder 2.0 for the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 all use the ccTLD two letter code. This article was written because it took me so long to work it...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB