Search - Joel Lipman .Com

1. T-SQL functions to convert Strings to Tables: / Transact-SQL /; Applies to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's ...; Created on 20 August 2014
2. Delete related records from multiple tables: / MySQL /; What? So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead ...; Created on 11 January 2013
3. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters ...ouch... ...and it was so easy up to here... Tables of interest StaffActivities ...; Created on 24 August 2011
4. Merge the content of two similar tables in MySQL: / MySQL /; In standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). ...; Created on 11 January 2011
5. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... now I can go back to my query and expand on it a little to include the other datasources (CRM Tables): SELECT 'CRM Accounts' AS "DataSource", date(t1."ModifiedTime") AS "Date", t1."RecordID" ...; Created on 25 July 2024
6. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... be in a bigger font?"... without pushing back too much, it can end up looking like those old websites with HTML tables. We're going to use a HTML table again but that's because I want to send it to the ...; Created on 07 May 2024
7. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... from ZohoDesk to ZohoAnalytics using the integration. Other tables will sync but we couldn't find attachments, so our solution here is to create a data table and then to push the attachment from ZohoDesk ...; Created on 05 December 2023
8. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... We want the photo on eBay to be downloaded and uploaded to the Zoho Inventory record for the respective record. As Zoho Books and Zoho Subscriptions uses the same database tables as Zoho Inventory, and ...; Created on 21 June 2022
9. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... browser with that profile. How? So you will need to be able to run AutoHotkey or create executables from an AHK file. Here is the code that creates a GUI with a ListView with rows that can be double-clicked ...; Created on 07 January 2020
10. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; ... database accessible only by root and and this database "backuper" user. For both methods, I grant the following to the user doing the backup on the database I want a backup of: GRANT SELECT, LOCK TABLES, ...; Created on 20 March 2019
11. Zoho Deluge - Update Creator from CRM: / Zoho /; ... of creator is the one creating the connection link. The JSON response is that the update was successful but the Creator tables do not update... ZohoCreator/creatorapi option not available to enable: ...; Created on 18 February 2019
12. MySQL Transactions in PHP: / MySQL /; Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account ...; Created on 14 December 2016
13. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... respective database tables are prefixed with "v25_" and "v34_". So an example MySQL statement will be: `v25_db`.`v25_tablename` -- with the database name and table prefix of database you are READING ...; Created on 12 September 2015
14. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... Date is now "created" date. - Enhancement: Included span tags for individual elements. - Enhancement: Using div layers instead of tables. - Fixed Bug: Switched CSS ID tag to CLASS for W3C Validation. - ...; Created on 07 September 2015
15. Forgotten Super User Password in Joomla 2.5.x - 3.x: / Joomla /; ... database table (where #_ is the prefix to your joomla tables) Find the column password and the row of your known user and Copy the text there Find the row of your forgotten user and Paste the text ...; Created on 06 February 2015
16. MySQL Updating a database table from another table: / MySQL /; What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they ...; Created on 22 October 2014
17. SSIS Multiple Lookups in one: / SQL Server Integration Services /; ... do this: But we didn't want to do this. How? As a proof of concept, I created one lookup task that executes a SQL query which returns all the joined tables and displays the decode name. Let' ...; Created on 05 August 2014
18. Registered Users Cannot Login - Super Users Can: / Joomla /; ... Open the #__assets tablewhere #_ is the Database Tables Prefix value found by logging into your Joomla admin panel Browse to Site > Global Configuration > Server > Database Settings : Database Tables ...; Created on 26 February 2014
19. T-SQL concatenate an incremental row number: / Transact-SQL /; What? This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID ...; Created on 24 May 2013
20. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read ...; Created on 14 May 2013