Search - Joel Lipman .Com

1. MySQL: Find all non-alphanumeric rows: / MySQL /; What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? ...; Created on 09 September 2013
2. Split a row into multiple rows based on a column value: / Transact-SQL /; Applies to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that ...; Created on 23 August 2013
3. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; What? This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation ...; Created on 23 April 2013
4. SSIS Skip Rows in Excel Source file: / SQL Server Integration Services /; What? A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then ...; Created on 04 April 2013
5. DataScramble - Randomizing data rows: / Transact-SQL /; What? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts ...; Created on 07 December 2012
6. DataTumble - Randomize Data Rows: / Transact-SQL /; What? This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ...; Created on 07 December 2012
7. Search a database for a value and count matching rows: / Databases /; What? We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called ...; Created on 05 November 2012
8. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... but has an ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty ...; Created on 24 January 2012
9. Oracle SQL - Convert given list (CSV) into Rows: / Oracle PL/SQL /; ... suffixed a comma to but I want to display this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT ...; Created on 30 August 2011
10. Web Browsers Release Year: / Web-Development /; Source: http://en.wikipedia.org/wiki/Comparison_of_web_browsers Year Web Browsers Internet Users (in millions) 1991 ...; Created on 18 May 2010
11. This file contains HTML or script code that may be erroneously interpreted by a web browser: / Hypertext Markup Language /; The Error: This file contains HTML or script code that may be erroneously interpreted by a web browser This is a common error when uploading files that the MediaWiki system does not allow. By making ...; Created on 08 October 2009
12. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... downloading a JSON file. Looked a bit suspicious. The code below opens a new tab in their web-browser displaying a plain output message. How? So there are 2 caveats to this solution: 1 is that ...; Created on 04 November 2024
13. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... gave it the data type of "URL": Now to copy over the image URLs, I duplicated my web-browser tab (right-click on the browser tab if using Google Chrome and select "Duplicate"). I then arranged the ...; Created on 25 July 2024
14. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... response l_DataRows = ifnull(r_PurchaseOrders.get("data"),List()); // // build up related list header row l_HeaderColumns = List(); l_HeaderColumns.add(); l_HeaderColumns.add(); l_HeaderColumns.add(); // ...; Created on 09 July 2024
15. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... with rowspans and the borders need to merge cells). But here we're simply going to use ZohoCreator and its PDF rendering options. What's wrong with just using CSS? It looks beautiful on ZohoCreator ...; Created on 07 May 2024
16. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... we'll generate the CSV rows and then a file; then we'll use invokeURL to upload the file. Generating the CSV Here's the simplified code to generate the CSV - note that I am replacing commas with the ...; Created on 25 March 2024
17. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... data that is expected to be in the rows (ZohoAnalytics may have issues loading a file with only headers) Click on "Create" then "New Table/Import Data" > Select "Files" (the one with the Excel icon) Give ...; Created on 05 December 2023
18. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; What? This is an article to show you how to, using Deluge code, generate all the email signatures in the user profile in ZohoCRM. Why? To simplify the on-boarding process. A client of ours has ...; Created on 05 December 2023
19. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... that file sat on someone's mailbox. It must be downloaded (as in browser downloads it to the computer immediately) and then removed from wherever it was downloaded from... All within ZohoBooks without ...; Created on 02 October 2023
20. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... + p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM an ...; Created on 18 September 2023