Search - Joel Lipman .Com

1. ZohoCRM: Process all records of a module: / Zoho /; ... thought of an alternative that I now use frequently in client systems. How? The gist is that we add a checkbox called "Processed" which will have a datatype Boolean. Our function will then loop ...; Created on 24 August 2021
2. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent ...; Created on 03 June 2021
3. MySQL: Count occurrences of words in a column: / MySQL /; 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 ...; Created on 12 March 2020
4. Joes Word Cloud (JWC) Download: / Downloads /; ... Mon, 20th Sep 2010 1.0.0 - Created according to brief (automated, using most frequent words) - Added Joomla Admin Panel option: Scan Joomla! articles - Added Joomla Admin Panel option: Scan K2 articles- ...; Created on 07 September 2015
5. Things to Check if Joomla Password Reminder email not being sent: / Joomla /; What? A quick article on a frequent question I get asked. This refers to an issue within the Joomla CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things ...; Created on 09 May 2013
6. SSIS Convert a string into a date: / SQL Server Integration Services /; ... || (LTRIM(ContributionValue) == "") ? "0.0000" : TRIM(REPLACE(ContributionValue,",","")) My Most Frequent Fix: The data files I have to work with are rarely consistent. On some rows the date ...; Created on 14 March 2013
7. MySQL day of week ending on Friday: / MySQL /; What? Week Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. ...; Created on 26 April 2012
8. Joes DNS Correction (JDC): / Product Documentation /; Ever had this? Your colleagues are connecting fine and your IT service desk say everything is functioning normally and it's just YOU! Script Function If you are on a network that frequently ...; Created on 25 November 2011
9. The ReportServer Database: / Databases /; ... Frequent -- Top 5 Most Frequent: SELECT TOP 5 COUNT(Name) AS ExecutionCount , Name , CAST(CONVERT(CHAR, DATEADD(millisecond, AVG(DATEDIFF(MILLISECOND, TimeStart, TimeEnd)), '00:00:00'), 121) ...; Created on 08 August 2011
10. Basic Webpage Controls with JavaScript / COM: / AutoHotkey /; ... by dragging the curser over the webpage. Frequently Asked Questions What is a pwb? - A variable that contains a pointer to the web browser object (Internet Explorer). Here ...; Created on 05 July 2011
11. Joes Quicklist Weblinks (JQW): / Product Documentation /; ... Switch "STOP Thumbnail Service" to "YES" Logout For frequent additions (What I do on my own site): Create/refresh a copy of your Joomla website. Add the weblink on your COPY site. Switch ...; Created on 03 July 2011
12. Alternate row background colour in Reporting Services: / SQL Server Reporting Services /; ... is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on each cell to specify this so just do it to the first column then bring up the properties ...; Created on 04 February 2011
13. Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparison: / Joomla /; ... should. It's templates are ok but it's its extensions for which I signed up for. As well as helping another subscriber. There were issues with some modules but the forum is frequently administered and ...; Created on 08 April 2010
14. Creating a Top 10 chart with less code: / Personal Home Page /; ... that the most frequent is at the top of the list print out each row with the number of times that particular data appeared in a row My old method was to: Select distinct column1.table1 ...; Created on 18 February 2010