Search - Joel Lipman .Com

1. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... "payment_terms": -3, "payment_terms_label": "Due end of next month" } ] } } Usage: This is just a snippet of usage and obviously not the whole function to generat ...; Created on 06 July 2023
2. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... and obviously want to display these as decoded HTML entities. (Zoho if you're listening) Ideally, Zoho may add this to their zoho.encryption namespace such as zoho.encryption.htmldecode(string). But at ...; Created on 27 January 2022
3. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... work if you don't include this parameter. For the code of the function this is what I did, you can eventually develop this to do more but I'm coding for this example and for this demonstration only (obviousl ...; Created on 15 July 2021
4. CSS Printing - Page Break Inside with Headers and Footers: / Cascading Stylesheets /; ... this is obviously for when it comes to printing. Why? I needed to create a template in HTML where the first page is a cover page (background image filling the page with a logo floating at the centre) ...; Created on 22 February 2019
5. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... eg. ALTER TABLE `v34_content` AUTO_INCREMENT = 1 JComments Obviously only do this if you have jComments installed. If I ever get a task to migrate a website with K2, I'll update this article. ...; Created on 12 September 2015
6. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... 0.4 seconds. We're obviously not interested in shaving off time from 0.4 seconds; no, we're more interested in the fact that 0.4 Microsoft seconds seems to translate to about 10 minutes in the real ...; Created on 07 March 2014
7. Leap Motion and AR Drone: / Quadcopters /; Leap Motion is a USB gesture control device you can connect to a computer which behaves much like a mouse or trackpad but in 3 dimensions. Available July 2013 for public release (you can pre-order if ...; Created on 17 May 2013
8. Search a database with SOUNDEX: / Databases /; ... the collation of the SQL Server being case-insensitive. What? End-users said that they could see the options "Data Not Yet Available" as well as "Data not yet available". These are obviously the ...; Created on 11 October 2012
9. T-SQL example of Case-Sensitive Soundex: / Transact-SQL /; ... 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 ...; Created on 10 October 2012
10. Basic Joomla 2.5 Mootools Form: / Joomla /; ... just prints back an array of data that was sent to it; obviously you may want to tidy this up but the more basic the receiving data the better. In my example, I'm returning some HTML but for security and ...; Created on 20 August 2012
11. Prefix Line Numbers in a Text File: / MS-DOS /; ... file) original_file.txt is your original file (obviously change the name to your file) temp.txt is just a dummy file which should be empty for clarity results_file.txt is the resulting file, it ...; Created on 18 July 2012
12. SSRS Repeat Headers in PDF Report: / SQL Server Reporting Services /; ... (which does not include the tablix header... obviously). I right-clicked on the header row of the tablix and checked the box "Repeat header columns on each page. Situation I have a report ...; Created on 26 October 2011
13. SSRS External Images don't displa: / SQL Server Reporting Services /; ... will be visible on the executed report (obviously replace the field name with the name of your field containing the location of the image - ours is "PhotoURL"): =" The file " & First(Fields!PhotoURL.Value, ...; Created on 19 September 2011
14. Oracle SQL - Convert given list (CSV) into Rows: / Oracle PL/SQL /; Just a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've ...; Created on 30 August 2011
15. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... based on the first parameter but ended up with an error going on about "forward dependencies". This is obviously going to error, so continuing on their solution, setting the "Available Values – Specify ...; Created on 19 July 2011
16. What's the problem? Amusing computer issue: / Web-Development /; ... uploaded it to their homepage. The 3rd-party company had obviously designed the template to work in one browser only: Internet Explorer version 7. The marketing web-gurus were simply using different browsers. ...; Created on 28 April 2011
17. Difference between two dates - the midnight hour: / Web-Development /; ... Dum 23:30 00:30 -23.00 Note the last row is obviously incorrect. This is because the script is not changing the date at the stroke of midnight. Take the last row ...; Created on 06 April 2011
18. Developer's Checklist: Taking over a projec: / Web-Development /; ... work to do and expected results) Realistic Cost & Time (obviously agreed with client) Additional Documentation (timesheets, agreements, technical specifications, issue logs, product documentation) ...; Created on 01 March 2011
19. Merge the content of two similar tables in MySQL: / MySQL /; ... This is HP 2 Copyright This site and its design is property of SomeoneElse.com Obviously the two above tables are very similar with different column names. I also don't want the data to ...; Created on 11 January 2011
20. UTF8 Unicode PHP MySQL for International Characters: / Personal Home Page /; This is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international ...; Created on 22 October 2010