Search - Joel Lipman .Com

21. Convert a delimited string to table: / Databases /; What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- ...; Created on 26 October 2012
22. Copy a table with structure and data into a temporary table: / Transact-SQL /; Why? Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the ...; Created on 03 August 2012
23. Excel PivotTable Filter List Ordering: / Excel /; ... summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a ...; Created on 05 September 2011
24. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... start time, end time... Report Specification PivotTable Report ...resources in row (along the side)... ...staff in columns (along the top)... ...persondays in values (the ...; Created on 24 August 2011
25. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... mean "I don't know". I want the report to either return the correct value or say "No data found". My end-users would otherwise ask is the data value reliable if it's blank? The long way of doing ...; Created on 29 March 2011
26. MySQL: Find records in one table that are not in another.: / MySQL /; ... like. I like queries against this database because it involves linking a lot of tables and outputting... just articles and their titles. I have another table holding the audit trail of content approvers ...; Created on 25 February 2011
27. 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
28. MySQL Data Type Reference Table: / MySQL /; A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. ...; Created on 15 February 2010
29. Database Error: Unable to connect to the database: Could not connect to MySQL: / MySQL /; I've been looking into this for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause ...; Created on 25 September 2009
30. How to make a HTML form post its variables to itself: / Hypertext Markup Language /; The Issue You have a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but ...; Created on 17 September 2009
31. View your available module positions: / Joomla /; ... Preview Module Positions -> Disabled or Enabled You will still need to suffix the frontend URL with ?tp=1 Joomla 1.5.x This is another feature which took me a few years to notice in Joomla. ...; Created on 15 September 2009
32. Joomla: Unable to find install package: / Joomla /; This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to ...; Created on 05 September 2009
33. Zoho CRM: Make Upload File Field Mandatory: / Zoho /; What? A quick article on making an "upload file" field mandatory. Why? Because for some reason, it wouldn't appear as selectable when I tried using a layout rule. Probably everyone else has figured ...; Created on 18 December 2024
34. Zoho CRM: Updating a CRM record Custom Line Items using API v7: / Zoho /; What? This is a quick bit of code for my reference so that I don't have to keep finding a function that gives me the syntax of how to either create or update a record using invokeUrl. Why? Because ...; Created on 18 December 2024
35. Google Event Ilustrations aka Flairs: / Google /; ... massage, back rub, backrub, massages newyear: new year, new year's, new years oilchange: oil change, car service pingpong: ping pong, table tennis, ping-pong, pingpong planmyday: plan week, plan quarter, ...; Created on 05 December 2024
36. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... = "-"; v_OrgId = "123456789"; v_Output = "Unable to process request"; // // evaluate v_Intent = ifnull(input.p_Intent,"-"); v_QuoteRef = ifnull(input.p_QuoteRef,"-"); v_CustomerID = ifnull(input.p_CxID,"-"); // // ...; Created on 04 November 2024
37. Zoho Creator: Input Color Picker: / Zoho /; ... to complete the radio options This is the code when loading the form: Created or Edited > Load of the Form // // I like defaulting variables v_DefaultColor = "#000000"; // // a color palette l_ColorPalette ...; Created on 14 October 2024
38. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
39. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Go back to the contact record, and upload the file to the attachment... Some customers say this is unworkable and takes far too long, especially the part of adding the various field placeholders ...; Created on 06 August 2024
40. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; What? A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was ...; Created on 31 July 2024