Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 p_STUDENT_ADNAME; -- opening cursor for the select query that I want to display in SSRS OPEN l_CURSOR FOR SELECT INITCAP(b.p_title) || ' ' || INITCAP(b.p_forenames) || ' ' || UPPER(b.p_surname) || ' (' || INITCAP(To_char(b.p_dob, 'DD-MON-YYYY')) || ')'...

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

Registered Users Cannot Login - Super Users Canhttp://mail.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 returned is greater than 1 then run the following query: UPDATE #__assets SET parent_id=1 WHERE parent_id=0 AND id1 AND title'Root Asset' -- where #_ is the Database Tables Prefix value Done phpMyAdmin alternative The gist is simple, you can only have...

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

AHK Countdown Tooltiphttp://mail.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 ; Program title ThisProgram:="ByeBU Countdown" ; Program version ThisVersion:="0.3 Beta" ; My leaving date FinalDate := "2014" "08" "29" "13" "00" "00" ; Background image to change to during the running of this program...

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

Basic Android App using Google Maps and Current Locationhttp://mail.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 Tablet then a relatively old version of the Android OS: Add an activity to Mobile: select Google Maps Activity: Change the Title to what you want (don't change the activity or layout) and click on Finish: Get yourself a developers' Google Android Maps...

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

MessageBox or AlertDialog in Android Javahttp://mail.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 to some event import android.app.AlertDialog; import android.content.DialogInterface; new AlertDialog.Builder(this) .setTitle("Some Title") .setMessage("some message") .setPositiveButton("OK", new DialogInterface.OnClickListener() { public void...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttp://mail.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would simply load...

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

Joes Word Cloud (JWC) Downloadhttp://mail.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 1.4- Added Joomla! Admin Option: Keyword Inclusion List - Fixed bug: Certain templates did not apply the CSS to the module title. - Removed Joomla! Admin Option: Code Override - Removed Joomla! Admin Option: Cached-Mode - Amended Font-size to base on...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 My full snippet of code // // loop through users to find the approver for each m_User in l_Users { if(m_User.get("Job_Title").equalsIgnoreCase("CFO")) { l_ApprovalUsers.add(m_User.get("id")); } } // // check list of IDs if(l_ApprovalUsers.size() > 0) {...

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

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

02 March 2022 any kind of record) m_ScheduleMeeting.put("What_Id",98765432109876543); // // the subject m_ScheduleMeeting.put("Event_Title","TEST Consultation: Call with TEST LEAD"); // // the description m_ScheduleMeeting.put("Description","More info / agenda"); //...

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

ZohoCRM: Get All eBay Active Listingshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 // // select which fields to return l_OutputFields = List(); l_OutputFields.add("ItemID"); l_OutputFields.add("Title"); l_OutputFields.add("SKU"); l_OutputFields.add("QuantityAvailable"); l_OutputFields.add("SellingStatus");...

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

Zoho Projects: Get All Eventshttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 + v_ThisDateEvent_Hour.toString() + v_ThisDateEvent_Minute.toString() + ifnull(m_PastEvent.get("title"),"?").trim().toLowerCase(); v_ThisEventStart = v_ThisDateEvent_Year + "-" + v_ThisDateEvent_Month + "-" + v_ThisDateEvent_Day + " " +...

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

Zoho Analytics: Create a Monitoring System with Imageshttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 on the "Import Your Data" page is "Enter Data Right Away": You'll be presented with a table of about 10 columns called "Untitled-1". I enter some labels in the first column. These will be keys later on to link my report to so keep them short without any...

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

ZohoCRM & Xero: Function to pull most recent quoteshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 m_CrmProduct.put("Product_Active",true); // // eg. Delivery should just be the name of the product not both the title and description if(!v_CrmProductName.equalsIgnoreCase(m_XeroLineItem.get("Description"))) {...

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

Hide Menu Item from Registered and Special http://mail.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 Can't simply hide an item but can hide a menu (of course the menu could have been created with just one item with no title and positioned at the bottom of another menu; this would look like it was all part of one menu). toubkal wrote: This cannot be...

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

Changing the yourdomain.com for phpBB3http://mail.joellipman.com/articles/cms/joomla/changing-the-yourdomaincom-for-phpbb3.html

01 October 2009 This is related to the issue of renaming yourdomain.com as your title page in phpBB3. You need to login to the phpBB admin control panel (ACP). On the General tab, look under Board Configuration and click on 'Board Settings'. The Site name is the first...

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

MySQL Oracle equivalentshttp://mail.joellipman.com/articles/database/mysql-oracle-equivalents.html

27 September 2010 title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle...

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

F_ck You. Pay Me.http://mail.joellipman.com/articles/web-development/fck-you-pay-me.html

14 April 2011 To be honest I saw this on some Joomlaworks Blog who appropriately title it "A must see for professional webdesigners". If you're a developer relying on clients for your income, then at least watch some of this. March 2011 San Francisco,...

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

First and Last Entry on a Page using Modulus Remainderhttp://mail.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 I know it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of...

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