JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 ASC'); Single Value Result This type of query is for when you want just one value from one column and one particular row. $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('email') ->from($db->quoteName('#__my_users'))...

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

Creating a custom form field type for Joomla XML fieldsethttps://joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 form field type. In the following example, I'm going to create a dropdown which selects all projects associated with a particular user. Method #1: Important! It took me two days to realize that underscores are not accepted in the type name (despite...

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

Alternate row background colour in Reporting Serviceshttps://joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

04 February 2011 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 example is what I use most...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

19 July 2011 is blank (this field can be null in the database); so that's a lot of rows, possibly all unrelated and won't work in my particular case. The solution to this issue of these solutions would be to add another AND clause where you state that the ID...

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

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

17 November 2011 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular report (which searches for results matching the submitted parameter) to run. Lifted from Dattatray Sindol's blog Other...

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

Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 Now without using PHP, I need standalone SQL scripts that can simply be used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to...

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

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

05 November 2012 We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is...

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

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

10 October 2012 in a select and then listing all the 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...

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

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

18 February 2010 it in reverse order so that the most frequent is at the top of the list print out each row with the number of times that particular data appeared in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all...

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

Comparing two mediawiki siteshttps://joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

17 September 2010 In this particular case, I'm comparing my Live and Dev versions of the same MediaWiki site. I want to add the SQL queries I used to this article but I'm in the middle of carrying out this process and it's due in two hours. Checking both MediaWiki have...

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

SSRS Expand specific drilldown by defaulthttps://joellipman.com/component/content/article/ssrs-expand-specific-drilldown-by-default.html?catid=75&Itemid=165

23 February 2011 Development Studio (BIDS) or MS Report Builder. Scenario I have a report that specifies some room bookings for a particular week. When I open the report, each drilldown row is collapsed (as opposed to expanded). The user can specify the date as it's a...

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

Set default parameter dates to start and end of monthhttps://joellipman.com/component/content/article/set-default-parameter-dates-to-start-and-end-of-month.html?catid=75&Itemid=165

05 April 2011 specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes googling and reading up on is asking for an article on...

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