SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 in the script: Build CS file in solution Check-in file/change Build Project Check you have a compatible Global Assembly Cache (GAC) Utility C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin\gacutil.exe Note: Currently SSIS/BIDS only supporting...

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

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

05 July 2011 Setup Wizard inetwiz IP Configuration (Display Connection Configuration) ipconfig /all IP Configuration (Display DNS Cache Contents) ipconfig /displaydns IP Configuration (Delete DNS Cache Contents) ipconfig /flushdns IP Configuration (Release All...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 and click on the "Submit" button. Click on the "General" tab, the RocketTheme instructions say that you should "Purge the cache" so click on the "Run Now" button which I found myself doing at lots of stages in this installation process. So note where it...

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

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 WHERE `id`='1'); INSERT INTO `my_new_database`.my_prefix_newsfeeds ( catid, `name`, alias, link, published, numarticles, cache_time, ordering, rtl, access, `language`, params, created, created_by, metadata ) SELECT catid, `name`, alias, link, published,...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 HDI_DI_SETITEM = $0040 Const HDI_ORDER = $0080 ;#End Region ;#Region GetDCExFlags Const DCX_WINDOW = $00000001 Const DCX_CACHE = $00000002 Const DCX_NORESETATTRS = $00000004 Const DCX_CLIPCHILDREN = $00000008 Const DCX_CLIPSIBLINGS = $00000010 Const...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 city names - Map: use map touch listeners - Map: timeout requests on idle - News: localized on map (use API) - News: cache for map (+offline mode) - News: cache for later reading - Pilot: view top configurations for best distance/duration - Pilot: view...

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

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

07 September 2015 Opens In: Rokbox (only works if installed) - Modify Parameter: Category: List Only weblink categories - Removed Parameter: Cache (uses local images if service is switched off) - Removed Parameter: Inline Images - Removed Parameter: Force No Borders -...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 modules/plugins) and managed to recreate this error. I disabled half of these but still got the error. Cleared the expired cache but still got the error. I then uninstalled half of these (including Kunena and Agora forums), specifically database...

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

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

08 August 2011 int NOT NULL Milliseconds spent rendering the report. Source int NOT NULL Source of the report exection (1=Live, 2=Cache, 3=Snapshot, 4=History) Status nvarchar(32) NOT NULL either rsSuccess or an error code; if multiple errors occur, only the first...

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

Proposed Budget i3 PC under £200https://www.joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 System: Proposed for January 2013 (5 suppliers) Processor Intel Core i3 3220 Dual Core CPU ( 3.30GHz, Socket 1155, 3MB Cache, Ivy Bridge, 55W, Intel HD Graphics 2500, Advanced Vector Extensions) - Intel £88.50 Motherboard AsRock H61M-DGS Motherboard...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 v_FileDownloadUrl = v_DownloadUrl + "?filepath=/" + v_FileInternalName; // // download the file into cache r_FileDownload = invokeurl [ url :v_FileDownloadUrl type :GET ]; // // Important: use setParamName on the response...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 denied Run sudo npm install -g zoho-extension-toolkit When trying zet run: Error: Cannot find module 'portfinder'. Run.a npm cache clean --force. I didn't bother resolving this other than having a terminal with the command zet pack ready every time...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 given just one ticket reference; will create or update the images associated in the subform: void Standalone.fn_DownloadAndCacheAttachments(string p_TicketRef) { v_TicketRef = ifnull(p_TicketRef,""); c_TicketRecords = QC_Report_Table[Ticket_Number ==...

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