Assuming value is required, the following 197 results were found.
-
m_CrmLineItemTax.put("name",ifnull(m_XeroLineItem.get("TaxType"),"NONE")); m_CrmLineItemTax.put("value",m_XeroLineItem.get("TaxAmount")); l_CrmLineItemTax.add(m_CrmLineItemTax); m_CrmLineItem.put("Line_Tax",l_CrmLineItemTax); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
based on the pull from invoices article I wrote earlier but with quotes from Xero, things panned out differently: Date/Time values don't include a timezone Issues with tax rates meant replicating a tax list copy from Xero to Zoho the Client doesn't use...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
you how to do this by title in ascending order without installing any 3rd-party extension as well as by any of the database values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their solution...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
alias (eg. for "about" give it the alias "about_new") Login to your database and browse to the #__menu table Search for any values in the `alias` column that match the term (eg. for "about" do SELECT * FROM #__menu WHERE alias LIKE '%about%' where #_ is...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Backup the database in LIVE environment Clear the database in DEV Copy database from LIVE to DEV Change database values: Navigate to wp_options table and change the two values where `option_name`='siteurl' change `option_value` // from www.myexample.com...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
the name of your field containing the location of the image - ours is "PhotoURL"): =" The file " & First(Fields!PhotoURL.Value, "PhotoDetails") & IIF(Code.ImageExists(First(Fields!PhotoURL.Value, "PhotoDetails")), " exists!", " does NOT exist.")...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
DECLARE done INT DEFAULT 0; DECLARE COUNTER INT; DECLARE table_cur CURSOR FOR SELECT concat('SELECT COUNT(*) INTO @CNT_VALUE FROM `',table_schema,'`.`',table_name,'` WHERE `', column_name,'` REGEXP "',in_search,'"') ,table_schema,table_name,column_name...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
the font color of days that are in the given month (where "Gainsboro" is a type of light grey): =IIf(Month(First(Fields!Date.Value))=Month(Parameters!GivenDate.Value), "Black", "Gainsboro") Right-click on the Date textbox and select Font then for color,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data Not Yet Available". Unfortunately the end-user reported these default values sometimes list...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
working on my computer (except for TNSPING). TNS_ADMIN is another environment variable used that we must maintain (current value at "C:\app\\product\11.2.0\client_1\bin") Setting environment variables using the Command prompt (DOS) wouldn't stick...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Update server added (for when Joomla supports this) - Date Uploaded: Wed, 15th Jan 2014 3.0 - Enhancement: Hardcoded DS value for Joomla 3.x compatibility. - Date Uploaded: Mon, 16th Sep 2013 2.2 - Enhancement: Parameter: If viewing an article, scan...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
arrows). So right-click on a heading text box that works Select "Size and Position..." Copy to clipboard the exact height value Right-click on a faulty heading textbox Select "Size and Position..." Paste the same height value as the one that worked...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal to RGB: HEX2RGB(HEXString,Delimiter="") { If Delimiter= Delimiter=, StringMid,R,HexString,1,2...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
in the context menu Left-click on Properties Add the word -incognito (including the hyphen/dash) to the end of the Target value Ok that and see if it works Note that if in point 4, if there are any spaces in that value, you should add a double-quote...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
if statement: If (MyFieldName = 0) Then Return 1 Else Return MyFieldName Can be expressed as: IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value)
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
expression as well (I embed these and then refer to them in the expression by name). For example: =IIF(Fields!SummaryStatus.Value="Success", "status_ok", IIF(Fields!SummaryStatus.Value="Unknown", "status_unknown", "status_fail"))
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Run > Regedit > OK Browse to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Create New DWORD Value Name it "MaxRecentDocs" Double-click on the new DWORD Set value data to "19" ( equals 25 ) Leave Base as "Hexadecimal" OK...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
as "tablename.columnname") that had the data_type TEXT across all databases: SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS value FROM information_schema.COLUMNS WHERE DATA_TYPE='text' ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
%Format% return Formattedtime } The following function is to convert a given SQL date or a European date formatted value: FormatDate(val) { ; SQL format (yyyy-mm-dd HH:mm:ss) IfInString, val, - { StringReplace, val, val, -,,All StringReplace, val, val,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
else unless they work for the same company and they're leaving on the same date at the same time. Amend the "FinalDate" value to when you leave, compile the code into an executable, and schedule it as a windows task for when you are logged in: ; ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *