Assuming already is required, the following 93 results were found.
-
List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html
(note that AccessLevel is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
Flow Items > Tick the "For Each Loop Container") Add the Data-Flow to the container (or drag into the container if it already exists) Edit the ForEach Loop Container (or double-click on it) Under General, give it a reasonable name of your choice Under...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
to what I googled (probably a bad sign but time is ticking and no one has forever). Situation: I have a report which I've already completed and pretty chuffed with. It shows the details on a user-specified room taken from a room bookings system. Below...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Maybe the answer could be in that mess of a Microsoft article but this I can already do and it didn't quite do what I wanted. I ran out of time (all MORNING!) so I went with solution #2 (above) and added the OR clause to all my dataset queries and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
query just to check with the end-user: Note that this an ordinary report as per usual. It will act as a confirmation page (already holds the parameter passed to it from the previous page and that it will pass to the next page which executes the stored...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the end-user would contact us and we would look up this error code. Instructions on setting up an Oracle Stored Procedure I already wrote an article on this so please refer to SSRS Parameters in Oracle Stored Procedure. Oracle: Grant another user...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to the SharePoint site... It doesn't. The following steps show you how SharePoint will open a shared calendar if you don't already have it in your Outlook 2007. Similar to you opening a shared calendar, the sharepoint calendar will sit separate to the...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
(Tools > Options) but to no avail. How? The way to change this was: Connect to your Team Foundation Server (for me this was already done) Go to File > Source Control > Workspaces Edit... the workspace which is causing the problem Change the local folder...
- Type: Article
- Author: Joel Lipman
- Category: Team Foundation Server
- Language: *
-
program found in the IE6 download to run IE6. It will return v7 on the "about" dialog but I felt this was because I already had IE7 installed. Note that a lot of websites have reported that installing IE7 standalone breaks the IE6 standalone and none...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
name for the key. We'll call it Foo. Go to HKEY_USERS\Foo\Software\Microsoft\Windows\CurrentVersion\Policies If it does not already exist, create a key called Explorer Create a new 32-bit DWORD value inside the Explorer key/folder and name it NoDrives...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Windows Live Mail Error ID: 0x8DE00005 How? I don't remember the time when the Microsoft website became helpful but as they already have an article on this, I'm going to do a bunch of screenshots: The error is that I can't receive/send messages on this...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
a Logitech keyboard for Windows - keys switched for the Mac but reverted for the biscuit box). Running MS Windows 11 pro already. Wifi was ok to connect and my Microsoft Office apps, well it's a Windows box so no issues there either... Webcam and...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
to GRANT permission to execute this function for whatever user/system account that will run it. -- Drop the function if it already exists IF OBJECT_ID ('ufn_DataJumble', 'FN') IS NOT NULL DROP FUNCTION ufn_DataJumble ; GO -- Create user defined function...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
website. Thinking outside of the box Hooray for you non-sheep! This is what I've come up with: -- Drop Stored Procedure if already exists IF OBJECT_ID ( 'dbo.usp_MakeTableTemp', 'P' ) IS NOT NULL DROP PROCEDURE dbo.usp_MakeTableTemp; GO -- Create Stored...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
in uppercase SET @Ret=@Text END RETURN @Ret END Examples of what this script does: Reminder: The script only affects data already in UPPERCASE. Change the IF (UPPER(@Text)=@Text COLLATE Latin1_General_CS_AI) line if you want to change this. Original...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
environment thanks partly to group policies: Need to run with elevated permissions which requires UAC prompt (despite being already logged in, this is the same user but re-prompted for credentials) Cannot run System Registry (not even DOS REG Query!!!)...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
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 software for our work computers. We have SQL Server Management Studio (SSMS) as well for our SQL Server...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you already setup a connection to your database under the SQL Development section. Export/Import happens under the Server Administration...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
the LocalSettings.php file in the web root folder where your MediaWiki is installed: $wgFileExtensions[] = 'swf'; or if you already have an array, just add it to the end: $wgFileExtensions = array('png', 'gif', 'jpg', 'jpeg', 'doc', 'ppt', 'xls', 'mpp',...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB