Assuming value is required, the following 199 results were found.
-
each v_Field in m_ThisGoal.keys() { m_OutputRecord.put(v_Field, m_ThisGoal.get(v_Field)); //info "Field: " + v_Field + " || Value: " + m_ThisGoal.get(v_Field); } m_OutputAll.put(v_GoalKey, m_OutputRecord); } } // // for testing I'm doing 3 records at a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
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