Search - Joel Lipman .Com

1. Joomla field types clear my html: / Joomla /; What? Trying to make a component and can't remember how to store HTML code when the save command is clicked (ie. submitted from a PHP form). This is for the Opensource Content Management System (CMS ...; Created on 09 August 2012
2. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... = v_ImageSrc.getPrefix("\""); if(!isBlank(v_ImageSrc)) { // use a try...catch as some file types may cause this to partially fail try { v_CountNew = v_CountNew + 1; f_DownloadFile ...; Created on 26 January 2024
3. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... to only push valid image file types as files. The report will work for Zoho Users... didn't really test on permissions and sharing the report, I was logged in as the super admin on both ZohoDesk and ZohoAnalytics ...; Created on 05 December 2023
4. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... in, not_equal, greater_equal, greater_than, less_equal, less_than and between. The supported data types are picklist, id, owner_lookup, user_lookup, lookup, phone, email, date, datetime, text, textarea, ...; Created on 14 November 2023
5. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... = Map(); m_Params.put("amount",v_StripeAmount); m_Params.put("currency","gbp"); //m_Params.put("automatic_payment_methods[enabled]", false); m_Params.put("payment_method_types[]","card_present"); m_Params.put("capture_method","manual"); v_DescriptionString ...; Created on 16 March 2023
6. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; What? So this is an article for me to store prompts for the MidJourney AI text-2-image discord tool. Why? The results from the MidJourney bot are beyond unpredictable however with the correct ...; Created on 11 February 2023
7. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... TSV, Text, Excel, MS Access DB, HTML, JSON, XML and others: Supports server types of FTP, FTPS - File Transfer over Explicit TLS/SSL, FTPS - File Transfer Over Implicit TLS/SSL, and SFTP - SSH File ...; Created on 12 January 2022
8. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... - SetNotificationPreferences Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/SetNotificationPreferences.html - Event Types Documentation: https://developer.ebay.com/Devzone/XML/docs/Reference/eBay/extra/stntfctnprfrncs.rqst.evntprprty.evnttyp.html ...; Created on 20 September 2021
9. Zoho Deluge - Get Current User ID: / Zoho /; ... } } } Method #2: InvokeConnector // get current user id m_UserTypes = Map(); r_Response = zoho.crm.invokeConnector("crm.getusers",m_UserTypes); l_Users = ifnull(r_Response.get("response").get("users"), ...; Created on 08 April 2019
10. CSV Chart Generator: / Product Documentation /; ... chart which you can zoom in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free ...; Created on 04 September 2015
11. XML Schema Reference: / Extensible Markup Language /; ... data within an XML document redefine Redefines simple and complex types, groups, and attribute groups from an external schema restriction Defines restrictions on a simpleType, simpleContent, ...; Created on 13 August 2014
12. SITS: Export field code and name: / Extensible Markup Language /; Applies to: Microsoft Windows 7 Enterprise SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the ...; Created on 12 August 2014
13. SSRS Display question mark when date is blank: / SQL Server Reporting Services /; ... referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to be of the same data type: =IIF(CStr(Fields!MyCompletionTime.Value)"", ...; Created on 15 April 2014
14. SSRS Change Background Color of Image: / SQL Server Reporting Services /; ... Why? I want an image to display per row as a status marker for 3 different types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I want the ...; Created on 08 April 2014
15. Problem creating SSRS report subscriptions: / SQL Server Reporting Services /; ... There are various types of data sources used in SSRS so I'm going to try and cover the ones I have used previously and what we needed to get them working. Custom DataSource Upload the report ...; Created on 11 November 2013
16. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... Visual Studio 2010 Create a new setup project - File -> New Project... Under Other Project Types | Setup and Deployment, select Setup Project Delete User's desktop and User's Project Menus folders ...; Created on 04 October 2013
17. Compare two databases using T-SQL: / Transact-SQL /; ... Method #3 And a further enhancement which lists the different datatypes, is_nullable, maxlength and collations side-by-side: -- all columns side by side SELECT t1.TABLE_CATALOG AS [DB1_Name], t2.TABLE_CATALOG ...; Created on 24 September 2013
18. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... by checking the datatypes for each field in the concatenation string: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + CONVERT(VARCHAR(4), rm.[Capacity]) + ', ' + rm.[Type] + ', ' + rm.[DeptId])) AS RoomDetails / ...; Created on 14 May 2013
19. SSIS Skip Rows in Excel Source file: / SQL Server Integration Services /; ... the options in the connection manager will let you skip rows and specify column datatypes. You don't get that with Excel but you can still control the data range. How? My example is that I have ...; Created on 04 April 2013
20. DataTumble - Randomize Data Rows: / Transact-SQL /; ... and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and DataScramble). How? CREATE PROCEDURE [Common].[usp_ScrambleMultivalue] ( @TableName ...; Created on 07 December 2012