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

19 July 2011 integration because our setup is perfect and well thought through" not - note the DBMS is not hugely relevant for the purposes of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2 report...

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

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 the Datasheet one) Give the view a name, select what columns you want the form to have (I included the IDs for functional purposes) Further down the "Create View" page, there should be a Sort section, specify the column to sort by. Save the view by...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 will open another report (the confirmation page) and pass through 2 parameters (the Student ID and the Job ID [for audit purposes]). The 3rd parameter is the Username of the person running the report. This second page is called "HouseKeepForm". We have...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 reference in the parameters of the first report (the one with all the main details), as well as a job reference (for audit purposes) and click "View Report". The report will refresh with a link to a confirmation report which the user clicks and confirms...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 for support or analysis. With inspiration from: "Obfuscating your SQL Server Data" by John Magnabosco but tweaked for our purposes. NOTE that the following has only ever been run on development environments and I would not recommend running this on a...

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

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 D300 4 Daat oNt EYt Avialable D300 This is obviously a simplified table as it doesn't tell us much but it is just for demo purposes. Consider the following query: SELECT DISTINCT StudentDetail FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data...

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

Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 demonstrates how to make this an option that your client can switch off/on using the Joomla Admin Panel. How? For demo purposes, I'm going to add the background "Ambient Turquoise". Yootheme uses CSS files to do this so we'll need to modify the XML file...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 the past, I have only ever changed the words to but for more stability, there are a few more tweaks to do. How? For demo purposes we will be referring to a Joomla module called "mod_moduletoupgrade" in British English (en-GB). I don't think it actually...

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

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last part of this, ie...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me find all the articles...

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

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 but for those of us who merely use SQL Server Management Studio (SSMS) and Microsoft's SQL Server 2008 R2 for development purposes, the once-in-a-blue-moon restore from backup process is quickly forgotten. How? You need to set the database to...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 // This method is called to register a custom log event "JL - Mixed Case Component Debug" which can be enabled for debug purposes. // This could produce extensive logs so this event should normally be disabled within the package logging! public override...

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

Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 with some slight modifications. First let's look at the XML output from SITS (this is a cut down version for demonstration purposes): 1234567 JOEL LIPMAN Two things to do really: Add the xmlns:xsi namespace in the xsl:stylesheet tag so that...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 I thought I'd note this down to remind me if I ever work for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process (TUP) based around a change in the course application details. Some of the...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 CURLOPT_URL, $apimo_url.'?'.$apimo_message_xml); // set url curl_setopt($ch, CURLOPT_VERBOSE, 1); // For debugging purposes (read CURL manual for nore info) curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30); // Timeout options curl_setopt($ch,...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 The code to update a form (sample data for demonstration purposes). Note that the payload here is submitted through URL parameters: v_AccessToken = "123abc456def789abc123def456abc"; v_Criteria = "ID=1234567890123456789"; v_EndPoint =...

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

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 a use case example which you will need to adapt to your own but It should do enough (spacing has been added for demo purposes and to make it clearer). In the below example, my form is called "Quotes" and my subform is called "Line_Items": // initialize...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 are going to search for some records in Zoho Creator and display these in either Zoho Books or Zoho CRM. For demonstration purposes, these have been simplified and will need to be adapted for your needs. Note that I have used 2 URL methods of linking to...

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

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 sections are called "Tab_Section_1", and so on... [these can be named as you want, the names I've used here are for demo purposes] hide Tab_Section_1; hide Tab_Section_2; hide Tab_Section_3; hide Tab_Section_4; hide Tab_Section_5; hide Tab_Section_6;...

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

Zoho CRM: Schedule a Meeting using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 create record r_CreateMeeting = zoho.crm.createRecord("Events",m_ScheduleMeeting); // // output response (for debugging purposes) info r_CreateMeeting;

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