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 Analytics: Create a Monitoring System with Images: / Zoho /; ... 10 columns called "Untitled-1". I enter some labels in the first column. These will be keys later on to link my report to so keep them short without any special characters. I then saved this table with ...; Created on 25 July 2024
6. 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
7. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... r_Analytics; // // add to analytics m_Header = Map(); m_Header.put("ZANALYTICS-ORGID",v_AnalyticsOrgID); m_Columns = Map(); m_Columns.put("columns", m_Data); m_Params = Map(); m_Params.put("CONFIG" ...; Created on 05 December 2023
8. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... integer, currency, decimal and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with conditions. The only operator that is supported for encrypted ...; Created on 14 November 2023
9. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... form is called "Staff" and the subform is called "Usual Shift" containing the columns "Day", "Start Time", and "End Time": // // select applicable staff l_ApplicableStaff = Staff[ID != 0]; for eac ...; Created on 28 March 2023
10. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... on each row and then the campaigns as columns. What we want: Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3 ---------------- --------------- -------------- -------------- ...; Created on 20 March 2023
11. ZohoCRM: Import Attachments: / Zoho /; ... the reverse process, the import file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" ...; Created on 16 January 2023
12. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; ... I select on a dashboard. First you will need a table or query that has a bunch of columns and rows with one of the columns containing the sale person name. Something like the following: With ...; Created on 24 October 2022
13. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... the parent form to hide the columns I don't need the user to see (I'll populate these by code): hide Attachments.Parent_Record; hide Attachments.Document_Name; hide Attachments.Downloaded; Here ...; Created on 11 March 2022
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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