Search - Joel Lipman .Com

1. Modifying columns in a table: / Databases /; What? This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). ...; Created on 24 July 2013
2. Reorder Columns in a Table: / Databases /; What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...; Created on 22 July 2013
3. MySQL Commands to display all columns: / MySQL /; The scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. ...; Created on 28 October 2010
4. Blank columns issue when exporting to Excel (Data Only) from Crystal Reports: / Excel /; Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue ...; Created on 15 June 2010
5. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData ...; Created on 26 August 2021
6. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... == 3000) { l_HeaderColumns = List(); l_HeaderColumns.add(); l_HeaderColumns.add(); l_HeaderColumns.add(); l_SearchResults = r_SearchResults.get("data").toJSONList(); for each r_Result in l_SearchResults { v_CreatorQuoteID ...; Created on 30 July 2021
7. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; ... use a for loop. I have a map with 3 columns: first_name, last_name, and ID. What I want is a HTML table now with the headers and data but without using a for loop. What I have: , What I want: First ...; Created on 11 January 2021
8. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files. ; ; ...; Created on 08 July 2020
9. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... what the link should be: Ensure a report exists with your form and that one of the fields/columns viewable is the file upload or attachment field In Zoho Creator, in the "Edit" mode, go to "Settings" ...; Created on 15 May 2020
10. MS Excel - Open CSV with Long Numbers: / Excel /; ... each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be imported as text (the long numbers and phone numbers) ...; Created on 23 July 2019
11. Trim values along with the tab: / MySQL /; ... Unfortunately, the MS Excel software adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to ...; Created on 13 June 2016
12. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... 10th Mar 2013 2.1.1 - Corrected alias reference to all columns irrespective of order settings. - Link for text only links title and not description. - Restored module parameter: Display Rank or ID.- ...; Created on 07 September 2015
13. List of Font Awesome: / Web-Development /; ...  fa-cog []  fa-cogs []  fa-columns [] ...; Created on 04 September 2015
14. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... and to populate a database table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? ...; Created on 13 June 2014
15. Excel: Find values in one column that are not in another: / Excel /; What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...; Created on 06 March 2014
16. Generate a Timesheet in MySQL: / MySQL /; ... We have the first two columns of what we want to do. Now we need the same again but this time we want the morning slots SELECT DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) ...; Created on 05 December 2013
17. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... and ", "la", "le", " van ", " de ", " of " and similar should remain lowercase. How? The SSIS Script component task has to be generic, it should only apply this to columns we specifically tick i ...; Created on 04 October 2013
18. Compare two databases using T-SQL: / Transact-SQL /; ... here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases ...; Created on 24 September 2013
19. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... failed. Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "MyDerivedColumns" (4228)" failed because error code 0xC0049063 occurred, and the error row disposition on "output ...; Created on 23 April 2013
20. MS Excel - Sort pivottable column headings by date: / Excel /; ... with one more zero so that "008" is before "010": Great! The columns are displayed in the correct order but who's ever seen a date written as the 008th of April? What if we didn't use parentheses? ...; Created on 12 April 2013