Search - Joel Lipman .Com

1. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... :POST connection:"my_books_connection" ]; v_OutputResponse = "Thank you for accepting your quote! We'll be in touch soon to finalize the next steps and get everything ready."; } else if(v_Intent ...; Created on 04 November 2024
2. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... to view taxes and chart of accounts Setup a connection called "joel_inventory" that has the necessary scopes to do everything under the sun Setup a function that generates an access token of the Trading ...; Created on 27 April 2023
3. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... really a hardware kind of guy. My skillset is really around software (see my other articles) and I've been using Mac alongside my PCs for the past 7 years. My MacBook is from 2015 and still runs everythin ...; Created on 12 March 2022
4. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... I could do it the long way in Zoho Deluge. We match a pattern and replace everything out that conforms to the criteria so a true response will be an empty string: v_MyRegEx = "^[A-Za-z0-9._-]+@[A-Za-z0-9._-]+\.[A-Za-z]$"; v_MyString ...; Created on 31 May 2019
5. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; ... file: mysqldump --defaults-file=/path-to-file/.my.cnf my_db > /path_to/backup.sql // and in your cnf file: [mysqldump] user=my_user password=my_password The one to rule them all: // everything: ...; Created on 20 March 2019
6. Zoho Templates - Font size is inexplicably tiny: / Zoho /; ... by an issue which I'd been working on for most of the day where I would remove all the styling and the text would still appear small. Sure I resized the text to about 46pt and everything was over 3000px ...; Created on 22 February 2019
7. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... in the top right) ' Press F5 to run the code. ' You will be prompted for the total range (eg. $A1:$W36000) ' And then prompted for the number of rows per sheet (eg. 3000) ' Run everything Sub RunAll() ...; Created on 11 February 2019
8. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
9. MySQL Transactions in PHP: / MySQL /; ... 1 row affected by each query if ($a1==1 && $a2==1) { //Everything looks OK, commit changes $mysqli->commit(); } else //Something went wrong. Roll back to before begin_transaction() $mysqli->rollback(); } $mysqli->close(); mysqli->begin_transaction() ...; Created on 14 December 2016
10. Error 1065: Query was Empty: / MySQL /; ... will also make their system escape apostrophes (') and double-quotes ("). But who can honestly build a system that thinks of everything from day one? How? Check all required values to escape have ...; Created on 13 December 2012
11. Basic Oracle Function Structure: / Oracle PL/SQL /; What? I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function ...; Created on 15 January 2012
12. Joes DNS Correction (JDC): / Product Documentation /; Ever had this? Your colleagues are connecting fine and your IT service desk say everything is functioning normally and it's just YOU! Script Function If you are on a network that frequently ...; Created on 25 November 2011
13. The ReportServer Database: / Databases /; ... aggregate query. I want the SQL to return just numbers and let the MDX query add the thousand separator. My answer for everything: CAST((TimeEnd - TimeStart) AS TIME) CAST(CONVERT(CHAR, ...; Created on 08 August 2011
14. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... of these. Whatever the reason, I needed a FREE option and everything available had a limit to its "FREE" services. There are websites that do this for me? Yay! for free as well, as long as my page ...; Created on 28 June 2011
15. Difference between two dates - the midnight hour: / Web-Development /; ... 2); // Using the examples above this is doing the following: 2011-03-04 12:00:00 - 2011-03-04 10:00:00 = 2.00 2011-03-08 00:30:00 - 2011-03-08 23:30:00 = -23.00 This is great for everything during ...; Created on 06 April 2011
16. PHP & MySQL Search Engine: / Personal Home Page /; ... removes MS Office style html comments (and everything in between) $str = str_replace(array("\r\n", "\r", "\n", "\t"), ' ', $str); // remove carriage returns, line feeds, tabs and double-spaces # ...; Created on 09 March 2011
17. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... -- You could copy and paste this whole query and then remove everything -- from the "INSERT INTO" to just before the "SELECT" (as below): -- SET @exampleLocalVariable=1; ...; Created on 30 January 2011
18. Merge the content of two similar tables in MySQL: / MySQL /; ... to query the Title and the Introductions of any valid articles from BOTH tables and return one table with everything I want. Consider the following two tables exist: Joomla Articles (table name: ...; Created on 11 January 2011
19. Accessing a MySQL Database with Business Intelligence Development Studio: / MySQL /; ... on "Details" until everything is added. > Next I'm boring and old-school so my table style will be "Generic". > Next FINISH That's all folks! Hopefully this will save you time. I spent a whole ...; Created on 05 January 2011
20. Create Read-Only Database User in SQL Server: / Databases /; The following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security ...; Created on 09 November 2010