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

19 July 2012 Click on "New..." Enter the New Action as per the following: Action: - Give the action name a memorable name (eg. "Print Directory Contents To File") Application: - Type the following c:\windows\system32\cmd.exe /c "dir %L /b >...

• 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 to put them in one place on a website I've bookmarked (my personal site :c) My own with Typos Note that the below only prints out the SQL query to copy and paste into your SQL administration software. You can put a distinct on it (not forgetting the...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 'varchar', 'nvarchar', 'text', 'ntext') AND TABLE_SCHEMA=@p_TableSchema ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; PRINT ' SELECT DISTINCT t1.column_value COLLATE Latin1_General_CS_AS AS Value, MIN(t1.column_source) AS Source,...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 > System Tools > Disk drive cleanup tool. Check Windows Eventviewer for all errors. Versions of Microsoft Office installed? Printing: Can you print any other documents? Have you tried printing to another printer? Can you print from any other...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 multiple bookmarks. Why? This use-case is for a customer who simply wanted a quote template to be rendered for PDF or print format. I have another article for a different client who wants a pretty advanced HTML template (well it's a HTML table with...

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

Access MySQL databases using Oracle SQL Developerhttps://www.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 then the supplier will implement restrictions and trial based versions. Oracle SQL Developer is currently free at time of print (01-FEB-2013). I also need to use Oracle databases in my day job so the Oracle SQL developer is already a pre-approved...

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

Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

18 August 2022 { v_Url = "https://zohoapis.com/crm/v2/settings/inventory_templates/" + v_TemplateID + "/actions/print_preview?record_id=" + p_QuoteID + "&print_type=pdf"; f_FileRequest = invokeurl [ url :v_Url type :GET connection:"zcrm" ];...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 Siri or Ask Google where it includes the keywords in a "Search the web..." task. ChatGPT by OpenAI is viral at the time of print and although the solution below only connects to the OpenAI API, it is not currently connected to ChatGPT. The plus side...

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

ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 to a server which reads/writes information to your Zoho instance via API. No need for the Zoho Widget SDK. Why? At time of print, I felt the documentation was a little sparse on how to connect a JS widget to the data held in Zoho Creator. Having this...

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

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

20 November 2012 working directory is the current directory. Type lcd to confirm what the local working directory is (when you download or print output, it will save to this folder on your computer). Can type lcd if you want to change this (leave blank to simply display...

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

Free Translator API using Googlehttps://www.joellipman.com/articles/google/free-translator-api-using-google.html

08 January 2013 So this is a quick article to get your Google Translation services working with your website. Why? At time of print, Google now charge for every 2,000,000 characters (2 million) every month. Microsoft's Bing has added itself to the fray pretending to...

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

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

15 November 2018 details and the header of the product line items table would display on the first page, the product line items would then print on the second page, with the terms and conditions or small print notes on a third page. How? Printing to PDF or saving as a...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 previous database. New db user and password added to the new database. Downloaded and uploaded the latest Joomla (at time of print this is version 5.2.3) as a ZIP Extracted this to the new 2025 production folder I created earlier Pointed a...

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

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 is selected. How? This needs to behave like a formula field which changes and displays before saving the record. At time of print however, I can't get a formula field to retrieve a field from another CRM record. // freezes the GUI? ZDK.UI.freeze(true);...

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

Copyrighthttps://www.joellipman.com/static-items/copyright.html

30 May 2009 redistribution or reproduction of part or all of the contents in any form is prohibited other than the following: you may print or download to a local hard disk extracts for your personal and non-commercial use only you may copy the content to...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• 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 count the number of times each data exists, sort it in reverse order so 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...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 remote as well as the MySQL database. BIDS is on the client machine. Download and install the MySQL ODBC driver (at time of print v5.1) Visit http://dev.mysql.com/downloads/connector/ Click on "Connector ODBC" Download a version suitable to your system...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 two databases, one with your Joomla 1.5 old content, and one following a fresh install of the latest Joomla (at time of last print: 2.5.6 - preferably no sample data pre-installed). Change the database names in this script (including the new random...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 the object in the cell a block (which I made big and then didn't allow cell to increase/decrease height). This way when it's printed out (backgrounds won't print by default) the occupied blocks will show up. =Switch(Fields!Status.Value="", "#ffffff",...

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

Newbies guide to be the local computer guyhttps://www.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 up a client base and get some referalls. Put up a Web site describing your services. It makes you look more legit when you print it on your business cards. Hit up local colleges and post flyers there. If you’re going to market to college students, learn...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *