Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 to center, changed "Display As" to "Image", and set the image dimension to "64 x 64": I should end up with something like this: Create a query table with images Irrespective of where the images are hosted, you can now write a SQL (more precisely an...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Search and Replace in a MySQL Databasehttps://joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SSRS Expand specific drilldown by defaulthttps://joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Trim in T-SQL and SSIShttps://joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = @EmployeeStr -- yields 0 -- After (replacing the = with LIKE) SELECT COUNT(*) FROM Employees WHERE Employee.ForeName LIKE @EmployeeStr -- yields 1

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Leap Motion and AR Dronehttps://joellipman.com/articles/_other-misc/quadcopters/leap-motion-and-ar-drone.html

17 May 2013 Motion is a USB gesture control device you can connect to a computer which behaves much like a mouse or trackpad but in 3 dimensions. Available July 2013 for public release (you can pre-order if you like @ https://www.leapmotion.com/). It's noted for...

• Type: Article
• Author: Joel Lipman
• Category: Quadcopters
• Language: *

SSRS Display question mark when date is blankhttps://joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if there is no date to populate the field. Why? At the moment, the expression in there is something...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SITS: XET format for Export not availablehttps://joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 format XET, the system has never heard of it. Why? To test the XET I created, I want to see what the resulting XML will look like so that my post-staging phase can be developed as it will know what the data and label fields look like. How? I had this in...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Error 404 Component Not Found when enabling SEF URLshttps://joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 So I'm getting an error like this: The requested page can't be found. An error has occurred while processing your request. You may not be able to visit this page because of: - an out-of-date bookmark/favourite - a mistyped address - a search engine that...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

MySQL Transactions in PHPhttps://joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

14 December 2016 mysqli->begin_transaction() requires PHP 5.6 and above. For lower versions you can issue the MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK") Important note: Our tables must use an engine...

• Type: Article
• Author: Ike Francis
• Category: MySQL
• Language: en-GB

Make bootstrap carousel responsive to swipehttps://joellipman.com/articles/web-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

14 December 2016 A quick reminder on how to make the carousel in bootstrap compatible with touch devices like smartphones and tablets. Why? Feed back was that the user was unimpressed with the image slideshow. You have to tap on the left and right symbols... How? Some...

• Type: Article
• Author: Joel Lipman
• Category: Bootstrap
• Language: *

Change div height to fit contenthttps://joellipman.com/articles/web-development/css/change-div-height-to-fit-content.html

19 December 2016 A quick article on how to get a div layer to increase height based on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines When I shrink the browser, I get a heading like this:...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Display a thumbnail of a Google Drive videohttps://joellipman.com/articles/google/display-a-thumbnail-of-a-google-drive-video.html

13 November 2018 // where is the file id The shareable link to the file will be something like: https://drive.google.com/file/d//view?usp=sharing // to link/display in apps: https://drive.google.com/thumbnail?authuser=0&sz=w320&id= // redirects to something like:...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Zoho Deluge - Get User Timezone, Country and Locationhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-user-timezone-country-and-location.html

03 June 2019 Location]: v_Url = "http://api.db-ip.com/v2/free/"+ zoho.ipaddress; v_Response = getUrl( v_Url ); Returns something like: { "ipAddress": "147.188.254.175", "continentCode": "EU", "continentName": "Europe", "countryCode": "GB", "countryName": "United...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge - Pad with leading Zeroshttps://joellipman.com/articles/crm/zoho/zoho-deluge-pad-with-leading-zeros.html

07 February 2020 startingNumber) { return leftpad(toString(input.startingNumber), input.finalStringLength).replaceAll(" ", "0"); } This looks like pretty old code and not wanting to cause offence, it isn't the JavaScript style or chain I like which appends the functions...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge: Nested Catch Statementshttps://joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 { r_GeneratePDF = invokeurl [ url: v_EndpointServer3 type: POST parameters: m_Html headers: m_Headers3 ]; } } This feels like really bad practice try { v_Test1 = "Foo"; info v_Test1.toLong(); } catch(e) { info "Couldn't convert 'Foo' to an integer";...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 but the client wants the email to be prefilled in the field as soon as a contact is selected. How? This needs to behave like a formula field which changes and displays before saving the record. At time of print however, I can't get a formula field to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 trade dress may not be used in connection with any product or service that is not JoelLipman.com's, in any manner that is likely to cause confusion among customers, or in any manner that disparages or discredits JoelLipman.com. All other trademarks not...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Privacy Policyhttps://joellipman.com/static-items/privacy-policy.html

30 May 2009 allow web applications to respond to you as an individual. The web application can tailor its operations to your needs, likes and dislikes by gathering and remembering information about your preferences. We use traffic log cookies to identify which...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: en-GB

Add the website name to the page title in Joomla!https://joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

06 September 2009 are some instructions on changing the page title in Joomla! CMS to display both the actual page title and other stuff. As I like doing this for this particular website (my personal one) in every version of Joomla it's been upgraded to, I've noticed some...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 Virtual Hosts I used to have an account with 1&1 (oneandone.co.uk) and I would strongly urge Joomla developers to avoid them like the plague. They have been less than helpful and when I only had one Joomla site with them, they still would block me...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB