Assuming option is required, the following 79 results were found.
-
which could be NULL, this was necessary (unless we interpreted dates as strings which we don't want to do): -- SITS Output: Option 1 -- SITS Output: Option 2 -- but not This doesn't tell us if the element is just an empty string or null. This doesn't...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
"Global Check In") Install new Joomla: Install Joomla! CMS v3.4.x with Demo Content (eg. 3rd-party QuickStarts): [Personal Option] Modify admin ID to NOT use a text editor (ie. "Text-editor=None") If you are going to delete an object (eg. contacts),...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
240, "TaxType": "OUTPUT2", "TaxAmount": 48, "AccountCode": 3610, "DiscountAmount": 24, "Tracking": [ { "Name": "Activity", "Option": "ELEPHANT" } ] } ] }, { "Type": "ACCREC", "Contact": { "ContactID": "abcdef01-2345-6789-abcd-ef012345678" },...
- Type: Article
- Author: Joel Lipman
- Category: Xero
- Language: *
-
website addresses enabled. How? Basically you have to include &view=article as opposed to Joomla v1.5.x when the option and id parameters would suffice: - SEF URL http://www.joellipman.com/support/documentation/449-module-joes-word-cloud-jwc.html -...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html
the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. You are to maintain copyright information where credit is due. The scripts and programs are distributed...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
you will first need an SSL certificate. Many hosting companies will either provide (or can offer) "Shared SSL" or the option to buy a "Dedicated SSL" certificate. Shared SSL means that your store will run using two domains your master domain name and...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
for Joomla 2.5.x Note that Joomla versions 1.6 upwards include this as an option in the global configuration settings which you can access using your Joomla admin panel: Template Manager Options Preview Module Positions -> Disabled or Enabled You will...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
The Long Fix Now below are the notes I've had to try and fix this before (personally it was because Microsoft released an optional windows update that fixed my issue. check that this issue isn't being caused by any Windows 7 desktop gadgets. Quit/close...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Time Click on the Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS DATETIME) = d.[Date] --Set the maximum times the Dates cte can recurse OPTION (MAXRECURSION 100) I'd appreciate if you bear with me as I add captions to the below screenshots: Design the Query: So copy...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
t.Time, 108) BETWEEN e.EventStart AND DATEADD(minute, -1, e.EventFinish) --Set the maximum times the Dates cte can recurse OPTION (MAXRECURSION 100) 1. Create a new report: We're going to run the wizard here but without it just add a matrix with [time]...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
this module will NOT generate thumbnails if you select "Public" as the authorized service group. I know it's the default option but you need to select an user group with higher privileges like "Super User". Installation: Install this module ZIP using...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
IT Support. It is a list of the system tools available in the Microsoft Windows OS that can be run from the "Start > Run" option. How? To Access… Run Command Accessibility Controls access.cpl Accessibility Wizard accwiz Add Hardware Wizard hdwwiz.cpl...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
would return all users who don't have an AD account. Using the revisited solution below -> Just leave the "allow blank" option in the parameter properties unchecked SSRS Report Revisted: Had an issue where SSRS report parameters were not resetting to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
weeks start on Monday. Use an EXCEL PivotTable filter: Move your YEARWEEK field to the "Report Filter" section Alternative option... still in progress... Create two cells with the default from and to dates: The formula for the first date of this week...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
accommodate it. Problem #1 If zero rows are returned from the search, then there is no REPORTSTARTTIME. There are two options here: Create another dataset (would have to be the first dataset to load so you would need delete your current datasets then...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
a dropdown populated by a list of all available reports. Why? I want the report to be run with the 3rd and 4th parameter as OPTIONAL. When I leave the 3rd and 4th parameter untouched (=""), the report complains saying "Report #3 parameter cannot be...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
line of my code 3: The third line of my code How? Open a MS-DOS Command Prompt (Start > Run... > Type "COMMAND" > Enter) [Optional] Browse to the folder that contains the file (or use full path in path reference). This example assumes the file is in C...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
we set out to achieve other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results: SELECT DISTINCT StudentDetail COLLATE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF