Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 SSLCA specifies the path to a file with a list of trust SSL CAs. SSLCERT specifies the name of the SSL certificate file to use for establishing a secure connection. SSLKEY specifies the name of the SSL key file to use for establishing a secure...

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

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

05 July 2011 = $00000400 Const DT_NOPREFIX = $00000800 Const DT_INTERNAL = $00001000 Const DT_EDITCONTROL = $00002000 Const DT_PATH_ELLIPSIS = $00004000 Const DT_END_ELLIPSIS = $00008000 Const DT_MODIFYSTRING = $00010000 Const DT_RTLREADING = $00020000 Const...

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

Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 AS VARCHAR(10)) + ')' END FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName ORDER BY ORDINAL_POSITION FOR XML PATH ('') ),1,1,'' ) + ';'; EXEC(@TableDeclaration); -- Get First Column Name SET @ColName=( SELECT COLUMN_NAME FROM...

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

Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 $user and $password - these are the database and login credentials. $ftp_user and $ftp_pass are the ftp credentials. $log_path and $tmp_path should also be updated. $robots - set this to 'noindex, nofollow' (we don't want google to index our test site)....

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

Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 2008 R2 Under the Actions tab, Click on New... Leave "Action" as Start a program for Program/Script, Specify the command path which is usually %windir%\System32\cmd.exe Add arguments in format /c start "Task Name" "Full Path of Program", for example: /c...

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

SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 to the scope of the package) called "SourceExtractFile" and give it the data type "String". Set the Value to the full path and the first file including its extension (eg. "C:\Temp\SourceFiles\File00001.txt" - although I used a network share without any...

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

Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 prefix) Instead of deleting, I change the existing menu item alias from "about-us" to "about-us2" as well as any similar `path` value. Change the item you created in step #2 (eg. "about_new" to "about-us"), also change the "path" value to match as this...

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

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 overwrite the code you previously pasted with the below (note the file format for Excel 97-2003): Sub Splitbook() Dim xPath As String xPath = Application.ActiveWorkbook.Path Application.ScreenUpdating = False Application.DisplayAlerts = False For Each...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 #1: The following command on a cron job: // not recommended: /usr/bin/mysqldump -u dbusername -p'dbpassword' dbname > /path_to/backup.sql // recommended: using credentials stored in external file: mysqldump --defaults-file=/path-to-file/.my.cnf my_db >...

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

How to put MediaWiki into Debug modehttps://joellipman.com/articles/cms/mediawiki/how-to-put-mediawiki-into-debug-mode.html

22 October 2009 to log everything that WikiMedia does: $wgDebugLogFile = '/home/username/public_html/wikidir/logfile'; IMPORTANT NOTE: The path above should be the exact full path to the wiki directory under your account.

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

Joomla Development: Possible XML Filtershttps://joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

17 October 2013 that may not exist in a base 64 encoded string. STRING Removes HTML HTML Allows basic HTML ARRAY Forces value to be an array PATH Forces value to be a file path USERNAME Forces value to only contain characters allowed in the selection of a Joomla...

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

Community Builder in Joomla Vulnerabilityhttps://joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 detail as I test each one (11.11.09): administrator/components/com_comprofiler/plugin.class.php variable mosConfig_absolute_path http://secunia.com/advisories/14337 allow_url_fopen = Off Keywords: Hacking, XSS & SQL-Injections.

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

Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 Index Say you want to get the value of the 1st element in the 1st form, which will be the Search for Keywords Input Box. The path would look like this (a collection of objects starts at 0): Code: document.forms[0].elements[0].value Now if you want to...

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

How to change local folder for TFShttps://joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 folder; once done close the dialogs click on the TFS icon in Source Control Explorer and check what it says next to "Local Path" (for me this said the name of the local folder that I specified just before)

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

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

19 July 2012 will get an "access denied" message. If you don't have a C:\windows folder, then find your "cmd.exe" program and change the path in the above instructions accordingly.

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

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

08 October 2012 WHERE STY.name in ('varchar','char','nvarchar','nchar') AND SC.object_id = ST.object_id ORDER BY SC.name FOR XML PATH('') ) FROM SYS.tables ST JOIN @CheckTableNames chktbls ON chktbls.Tablename = ST.name JOIN SYS.schemas SCh ON ST.schema_id =...

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

Adding a selectable background to a Yootheme templatehttps://joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 0 0 no-repeat; } If using an image, create a folder and add the image matching the path in the previous step: \templates\\images\background\ambientturquoise\ambientturquoise.jpg Test by logging into the Joomla Admin Panel > Extensions > Template Manager...

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

Error 1065: Query was Emptyhttps://joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....

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

Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 Joomla! Admin Option: Module width. - Corrected division by zero if no words found (?) sets to 1. - Now includes absolute path for word link (JURL::base()). - Date Uploaded: Sat, 14th May 2011 1.6.2- Modified core script for PHP4 compatibility. - Date...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 = ''; 2a. Specify the location of your private key and token file Here you need to enter the relative or absolute path to your private key, this should be the JSON file that you generated at Google's developer console - service accounts section. It also...

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