MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 doing any other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I...

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

SSRS Subscriptions cannot be createdhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more...

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

Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 SELECT ps.person_id, ps.person_name, ( select pa.person_reference as personid, pa.person_text as txt from Person_Academia pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc )...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

Display a thumbnail of a Google Drive videohttps://www.joellipman.com/articles/google/display-a-thumbnail-of-a-google-drive-video.html

13 November 2018 is a redirect to the actual thumbnail stored by Google Drive: https://drive.google.com/thumbnail?authuser=0&sz=w320&id= // where is the file id The shareable link to the file will be something like: https://drive.google.com/file/d//view?usp=sharing //...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 function invokeURL rather than the usual shortcode of zoho.crm.updateRecord() or zoho.crm.createRecord(). How? This is somewhere in the official documentation but here's the bits that I need: Updating a record with PUT (note that id needs passed for...

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

View your available module positionshttps://www.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 which took me a few years to notice in Joomla. If you've ever installed a template for Joomla and spent hours working out where or how you are going to put what where, try adding ?tp=1 after your index.php url (ie. http://www.yourdomain.com/?tp=1) If...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 cache" so click on the "Run Now" button which I found myself doing at lots of stages in this installation process. So note where it is and come back to it when things aren't responding properly....so in summary: General → Server configuration → Load...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 the change: // We need to get a list of all weblinks in the given category $query = 'SELECT *' . ' FROM #__weblinks' . ' WHERE catid = '. (int) $this->_id. ' AND published = 1' . ' AND archived = 0'; $query.=($filter_order!="ordering")?' ORDER BY '....

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

K2 Items disappearhttps://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 on line 145 So I checked these pages and the error is at a foreach() line where it's pulling data from the database. I asked to see the jos_k2_items table and it returned the following error: #145 - Table './jos_k2_items' is marked as crashed and should...

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

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 AS [Date] UNION ALL --Add a record for every day in the range SELECT DATEADD(DAY, 1, [Date]) FROM Dates WHERE Date...

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

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

04 February 2011 "Double", "Solid") BorderWidth: 1pt, , , , =IIF(RowNumber(Nothing)=Count(Fields!Field1.Value, "DataSet1"), "3pt", "1pt") -- where "Field1" is a column in my dataset and "DataSet1" is my dataset -- and Count(Fields!Field1.Value, "DataSet1") returns the...

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

Room with a view E.M. Forsterhttps://www.joellipman.com/articles/_other-misc/room-with-a-view-em-forster.html

04 February 2011 Taking a break from website migrations. Thought I'd share some thoughts I was reminiscing of: "We cast a shadow on something wherever we stand, and it is no good moving from place to place to save things; because the shadow always follows. Choose a...

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rs:Format=XML Where XML can be any of the following: HTML3.2, HTML4.0, MHTML, IMAGE, EXCEL, WORD, CSV, PDF, XML, defaults to HTML4.0 So to export to...

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

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

09 March 2011 users. This sounds really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql = "SELECT * FROM Content WHERE content_body LIKE '%$search_term_esc%'"; Great! Few problems though, multiple terms are not supported; quotation marks and...

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

CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 the DIV layer width to be 100 percent of the page. Position the module with absolute on your webpage with background (where left is 0 [zero] because your width is 100%). Position the background image bearing in mind that your layer is 100% of the...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 null entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name ASC NEW: Dataset to populate the dropdown SELECT d1.Name, d1.ItemID FROM ( SELECT Name, ItemID FROM...

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

Basic Oracle Function Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 IN varchar2) RETURN number IS student_no number; cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if;...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 a funny way of working with dates which made this need to be changed. The following function now requires a second parameter where you specify the data type: CREATE OR REPLACE FUNCTION UFN_DATASCRAMBLE ( p_original_value IN VARCHAR2, p_original_datatype...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

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

10 October 2012 tell us much but it is just for demo purposes. Consider the following query: SELECT DISTINCT StudentDetail FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not Yet Available') -- yields StudentDetail ----------------- Data Not Yet Available...

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 (Stage 1) is the only part you need to modify as this will improve your Joomla search results by giving priority to articles where the search term is in the article title. In the stages thereafter, I'm going to simply enhance the relevance factor:...

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