Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 data appeared in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this count result...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 in row 1 (odd row numbers) and a very light grey (=#eeeeee) in row 2 (even row numbers). The first row being of all rows in the dataset and not for a particular drill-down item. It will alternate between the two for the rest of the report. [The second...

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

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

25 February 2011 wikimedia_text.old_text'' AND wikimedia_page.page_is_redirect=0 -- yields: let's call it MyTable1: Query time: 0.187s. 880 rows returned. PageID PageTitle PageContent ---------------- ------------------ --------------------- 1144 7911_and_7912_t......

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

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 ORDER BY Score DESC LIMIT 0, ".$maximum_number_of_results_from_db; $terms_rx = search_rx_escape_terms($terms); $results_rows = array(); $result = mysql_query($filter_sql); if ($result) { while($row=mysql_fetch_assoc($result)) { $row["Score"] = 0;...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only as well... Ok I admit...

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

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 enough faffing! Here's a script I used to generate the SELECT query. If you run it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52 rows, I'd say specify the table you...

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

T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 ** Assumptions : None ** Inputs : @StringInput = the space separated string values ** Outputs : Single table ** Output Rows : One row per space separated string value ** Return Values : None...

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

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 found COLLECTION expression How? Quite simply the error is because the Creator Deluge syntax I was using to insert subform rows was wrong. Contrary to what the documentation that says "This task can be used in the following events", effective as of...

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

UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 = $db->query(); $sql = 'SELECT '.$modulescancontentsql.' FROM #__content WHERE state=1'; $db->setQuery( $sql ); $rows = $db->loadObjectList(); foreach( $rows as $row ) { $id = $row->id; $title = $row->title; } This fix has so far worked for Arabic,...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 on the following screen: Select the Report Type: For this calendar we want matrix because we're going to group based on the rows: Design the Matrix: Ok so we want weekday in the columns (to have mon-sun along the top), "Order" in rows (order is which...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 all cells and set row height to be 30 for example, but everytime we refresh the data in the Excel spreadsheet, all the rows get re-adjusted to fit the data and lose that consistency. A Workaround: New line inserted before and after So this is where I am...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 (type=2) then datasources and folders will also show. The Side-by-Side Table As you know, most datasets will return the rows as... rows. My pic above shows my 4 reports results side by side. To do this, I had to insert a Matrix rather than a Tablix:...

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

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 @stringtoFind, @stringtoReplaceWith) WHERE `introtext` LIKE CONCAT('%',@stringtoFind,'%') Run the first query again and no rows should be returned. Quick Joomla One I use this reluctantly but often necessarily. SET @stringtoFind=' '; SET...

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 My Most Frequent Fix: The data files I have to work with are rarely consistent. On some rows the date column will have a string of 8 characters long in the format DDMMYYYY and on other rows, this is blank with spaces instead, I still get the Error: The...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 -- USERGROUP MAPPING -- ********************************************************************* -- Note-to-self: Delete rows other than the admin ID -- DELETE FROM `v34_db`.`v34_user_usergroup_map` WHERE `user_id` @v25_admin_id; --...

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

CSS Printing - Page Break Inside with Headers and Footershttps://www.joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 at the centre) and the next page has a table which is of variable length. Fine when the table was short and didn't have many rows. But the client will pick up the phone to you when the table has too many rows to fit on one page, and this overlaps onto...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 report, click on "Get embed Code" (ensure this report is published) Get the Permalink and copy and paste this into a new browser window/tab Right-click on one of the file upload/attachments and copy the link Return to your code and customize the...

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

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 This is an article to document how to include a subform and rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create a quote record and include a subform containing the line...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were trying to loop through rows of a CSV file which contained addresses which in turn contained commas. Saving this as a CSV and asking Deluge to parse the...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row with data that is expected to be in the rows (ZohoAnalytics may have issues loading a file with only headers) Click on "Create" then "New Table/Import Data" > Select...

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