Set up Desktop SlideShow in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 it doesn't seem to remember which folder you selected. At home, this would be a breeze, but that's because I don't implement group policies at home. Why? We get problems with this because none of our staff are full administrators of their local...

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

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 Mail to User” is set to “Yes” Test Joomla can message: Login to your Joomla Admin Panel Create a TEST joomla user group containing you (or if “Super Users” is a tiny group then use these) Navigate to Users > Mass Mail Users > Select the group you just...

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

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 Specifies information to be used by the application (must go inside annotation) attribute Defines an attribute attributeGroup Defines an attribute group to be used in complex type definitions choice Allows only one of the elements contained in the...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 order - Enhancement: Changed default settings (matches personal site) - IMPORTANT: Cannot use "Public" usergroup to generate images!!! - Date Uploaded: Fri, 21st Dec 2012 2.0.8 Experimental- Parameter: Navigation Font: Webdings Server-side (uses...

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

Zoho CRM: Get Unique Values of a Text Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 developers, is that "two heads are better than one" does apply more than we think. A colleague of mine suggested adding a group by to the query which works (tested with both the keyword 'distinct' and without it with no difference in the response): //...

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

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 have no afiliation with these and I myself don't put any copyright information on the end product. I needed a program to: + Group all the data by a specified column + Generate interactive flash charts The program was intended to chart EventViewer...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 + ' COLLATE ' + @p_UseCollation + ', ''' + LTRIM(@ColToProcess) + ''', COUNT(*) AS Count FROM ' + @p_SearchTable + ' GROUP BY ' + LTRIM(@ColToProcess) + ' COLLATE ' + @p_UseCollation; INSERT #ListDistinctValuesAndCounts EXEC(@SqlToExecute); FETCH NEXT...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 e2 LEFT JOIN DMExtractReferenceTable r2 ON e2.CodeType=r2.MapIn -- THIS IS THE LINE CAUSING THE PROBLEM!!! WHERE e2.ID=e1.ID GROUP BY e2.ID,r2.MapIn ) AS MatchingRecordsCount FROM DMExtractEmployeeTable1 e1 LEFT JOIN DMExtractReferenceTable r1 ON...

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

CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 have no afiliation with these and I myself don't put any copyright information on the end product. I needed a program to: + Group all the data by a specified column + Generate interactive flash charts The program was intended to chart EventViewer...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 Improvement SELECT COUNT(1) FROM (SELECT DISTINCT my_field FROM my_table) T1; Ones that didn't work for me: Method #3: By grouping (NOT recommended for more complex queries): SELECT COUNT(my_field) FROM my_table GROUP BY my_field; Additional: Not sure...

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

Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 first 10 rows of this array (if we are doing a top ten) My new method is: SELECT column1, COUNT(*) AS CountOrder FROM table1 GROUP BY column1 ORDER BY CountOrder DESC LIMIT 0,10 PHP script to loop through the results of the above query Display the value...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 a support technician to this project (supply Contact details: email/phone) Training / Handover (if handing over to another group / developer) Discuss training rates (same as development - per hour) Documentation: Modes of documentation (forums, word...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 Matrix Tablix: We want all rooms on the left and the time along the top. We select a matrix because this will automatically group the rows by room (you need to do this anyway otherwise it will look a bit like a staircase of bricks). 4. Design the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 site written from scratch, and it's purpose was to manage Staff and Students within the Additional Learning Needs group. These are staff who take lecture notes for people of all disabilities and assist the students for the duration of their course. It...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 Folders Properties folders Fonts control fonts Fonts Folder fonts Free Cell Card Game freecell Game Controllers joy.cpl Group Policy Editor (XP Prof) gpedit.msc Hearts Card Game mshearts Help and Support helpctr HyperTerminal hypertrm Iexpress Wizard...

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

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 ON Catalog.ItemID = ExecutionLog.ReportID WHERE ExecutionLog.TimeStart BETWEEN @DateFrom AND @DateTo AND Type = 2 ) AS RE GROUP BY Name ORDER BY COUNT(Name) DESC , Name

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 u ON u.UserID=s.StaffUserID INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID INNER JOIN Teams t ON t.TeamID=s.TeamID GROUP BY s.LogID ORDER BY s.TeamID, u.Username, s.DateTimeCreated, Resource Note there is no WHERE clause because we're going to...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 "ReportName" into the field that says "Columns". Right-click on the grey left margin and select "Insert Row" then "Outside Group - Below". Delete the row with the left parenthesis Click on the dropdown of "Data" and select "TimeStamp". Click in the left...

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

Print Directory Contents to a Filehttps://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 to list. Instead of C:\windows\system32\cmd.exe, I could have used %Comspec% or even %windir%\system32\cmd.exe but with some group policies, you will get an "access denied" message. If you don't have a C:\windows folder, then find your "cmd.exe" program...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 chktbls ON chktbls.Tablename = ST.name JOIN SYS.schemas SCh ON ST.schema_id = SCh.schema_id WHERE ST.name 'SearchTMP' GROUP BY ST.object_id, SCh.name + '.' + ST.NAME ; UPDATE @SQLTbl SET SQLStatement = 'SELECT * INTO SearchTMP FROM ' + Tablename + '...

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