Assuming while is required, the following 92 results were found.
-
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 mediawiki articles Page ID, Title, Content, Category...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
null, "rss"); String title = null; String link = null; String date = null; String desc = null; List items = new ArrayList(); while (parser.next() != XmlPullParser.END_DOCUMENT) { if (parser.getEventType() != XmlPullParser.START_TAG) { continue; } String...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
below serves as a checklist to ensure I don't release an app that only displays maps to myself (again). Why? This took me a while to figure out so hopefully this will help others. How? The gist is that I was using the Test SHA1 when adding allowed...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
the phone and finishing on the "Get Started" (including Touch ID). Ensure your old phone's iOS is fully updated. (I did this while the phone was NOT connected to the computer, ie via the Settings > General > Software > Update option) Right-click on your...
- Type: Article
- Author: Joel Lipman
- Category: iOS
- Language: *
-
TextInfo textInfo = cultureInfo.TextInfo; if (!buffer.EndOfRowset) { // loop through each row while (buffer.NextRow()) { rowCount++; // loop through each column for (int x = 0; x...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
person doing most of the jobs suddenly left or moved to another team. To exclude the rest and only show "Series1" Took me a while to figure this out but modify the above statement along the lines of SELECT _SMDBA_.Incident.[Incident #]...
- 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: *
-
storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
complete as per the image below (changing the log-on username to your own): The downloading of all your folders will take a while so don't panic if you find empty folders. Doing a 'send/receive' will bring up the dialog showing its progress. Source:...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
left of the spacebar and not the Alt Gr often found on the right of the spacebar) then press the numbers in the numeric pad (while still holding down the ALT key), then let go of the ALT key. Remember: This will not work with the numbers at the top of...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
COUNT(t1.column_value) AS Count FROM ( '; -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN IF @myCounter=0 PRINT @SqlToExecute; ELSE PRINT ' union all ' + @SqlToExecute; SET @myCounter =...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
myTable varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @TableToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + CAST(@p_Value AS VARCHAR) + ', ''' + @TableToProcess + ''',...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
AS VARCHAR(30)))), 1, LEN(@OrigVal)); END ELSE BEGIN -- Loop through the characters passed WHILE @LoopCt
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
I needed the following stored procedure (or part of). What? This will copy a given table into a temporary table all the while maintaining the structure and data. Thinking inside of the box I think everyone suggests the following (or at least the idea...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
myColumn varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @ColToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + LTRIM(@ColToProcess) + ' COLLATE ' + @p_UseCollation + ',...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
CURSOR OUTPUT', @UpdateCursor OUTPUT SELECT @NumberLeft = SUM(1) FROM #Scramble FETCH NEXT FROM @UpdateCursor INTO @Data WHILE @@FETCH_STATUS = 0 BEGIN -- OPEN RandomID SET @random = CEILING(RAND()* CONVERT(VARCHAR(MAX),@NumberLeft) ) SELECT @ChosenID =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
1, LEN(@OrigVal)); END ELSE BEGIN IF ISNUMERIC(@OrigVal)=1 BEGIN SET @NewVal = ''; -- Loop through the characters passed WHILE @LoopCt
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Yes by far. Fast, quick to setup and a big fat refresh button for the executives. SQL query returns individual items while Excel allows drag and drop grouping/drilldown pivot tables. Have managed to get this working with SQL Server, Oracle and MySQL...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
contents background disappears and reveals the overall background (blue) making the text very hard to read. Why? Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but when visiting a long page, it would...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *