Joes Quicklist Weblinks (JQW)http://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 like the following error after upgrading/installing this module: Warning: in_array() [function.in-array]: Wrong datatype for second argument in /public_html/modules/mod_quicklistweblinks/helper.php on line 214 This is because you have not selected a...

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

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

05 July 2011 = $A1 Const VK_LCONTROL = $A2 Const VK_RCONTROL = $A3 Const VK_LMENU = $A4 Const VK_RMENU = $A5 ;#End Region ;#Region PatBlt Types Const SRCCOPY = $00CC0020 Const SRCPAINT = $00EE0086 Const SRCAND = $008800C6 Const SRCINVERT = $00660046 Const SRCERASE =...

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

Before and After, Highs and Lowshttp://mail.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 AS Counter FROM ExecutionLogStorage INNER JOIN Catalog ON ExecutionLogStorage.ReportID = Catalog.ItemID WHERE (Catalog.Type = 2) AND (ExecutionLogStorage.TimeStart BETWEEN '01/01/2010' AND '08/01/2011') GROUP BY DATEPART(dayofyear,...

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

Importing Joomla articles to WordPress postshttp://mail.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

16 August 2011 to your Wordpress database Change http://demo.joellipman.com/wordpress/ to the full URL of your WordPress site. If post_type is to be post then append with ?p= otherwise use ?page_id=. Articles: ------ MIGRATING JOOMLA v1.5.# CONTENT TO WORDPRESS v3.2.#...

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

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

24 August 2011 Microsoft Query > select Data Source Specify SQL Query: > Add Tables (not really just "close" this) > click on SQL button > Type/Paste your SQL Query > OK > Click on "Return Data" button Report Type: Select PivotTable Report > OK Design Table: Drag...

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

SSRS Parameters in Oracle Stored Procedurehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 our stored procedure. Here we have called the dataset to launch the Stored Procedure as "SP". You can specify command type and stored procedure name here or you can do this in the next screenshot. Note how all our variables are hidden and cannot be...

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

T-SQL Record Separatorhttp://mail.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 END as 'Start', CASE WHEN t2.Day=t3.Day THEN t2.[Finish] ELSE NULL END as 'Finish', CASE WHEN t2.Day=t3.Day THEN t2.[Event Type] ELSE NULL END as 'Event Type', FROM tblDifference t2 Left Outer Join tblDifference t3 On t2.RowNumber=t3.RowNumber-1 Order...

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

SSRS Dropdown parameter cannot be blank!http://mail.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name ASC NEW: Dataset to populate the dropdown SELECT d1.Name, d1.ItemID FROM ( SELECT Name, ItemID FROM...

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

Joomla article modal with clear buttonhttp://mail.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 and \libraries\joomla\form\fields\media.php. You then refer to it in your XML file where instead of type="sql" use type="modal_article". A usage example is: Just copy & paste the below into a PHP file and include it in your component, the solution is...

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

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

25 February 2013 to create a scheduled task (that won't be scheduled) and a shortcut to that task: Open the Task Scheduler (Start > Run... > Type taskschd.msc > OK) - You will need administrator rights for this step. Click on Create Task... Under the General tab, for...

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

MS-DOS: Copy folders without overwriting fileshttp://mail.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 How? We're going to use MS-DOS because I'm that old. Robust File Copy: Open a command prompt (Start > Run... > CMD > ok) Type the following: ROBOCOPY c:\Sourcepath c:\Destpath /E /XC /XN /XO -- /E makes Robocopy recursively copy subdirectories,...

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

T-SQL: Parse an XML valuehttp://mail.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 AS Gender -- Returns records where GENDER = "Male" More Examples (Note that Event_XML is of datatype XML in the following examples): -- exist() returns 1 or 0 if node exists or not respectively SELECT Event_XML.exist('/STAFF/EMPLOYEE_NUMBER') FROM...

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

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

13 June 2014 the example below. Add a variable (preferably 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"...

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

Basic Android App using Google Maps and Current Locationhttp://mail.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 true); // Get Current Location Location myLocation = locationManager.getLastKnownLocation(provider); // set map type mMap.setMapType(GoogleMap.MAP_TYPE_NORMAL); // Get latitude of the current location double latitude = myLocation.getLatitude(); // Get...

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

Excel - Check a column for values found in another columnhttp://mail.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 boolean false to 0. IsNumber( is a function returning a boolean. Returns false if a cell value has been formatted to a text type. Returns true if the cell value is a number AND the cell data type is numeric. Search( is a case-insensitive search with the...

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

Zoho Deluge - Update Creator from CRMhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 Following the syntax: https://creator.zoho.com/api////form//record/update where ownername is the owner, format is the type (I prefer JSON), applicationName is the name of your app, and form name the Creator form name. If you are on the EU or COM domain,...

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

Zoho Deluge - InvokeConnector and useful snippetshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

23 January 2020 or r_User = zoho.crm.getRecordById("users", v_UserID) but here's the old way of doing this: l_Users= List(); m_UserType = Map(); m_UserType.put("type","ActiveUsers"); r_Response = zoho.crm.invokeConnector("crm.getusers",m_UserType);...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 m_Params.put("organization_id", ); r_Associate = invokeUrl [ url: "https://www.zohoapis.eu/books/v3/invoices/mapwithorder" type: POST parameters: m_Params connection: "zbooks" ] m_Params = Map(); m_Params.put("line_items", );...

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

Windows 10: Shortcut Apps to Settingshttp://mail.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 post on the Microsoft website? Well I could bookmark that page or save myself a click... How? To test any of the following, type the windows key and select "Run..." ( + R). Then type the value in the 2nd column "App to Run" then OK to run it: Settings...

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

Zoho Deluge: Search Records with Special Characters (COQL)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 call it "CRM API v2") Select the appropriate scope(s): ZohoCRM.coql.READ Required! ZohoCRM.modules.{module_name}.{operation_type} or ZohoCRM.modules.all Click Create and Connect You will be prompted to allow permissions, so click on "Accept/Allow" 2....

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