Assuming note is required, the following 299 results were found.
-
List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html
do I want? Page ID, Title, Content, Category, AccessLevel (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...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
article "Basic Android App using Google Maps and Current Location", this article suggests how to add Map as a sub activity. Note that this article is based on a new blank project which does not include code from the previous example but you can still...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
column B, row 11 up to Column AL, row unspecified - used if I don't know how many rows there will be and if I want them all. NOTE: If you don't use column headings, F1 is the first column of the data range and NOT the first column of the data sheet (eg....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
employee number and the second column will be the remaining data on that row. So I setup my connection manager as follows (note the "Ragged Right" and delimiter as "{CR}{LF}" - my rows to skip is because of the state of my data): Crucial fix here, add 2...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
creating an extract SSIS package intended to take a text file as its source and to populate a database table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
FROM _SMDBA_.Incident WHERE _SMDBA_.Incident.[Group Name] LIKE @GroupName AND _SMDBA_.Incident.[Assigned To Full Name] '' Note that this excludes all the data that doesn't have a matching label. Which can be a major part of your charts if this is a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
This is just a note for me as it took a while to find on the net and even then it was confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
local variable) MDX Check /* For Expression Value. Remember to apply to both ACTION and if you use color change FONT. Note for MySQL solution change 0 to 1. */ =IIF( Parameters!ParameterToCheck.Value"" AND Fields!NOTALPHANUMERIC.Value=0, "Valid", "Not...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
and it would take them to http://ora-00201.ora-code.com/. The Padding Found this in a forum so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the right -- ".ToString" because...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
This is to be applied to the "Fill" expression of the textbox with the field name changed for each cell you apply this to; note that in the following example, "Data_Retrieval" is the field to compare (of all "Data_Retrieval" values) and "Report1" is the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
pay attention to the value in "Value field" (as I kept putting the label rather than the value field) to make this all work. Notes: My convert part of my SQL query is because I had to match the datatype used by our reporting server for the ItemID field...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
design mode of the report (apologies for the red censoring but this allows the images to be used in further demonstrations): Note that a footer exists (contains page number) because if printed, the page would end on a dataset row and continue the next...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
you other options as well as the "copy"). Where's the automation? All-Day Events We use this for leave and this is just a note to say I had to amend the event using Outlook 2007 to tick the checkbox declaring it an all-day event. Recurring Events...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
First off, check there aren't any Update for Windows 7 releases at Microsoft's Windows Update 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...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
more errors (had to return the pen for another and another) as well as the common USB disk storage format tools for Windows. Note that any data on the USB pen is automatically lost, and that if you use rescue programs, you may corrupt the pen in such...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
in MS Windows, you may need to find someone who is. How? As a proof of concept, let's see how to hide a specific drive. Note that this section applies to the currently logged-in user. To restrict other users, see the example after this one: Open the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
worked with my environment, to put them in one place on a website I've bookmarked (my personal site :c) My own with Typos Note that the below only prints out the SQL query to copy and paste into your SQL administration software. You can put a distinct...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
myTable2.DisabilityCode 1 DyNa myTable3.EthnicityCode 1 DñYà myTable3.OriginalSurName 1 DNYA myTable4.RegionCode 4093 -- note how it picked up DyNa as matching DNYA. -- values it did NOT pick up were words like "dayname" and "dynamite". Additional Notes...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Stored Procedure to return counts of records per staging database ** ** table that contains a specific value. ** ** NOTE: This script can be run separate to a stored procedure by ** ** declaring @p_Value and @p_Column and using only the code ** ** from...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB