Assuming else is required, the following 121 results were found.
-
WHEN INSTR(a.VisitorUAgent, 'NetFront') THEN 'Smartphone' WHEN INSTR(a.VisitorUAgent, 'SonyEricsson') THEN 'Smartphone' ELSE 'Other' END VisitorBrowser FROM custombu_stats_visits a GROUP BY a.VisitorIP ORDER BY a.DateTimeStamp DESC) t1 GROUP BY...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
WHEN 1 THEN 'st' WHEN 21 THEN 'st' WHEN 31 THEN 'st' WHEN 2 THEN 'nd' WHEN 22 THEN 'nd' WHEN 3 THEN 'rd' WHEN 23 THEN 'rd' ELSE 'th' END AS Ordinal, All very posh. Even Microsoft don't have helpful documentation on using SWITCH in an MDX query. Chances...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
and data types into one string SELECT CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN ',' + COLUMN_NAME + ' ' + DATA_TYPE ELSE ',' + COLUMN_NAME + ' ' + DATA_TYPE + '(' + CAST(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(10)) + ')' END FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
character of data irrespective of previous rules SET @Ret = UPPER(SUBSTRING(@Ret,1,1)) + SUBSTRING(@Ret,2,LEN(@Ret)); END ELSE BEGIN -- return the string unaffected if it is not in uppercase SET @Ret=@Text END RETURN @Ret END Examples of what this...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
IF @EndPos>0 BEGIN SET @Value = SUBSTRING(@CommaSeparatedValues, @StartPos, @EndPos-@StartPos) SET @StartPos=@EndPos+1 END ELSE BEGIN SET @ReachedEnd='Y' SET @Value = SUBSTRING(@CommaSeparatedValues, @StartPos, @LengthOfString-(@StartPos-1)) END SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
protocol). The error ONLY appears when I try to "data export" the database. Why? The quick solution for everyone else is to change/reset the password of the connecting database user, but herein lies the problem. When you read my workaround, you'll say...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
If RowIndex=1 HeadingsArrayString:=HeadingsArrayString "|" ThisValue If ColIndex=1 ThisLabel := ThisValue Else If RowIndex1 If ColIndex%ReturnedHTMLTableCols0% LV_Add("", ThisLabel " (" TypeLabel ")" , ThisValue ) ColIndex++ } } Snippets Assume that...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
$parts="(PageTitle RLIKE '[[::]]')".$parts."(PageContent RLIKE '[[::]]')"; } else { $scorepartstring = implode(' + ', $scoreparts); } // Generate the SQL query for your search engine $filter_sql = " SELECT t.PageID, t.PageTitle, t.PageContent, t.Source,...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
of greater than 0 (not blank) and change the attribute of the element so that it's tag displays "xsi:nil=true". If...then...else... will be emulated by the XSLT choose...when...test...otherwise: true true -- yields: assuming value of DATE_OF_BIRTH is...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165
each pancake with freshly squeezed lemon juice and caster sugar, fold in half, then in half again to form triangles, or else simply roll them up. Serve sprinkled with a little more sugar and lemon juice and extra sections of lemon.
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
- Date Uploaded: Mon, 25th Oct 2010 1.2.0 - Fixed compatibility with UTF8 (International) languages. But broke something else... - Added requirement to only take words from Published articles. - Date Uploaded: Thu, 21st Oct 2010 1.1 - Added Joomla Admin...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
address. That’s assuming you are not aware of yours. However, if you know your Kindle email ID, you can skip this part. Else, here is what you need to do. Go to the official Amazon home page that applies to your region. Sign in with your Amazon username...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
of a button with an image as a background. I couldn't get any of these working and they looked more confusing then anything else. My solution is to set up the default button and the image to respond to the ENTER key after you typed something (this is...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
{ If (CurrControl PrevControl) { Gui, Font, cBlue underline GuiControl, Font, %CurrControl% PrevControl:=CurrControl } else { Gui, Font, cBlack norm GuiControl, Font, %CurrControl% PrevControl:="" } } } ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
OutputVar, Result Loop, %OutputVar% { FirstChar:=Substr(Result, 1, 1) IfEqual, FirstChar, `, { Result:=Substr(Result, 2) } else { break } } Return Result } Use as per usual: ValueWithCommas:=FormatAddCommas(NumberWithoutCommas) One taken from the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
HEXString, HEXString RGB:=HEX2RGB(HEXString) CHK:=RGB2HEX(RGB) StringUpper, CHK, CHK If CHK=%HEXString% Return 1 else Return 0 }
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Why? Because for some reason, it wouldn't appear as selectable when I tried using a layout rule. Probably everyone else has figured this out and I'm just late to the party. How? Through the wonders of Zoho CRM Client Script. So we're going to check on...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
//Check 1 row affected by each query if ($a1==1 && $a2==1) { //Everything looks OK, commit changes $mysqli->commit(); } else //Something went wrong. Roll back to before begin_transaction() $mysqli->rollback(); } $mysqli->close();...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
', $author_name); $author_name_disp=ucfirst($author_names[0]).' '.strtoupper($author_names[1][0]).'.'; }elseif(strpos($author_name, '.')!==false){ $author_names=explode('.', $author_name); $author_name_disp=ucfirst($author_names[0]).'...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB