Assuming have is required, the following 417 results were found.
-
GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Domain Registrars for domains already registered: http://www.buydomains.com/ http://www.sedo.com/ When you have registered a domain name, please tell us and we will issue you the assigned NameServers to point your domain at (done via your domain...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
longer tender for brand new projects competing with time and cost in order to win the bids. Recently, more and more people have been asking if I can take over a project that has been abandoned by its developer. I've started writing this article because...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
a great idea, I'm just trying something out. The brief was pretty much just "...fast and works with cms articles...". If we have 100 slides then 100 slides of data will need to load at the same time per page. Terrible. Using AJAX (which will have to be...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
website, our webpages display a question mark inside a diamond shape instead of the foreign character. How does it happen? Have I tried the other solutions on the web? I have tried adding the following to my headers: This does nothing: // add these to...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and time spent by staff. There are several...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
between strangers. In our experience they’re favoured by fraudsters. One popular trick is to ask you to prove that you have funds by sending money to a friend or relative via these services and show them the receipt. All they need is the tracking number...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
order forms in duplicate. Right above the signature line was a BIG BOLD WARNING ABOUT LOSS OF DATA and “Check this box to have your data backed up for $75. Then, I’d charge them $150 for “forensic data recovery” with “no guarantees” – while recovering...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
404: Page Not Foundhttps://joellipman.com/component/content/article/404.html?catid=50&Itemid=165
Sorry, but the content you requested could not be found. It is possible that you have followed an out-of-date link or incorrectly typed an address. We have revamped this website as of September 2015 and tidied up some of our URLs. Some sections will...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
As with all Joomla articles and files, you need to check that they have been published and approved. Sometimes you don't have to and it's all automatic, but if they're not showing: Check that they're in the right section and category Check that they...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
we connect to the datasource directly using our Windows Credentials. For the SSRS server holding our report, we do NOT have an unattended service account. The report uses a shared data source which stores the credentials, ie. A sql authenticated user...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
First getting the messages relating to this chat: You will need a connection that has the necessary scope(s). Note that you have to do this as the super admin to get organization level messages. But in ths example below, we're going to query a message...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have proposed stupid extensive solutions when all you need is one command-line. Why? Working with programming languages, I often...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
which is to open a command prompt and to type "ipconfig /flushdns" then "ipconfig /registerdns" and the connections would have been restored. As I love automation and reducing processes to single-click fixes, I made this teeny tiny program to run the...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How? The first note is that there is something...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine the code or find a some short codes that will do the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
what the documentation that says "This task can be used in the following events", effective as of today October 19, 2020, I have not found a place you cannot use this deluge script. The ZC_SUBFORM_250 error is because I am trying to assign the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *