Assuming what is required, and a is required, the following 497 results were found.
-
What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
What A more comprehensive post on some other regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
It took a few google searches until I could find out how to change the default weblinks order. A lot of websites showed how to do this via the admin back-end panel in the advanced configuration... I can't see this panel, there is no advanced parameters...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Applies to Joomla CMS v2.5.14 What? This article is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Download Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
I decided to repair the hull integrity of my DJI Phantom FC40 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
What? So I needed to clear space on a workstation's C drive. There are other programs about and even some built-in to MS Windows that could potentially be used. This is a quick article on how to write an AutoHotkey program to simply return the folders...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
What? An article on the reasoning and steps to generate a dataset using Zoho's ANSI-SQL queries to generate the margins of each invoice in ZohoBooks. Why? We need to create a profits/losses dashboard in Zoho Analytics as we can't control the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
Applies to: Android Studio (Beta) 0.8.6 Google Android Maps API What? I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely on creating an app which opens Google Maps at your current...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
What? A quick article on a function to allow the user to take a photo using their built-in camera or to choose an existing photo from their gallery. Why? I wanted both options to be available to the user and for it to replace a displayed image in an...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
What? A quick follow-on article to my previous article on Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. Why? Connecting to OpenAI ChatGPT is all very well and good, but this forgets what you were talking about after each chat. So it's good for 1...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
What? This article serves as documentation for a module extension I made for the Joomla Content Management System versions 2.5 or later. Why? Could have probably used someone else's. I think there's loads out there but thought making my own to do...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
So I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Why? So let's say my FTP client is not the most expensive (was FREE), nor the most advanced client out there, and I want to know what were the most recent files I modified and uploaded to a site, how do I do it using just Microsoft Windows? How? I don't...
- Type: Article
- Author: Joel Lipman
- Category: File Transfer Protocol
- Language: *
-
What? Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
What? A super quick article to show how to link to the thumbnail image of a Google Drive file, in this case a video file. How? The hardest part of this is to get the Google Drive File ID (which you need for the below). The image link (src) will be as...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
What? A quick article to display a value in a column in a widget in Zoho Analytics. Why? Because I keep forgetting how to do it. How? I've done this for a query that amalgamated all the deals against a deal owner and needed to repeat this for all the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
What? A very quick article to document a HTML Entity decoder in Zoho Creator. Why? Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " and obviously want to display these as decoded HTML entities....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts it to a list, then lets you generate an array or list...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *