MS Excel: Convert a text to a numberhttp://mail.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 how to copy into a column just the number? Even if I tell it to multiply by 1, Microsoft Excel gets confused and reports an error?!?!?!? The answer on the Microsoft website is as helpful as the Microsoft paperclip, in other words, not worth the time or...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

SSRS Display question mark when date is blankhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 11:21:32 Sounds good, where's the problem? The problem Putting the date in an IIF (if-then-else) statement displays "#Error". You should get errors referring to converting strings to dates and incorrect data types. How? The fix is to simply get the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSIS: Add Reference Microsoft.SqlServer.TxScripthttp://mail.joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

03 June 2014 Select the dll and click on "Add" Related Error(s): The type or namespace name 'SSISScriptComponentEntryPointAttribute' does not exist in the namespace 'Microsoft.SqlServer.Dts.Pipeline'

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html

09 June 2014 I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer Why? We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

SELECT COUNT(DISTINCT name) FROM tablehttp://mail.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

MySQL Transactions in PHPhttp://mail.joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

14 December 2016 'user' = 'Fred'"); What if one of the queries fails? To mitigate the chances of misplacing our millions due to some possible error we must ensure that both queries are executed with the expected result before committing any changes to the data. This...

• Type: Article
• Author: Ike Francis
• Category: MySQL
• Language: en-GB

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 elements, even if you are using Creator v5, use removeElement() and NOT remove() which got me stuck for a while. This is for error...datatype {0} is not the same as list datatype {1}...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge: Push a value to a datetime field in CRMhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

10 September 2021 A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *