List last modified files using FTP Command-linehttps://joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 Type dir -S . temp.txt which will output all files including subdirectories to temp.txt in your local working folder. Additional Notes the switch "-S" does not work on certain systems (at least not accompanied with the command to output to a local file....

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

SSRS No Delay for First Report of the Dayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 first report of the day. Why? Take any SSRS report, if one of us was the first to run it on that day, it would take an additional 60 seconds to get with it and display the report. Any subsequent running of the report loaded it almost immediately. How?...

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

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

24 September 2015 #3: By grouping (NOT recommended for more complex queries): SELECT COUNT(my_field) FROM my_table GROUP BY my_field; Additional: Not sure why method 3 is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check...

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

Zoho Inventory Template Issue: First Page is Blankhttps://joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 Resolution Find the CSS attribute "page-break-inside" If this is set to "avoid", then change it to "auto" Additional You may also need to remove the child tags of the table specifying the above CSS.

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

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 lookup options (not selected items) for each r_EntryID in l_AllowedEntries { input.myLookup:ui.add(r_EntryID); } Additional Note(s): If removing elements, even if you are using Creator v5, use removeElement() and NOT remove() which got me stuck for a...

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