Zoho CRM: Remove Duplicate Product Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 ifnull(r_CoqlMatchedProducts.get("data"),List()); for each m_Result in l_MatchedProducts { // ensure we are looping through results and not a search error if(!isNull(m_Result.get("id"))) { v_CountTotal = v_CountTotal + 1; // // keep the first one in...

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

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

24 September 2015 field: -- Note the alias for the field SELECT COUNT( DISTINCT `my_field`) AS myCount FROM my_table; Method #2: Count from results (my preference): -- Note the alias for the table (select results) SELECT COUNT(t1.my_field) FROM (SELECT DISTINCT my_field...

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

Zoho Deluge - MD5 functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention of using MD5 in an encryption task. Why? I'm trying to create an ETag for a synchronization process...

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

Zoho Creator: isBlank and isNull: Before or After?http://mail.joellipman.com/articles/crm/zoho/zoho-creator-isblank-and-isnull-before-or-after.html

10 February 2025 is TRUE isNull Succeeding is TRUE Equals Blank is FALSE */ I've tried this in both Zoho Creator and Zoho CRM with the same results. I don't code with the method appended at the end of the variable but in more complex method chaining, I can see myself...

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

Forum Ruleshttp://mail.joellipman.com/static-items/forum-rules.html

31 May 2009 will apply (first time, second time, third time...) with the exception of breaking the rule "No Hacking" which immediately results in a permanent ban: Warning - Depending on how serious a violation is, you may be issued a warning first Muting - Muting...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Running Internet Explorer 6, 7, 8 as standaloneshttp://mail.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 Sandbox (Need IE and install their plugin - does not reflect my customer's PC image) IETester v0.4.3 (Returned different results from my IE7 tests) ie6olas_nt (from http://browsers.evolt.org - works but installing IE8 breaks it) ie6setup.exe (from...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Crystal Reports: Exporting to Excel omits column headershttp://mail.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One solution was to untick "Simplify page headers" on the Excel Format Options when you export the report. Because our...

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

MySQL: Find records in one table that are not in another.http://mail.joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 FROM MyTable1 LEFT OUTER JOIN MyTable2 ON (MyTable1.PageID= MyTable2.ArticleID) WHERE MyTable2.ArticleID IS NULL Results STATEMENT1 880 rows 0.187s STATEMENT2 741 rows 49.933s STATEMENT3 741 rows 48.844s STATEMENT4 741 rows 49.603s And Vice-Versa? Well...

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

Developer's Checklist: Taking over a projecthttp://mail.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 can it be circumvented?) Website Revamp? Signed Off Specification (describing clearly the agreed work to do and expected results) Realistic Cost & Time (obviously agreed with client) Additional Documentation (timesheets, agreements, technical...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Basic Webpage Controls with JavaScript / COMhttp://mail.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 its 1st elements name being search_keywords. The following javascript fed throught the address bar would produce the same results: Code: javascript: alert(document.SearchForm.search_keywords.value) MsgBox % pwb.document.SearchForm.search_keywords.value...

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

SSRS Querying on either of 2 Parametershttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 still works but when I type a Username ("@StudentADAccount"), it populates only the first dataset with results; the remaining datasets that need to use the ID parameter all returned zero rows. So one workaround exists where if I combined all 10 dataset...

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

Before and After, Highs and Lowshttp://mail.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

SSRS Redirect after a report is runhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically. How? So there are various solutions...

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

Copy a table with structure and data into a temporary tablehttp://mail.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 -- Drop dummy column from table declaration ALTER TABLE #myScrambledTable DROP COLUMN dummyIndex; -- Show me the results SELECT * FROM #myScrambledTable; END GO -- Usage: -- EXECUTE dbo.usp_MakeTableTemp 'mySchema.myTable'; Post-Notes Added a dummy...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Connect to Joomla database in standalone scripthttp://mail.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 you have to use the $_GET, $_POST or $_SESSION methods. Or redeclare it after the above. MYSQLI_USE_RESULT allows these results to be used once, remove it if you need counts or to use the data later on. Further Post-Joomla 2.5 aides Validating a login...

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

T-SQL example of Case-Sensitive Soundexhttp://mail.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results: SELECT DISTINCT StudentDetail COLLATE Latin1_General_CS_AS FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not...

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

Stored Procedure to List Distinct Values and Countshttp://mail.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 FOR SELECT [Value] = T.c.value('.','varchar(max)') FROM @myXml.nodes('/root/s') T(c); -- Create temporary table to hold results CREATE TABLE #ListDistinctValuesAndCounts (myValue varchar(max), myColumn varchar(max), myCount int); -- Iterate through...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Search a database for a value and count matching rowshttp://mail.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 WHERE COLUMN_NAME = @p_Column ORDER BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME; -- Create temporary table to hold results CREATE TABLE #CountRecordsPerTablePerCol (myValue int, myTable varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1...

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

Licence GNU/GPLhttp://mail.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 substantially all assets of one, or subdividing an organization, or merging organizations. If propagation of a covered work results from an entity transaction, each party to that transaction who receives a copy of the work also receives whatever...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Things to Check if Joomla Password Reminder email not being senthttp://mail.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 without the quotes and tick the “Constant” radio box and click on the “Search” button. What displays in the search results should be the text that the system emails out on password change. The default if you’ve lost it is as below (exclude the...

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