Unix Date Format Specifiershttps://joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 day of week starting with Monday (1), i.e. mtwtfss 1 %w day of week starting with Sunday (0), i.e. smtwtfs 1 Week %U week number Sunday as first day of week 01–53 %W week number Monday as first day of week 01–53 %V week of the year 01–53 Month %m mm...

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

T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 blog, I wrapped my SQL query within a common table expression: --Create CTE WITH tblDifference AS ( SELECT t1.*, ROW_NUMBER() OVER (ORDER BY t1.Date ASC, t1.Start ASC, t1.Room ASC, t1.Finish ASC) as 'RowNumber' FROM ( -- start your original SQL query...

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

Getting the mysql where in delimited string to workhttps://joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to...

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

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

15 January 2012 is all I need in this case. In my example, I need to submit an Active Directory (AD) username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as user...

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

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

19 January 2012 an Oracle stored procedure to work with SSRS. Main Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's names and date-of-birth based on the student ID number Agenda Outline Note: As...

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

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

14 March 2013 blab actually means is that there is a chance one of your date values is BLANK, NULL or contains a non-numerical value in a number such as COMMA (,) and therefore the parsing (to extract year for example) will fail and stop the task (based on default...

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

T-SQL: Parse an XML valuehttps://joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 following examples): -- exist() returns 1 or 0 if node exists or not respectively SELECT Event_XML.exist('/STAFF/EMPLOYEE_NUMBER') FROM [dbo].[XML_EVENTS] -- query() returns typed XML SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER') FROM...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 - Fixed Bug: Parameter initialization and class array correction (by Miguel Isasmendi) - Fun Bug: Debug mode shows number of seconds this module adds. - Date Uploaded: Tue, 23rd Aug 2011 2.0.3 - Optimizing code - Date Uploaded: Sun, 21st Aug 2011 2.0.2...

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

Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 and 100 API calls/minute Zoho CRM API v2 Limits 2019: Free Edition: 5000 API calls/day Standard/Starter Edition: 5000 + (Number of User licenses x 250) API calls/day [Maximum 100,000] Professional Edition: 10000 + (Number of User licenses x 500) API...

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

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

15 May 2020 // // init v_OutputMessage = ""; v_CrmSoRef = ""; v_CrmSoID = 0; // // get books so name (sales order number) r_BooksSoDetails = zoho.books.getRecordsByID("Salesorders",v_BooksOrgID,v_BooksSoID.toString()); for each r_SoBooks in r_BooksSoDetails {...

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

Zoho Deluge: Get All Orders from eBayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 - GetOrders Documentation: https://developer.ebay.com/Devzone/XML/docs/Reference/eBay/GetOrders.html - eBay Errors by Number: https://developer.ebay.com/devzone/xml/docs/Reference/ebay/Errors/errormessages.htm */ // // declare v_Page = 1; v_PerPage =...

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

Using MetaMod to hide buttons from logged in usershttps://joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 Quick Modules To" choose - 'non-logged in users only' then scroll down to the list of available modules and find the "ID" number for your "pubmenu" item and then input that number in the "Quick Module ID Include" field. 6. Copy metamod_pubmenu, edit and...

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

SQL Queries for Statisticshttps://joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT...

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

Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 --- Integrate JComments/Integrate Facebook Comments (for Product Reviews/Feedback). --- Auto-increment minor/major version number / Assign naming convention. --- Date Format for files (mysql format please cos unix will take my server's one). --- Enable...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

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

02 September 2011 The StudentID (reference) varchar2, Username (who's running the report) varchar2 and a JobID (request reference) number. The Report We start off with our detailed report page which lists all the details of a student. There is a textbox linked to an...

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

No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....

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

Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 interval operator is specified with a single digit enclosed in braces. You use this operator to search for an exact number of occurrences of the preceding character or subexpression. For example, to find where 'a' occurs exactly 5 times, you specify the...

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

Android: Replace return key with done, go, send...https://joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 } return handled; } }); Other Noteworthy Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No suggestions/autocorrect textEmailAddress // valid email address...

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

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How?...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 r_CreateSO.get("salesorder"); v_NewSoID = r_NewSoDetails.get("salesorder_id"); v_NewRefNum = r_NewSoDetails.get("salesorder_number"); // // build up a reference map from the line items of the newly created sales order m_NewLineItems = Map(); for each...

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