tag:blogger.com,1999:blog-41801431696690418452024-02-21T10:36:37.448+02:00Swoosh`s Code stuffSQL, C#, VB, .net, asp, JavaScript, you name it. Code samples, Error messages and stuff like that. Please add coments if you think I said something stupid :D or if you have a better idea ... or anything at all ...Unknownnoreply@blogger.comBlogger72125tag:blogger.com,1999:blog-4180143169669041845.post-11390214794205995422023-01-25T15:43:00.006+02:002023-01-25T15:43:36.071+02:00mssms dark there<a href="https://www.sqlshack.com/setting-up-the-dark-theme-in-sql-server-management-studio/">https://www.sqlshack.com/setting-up-the-dark-theme-in-sql-server-management-studio/</a><div><br /></div><div>worked</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-46958583830534893912021-04-02T16:18:00.007+03:002021-04-02T16:18:44.696+03:00Fastest C# compare string<p> Use </p><p><br /></p><p><span style="background-color: white; color: #222222; font-family: verdana, arial, helvetica, sans-serif; font-size: 14px; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: 20px; widows: 1;">string.Equals(s1, s2, StringComparison.OrdinalIgnoreCase)</span></p><p><span style="background-color: white; color: #222222; font-family: verdana, arial, helvetica, sans-serif; font-size: 14px; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: 20px; widows: 1;"><br /></span></p><p><span style="background-color: white; color: #222222; font-family: verdana, arial, helvetica, sans-serif; font-size: 14px; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: 20px; widows: 1;">instead of toupper or tolower</span></p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-50515862343874300652021-02-08T17:09:00.002+02:002021-02-08T17:09:23.917+02:00Split sql with xml<a href="https://stackoverflow.com/questions/697519/split-function-equivalent-in-t-sql/1846561#1846561">https://stackoverflow.com/questions/697519/split-function-equivalent-in-t-sql/1846561#1846561</a><div><br /><a href="https://stackoverflow.com/questions/697519/split-function-equivalent-in-t-sql/1846561#1846561"></a><div id="div2" style="background-color: beige; height: 230px; overflow-x: scroll; overflow-y: auto; overflow: scroll auto; width: 410px;">
<div style="width: 800px;"><font style="font-family: "Courier New"; font-size: small;"><br /></font></div><div style="width: 800px;">
<font style="font-family: "Courier New"; font-size: small;">DECLARE @xml xml, @str varchar(100), @delimiter varchar(10)<br />
SET @str = '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15'<br />
SET @delimiter = ','<br />
SET @xml = cast(('<x>'+replace(@str, @delimiter, '</x><x>')+'</x>') as xml)<br />
SELECT C.value('.', 'varchar(10)') as value FROM @xml.nodes('X') as X(C)<br />
</font>
</div><div style="width: 800px;"><font style="font-family: "Courier New"; font-size: small;"><br /></font></div><div style="width: 800px;"><font style="font-family: "Courier New"; font-size: small;"><br /></font></div><div style="width: 800px;"><font style="font-family: "Courier New"; font-size: small;"><br /></font></div>
</div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-50344325039051397282020-04-09T15:05:00.004+03:002020-04-09T15:05:57.177+03:00Parse URL in SQLI searched a lot, and I did not like anything I found. Then I saw this on sql-server-helper.com
That site looks a little odd, I thought I would save this for myself, in case the site goes away, like some I used before stackoverflow.
<br />
<div id="div2" style="background-color: beige; height: 430px; overflow-x: scroll; overflow-y: auto; width: 410px;">
<div style="width: 800px;">
<span style="font-family: "courier new"; font-size: x-small;">
CREATE FUNCTION [dbo].[ParseURLQueryString] <br />
( @QueryString AS VARCHAR(MAX) ) <br />
RETURNS @QueryStringTable TABLE <br />
( [Key] VARCHAR(100), [Value] VARCHAR(1000) ) <br />
AS <br />
BEGIN <br />
DECLARE @QueryStringPair VARCHAR(2000) <br />
DECLARE @Key VARCHAR(100) <br />
DECLARE @Value VARCHAR(1000) <br />
<br />
WHILE LEN(@QueryString) > 0 <br />
BEGIN <br />
SET @QueryStringPair = LEFT ( @QueryString, ISNULL(NULLIF(CHARINDEX('&', @QueryString) - 1, -1), <br />
LEN(@QueryString))) <br />
SET @QueryString = SUBSTRING( @QueryString, ISNULL(NULLIF(CHARINDEX('&', @QueryString), 0), <br />
LEN(@QueryString)) + 1, LEN(@QueryString)) <br />
<br />
SET @Key = LEFT (@QueryStringPair, ISNULL(NULLIF(CHARINDEX('=', @QueryStringPair) - 1, -1), <br />
LEN(@QueryStringPair))) <br />
SET @Value = SUBSTRING( @QueryStringPair, ISNULL(NULLIF(CHARINDEX('=', @QueryStringPair), 0), <br />
LEN(@QueryStringPair)) + 1, LEN(@QueryStringPair)) <br />
<br />
INSERT INTO @QueryStringTable ( [Key], [Value] ) <br />
VALUES ( @Key, @Value ) <br />
END <br />
<br />
RETURN <br />
END <br />
<br />
</span>
</div>
</div>
And this is how you use it
<br />
<div id="div2" style="background-color: beige; height: 130px; overflow-x: scroll; overflow-y: auto; width: 410px;">
<div style="width: 800px;">
<span style="font-family: "courier new"; font-size: x-small;">
SELECT * FROM [dbo].[ParseURLQueryString] ( 'fname=Barack&lname=Obama&addr=1600 Pennsylvania Ave NW&city=Washington&st=DC&zip=20500' )
</span>
</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-35420919236980631322020-02-26T17:52:00.001+02:002020-02-26T17:52:21.511+02:00WiX undefined preprocessor variableNot sure how many people will see my small blog, but here I go, maybe it helps someone.<br />
<br />
I recently had this WiX undefined preprocessor variable issue.<br />
<br />
The actual variable was the same old $(var.MyProject.TargetDir)<br />
<br />
After looking through the whole internet and not finding anything, the fix was a simple one.<br />
<br />
The "MyProject" HAS TO BE EXACTLY THE SAME NAME as the web project that I added as a reference to the Wix project.<br />
So if your project is called WhatewerWebAll, then you have to have something like:<br />
<br />
<br />
You can say what you want, but the "undefined preprocessor variable $(var.MyProject.TargetDir)" message is actually not really describing the real issue, but maybe that's just me.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-10006088484319828832020-01-15T13:15:00.001+02:002020-01-15T13:15:17.329+02:00Sony Android TV Bluetooth headset issue a2dpFrom what I understand after investigating this issue, this happens with multiple TV types from Sony.<br />
<br />
I got a new TV, Sony BRAVIA, 49XG8096, 4K Ultra HD.<br />
The TV is cool, no issues with it at all.<br />
<br />
My plan was to connect it with a Bluetooth headset too, so I can watch a movie without wires, even if my wife is sleeping next to me.<br />
<br />
I first bought a JBL Tune 500 headset, just because that was on stock, and could not lose time searching for anything else. The headset was working fine, connecting with anything, but I couldn't get it to connect to the TV at all.<br />
I looked up this issue and saw that there is a list of headphones that are on an Official list from Sony. I can't say I was happy, but I went back to the store, and changed the headphones to a Sony this time, model WH-CH500B.<br />
<br />
According to the list, it should have worked.<br />
Well, it didn't.<br />
<br />
I investigated some more, and I found out that this is might be a software issue, with a very easy fix.<br />
I went to the TV's Play Store, searched for Bluetooth, and installed the first 3rd party app that I found. The app connected the Sony Headset to the Sony TV in less then 5 seconds.<br />
<br />
After this, I can just go to the TV settings, and the WH-CH500B is listed as paired, I can easily turn it on or off.<br />
<br />
I am thinking that the JBL might have been working too if I used an app like this.<br />
<br />
I am not sure why Sony cannot do this themselves, but I don't care anymore.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-71773734409578165402017-12-15T15:30:00.000+02:002017-12-15T15:30:13.117+02:00SQL - update column with sequence number starting from 1<div id="div2" style="background-color: beige; height: 100px; overflow-x: scroll; overflow-y: auto; width: 410px;">
<div style="width: 400px;">
<span style="font-family: "courier new"; font-size: x-small;"><br /></span>
<span style="font-family: "courier new"; font-size: x-small;">
DECLARE @id INT;<br />
SET @id = 0<br />
UPDATE x SET @id = [ItemNo] = @id + 1<br />
</span>
</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-74285461249142969252017-10-12T13:47:00.000+03:002017-10-12T13:47:51.358+03:00Find position of object in the screenTested it, it works pretty nice in FF, Chrome, IE, Safari too.
<div id="div2" style="background-color: beige; height: 330px; overflow-x: scroll; overflow-y: auto; width: 510px;">
<div style="width: 500px;">
<span style="font-family: "courier new"; font-size: x-small;">function resetPosition(object, args) {</span><br />
<span style="font-family: "courier new"; font-size: x-small;">
/* find the textbox object */<br />
var tb = object._element;<br />
/* measure textbox height */<br />
var tbheight = tb.offsetHeight;<br />
/* find textbox in the page */<br />
var rect = tb.getBoundingClientRect();<br />
var divleft = Math.floor(rect.left);<br />
var divtop = Math.floor(rect.top + tbheight);<br />
/* find the auto complete extender div in the page */<br />
var ex = object._completionListElement;<br />
/* move the ace to the right position */<br />
if (ex)<br />
$common.setLocation(ex, new Sys.UI.Point(divleft, divtop));<br />
}<br />
<br />
</span>
</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-49174381228641299922017-05-15T14:49:00.002+03:002017-05-15T14:49:23.381+03:00Whatsapp issuesAndroid connection issues for whatsapp, gmail, or whatever.<br />
Go to settings - connection - more networks - mobile networks - access point names<br />
I had to swith it from wap to net to make it work.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-66264380381122188032016-09-26T18:42:00.001+03:002016-09-26T18:42:54.109+03:00Wix heat command exited with code 319 (-out parameter must specify a file path)<br />
<ul>
<li><span style="color: blue;">The '-out' or '-o' parameter must specify a file path. File: heat.exe</span></li>
<li><span style="color: blue;">The command " "C:\Program Files (x86)\WiX Toolset v3.7\bin\heat.exe" project "..\Web \" -gg -g1 -cg PACKAGEFILES sreg -dr DEPLOYFOLDER -out "C:\Users(...)\Server\Wix\Frags.wxs" " exited with code 319. File: C:\Users(...)\Server\Wix\Wix.wixproj</span></li>
</ul>
<br />
<br />
This was really not a lot of information for me to use.<br />
What I fount out, is that Wix is throwing this error on anything. I will explain.<br />
<br />
So this was my code:<br />
<br />
<pre class="lang-xml prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;"><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">"$(WIX)bin\heat.exe" dir "$(vm4heat)" -cg vm4heat -gg -scom -sreg -sfrag -srd -out "$(ProjectDir)\FilesFragment.wxs"</span></code></pre>
<br />
<div>
And as you can see, I have 3 different paths in my code.</div>
<div>
The error message says that the issue is on the "out".</div>
<div>
Well, the actual error was on the "dir".</div>
<div>
<br /></div>
<div>
So in case you ever get this error, don't look for wrong doing in the "out" parameter only. Check EVERY path, one by one. In my case it was an extra backslash at the end of the "dir" parameter.</div>
<div>
<br /></div>
<div>
Hope this helps.</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-2123106784106977432016-05-03T12:10:00.002+03:002016-05-03T12:10:12.292+03:00Excel shortcuts<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">F2</span> : Edit selected cell</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">F4</span> : Repeat last edit</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">F9</span> : Calculates all worksheets</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">F11</span> : New chart</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">ALT</span> : Access the ribbon for formulas</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">ALT + =</span> : Automatically SUM() selected</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">ALT + Enter</span><span style="box-sizing: border-box; font-weight: 700;"> : </span>Start a new line in the same cell</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">ALT + o-c-a</span> : Auto size columns</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">PG + UP/PG+DOWN</span> : Go to next/previous worksheet</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + `</span> : Display Formulas</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL +</span> <span style="box-sizing: border-box; font-weight: 700;">Backspace</span> : Show active cell</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Shift + #</span> : Change Date format with day, month and year.</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + K</span> : To insert Hyperlink.</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL+ Shift + $</span> : Applies the currency format to the selected cells.</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Shift + & : </span>Applies border to cells</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + B</span> : Bold</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + I</span> : Italics</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + U</span> : Underline</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Shift + ~</span> : General style number</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Shift + $</span> : Currency style number</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Shift + %</span> : Percentage style Number</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Shift + ^</span> : Scientific notation style</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Shift + #</span> : Date style</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Shift + @</span> : Time Style</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Shift +!</span> : Number Style</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + F12</span><span style="box-sizing: border-box; font-weight: 700;"> : Open</span></h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Spacebar</span><span style="box-sizing: border-box; font-weight: 700;"> : </span>Select the entire column</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + [</span> : Select all cells directly referenced by formulas in the selection</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + A</span> : Select All</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Shift + J</span> : List Constants</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + D</span> : Copy equation down</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + F</span> : Find</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + H</span> : Find&Replace</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Right arrow</span> : Move right</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Left arrow</span> : Move left</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Up arrow</span> : Move up</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Down arrow</span> : Move down</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">CTRL + Enter</span> : Same data in multiple cells</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">Shift + Spacebar</span><span style="box-sizing: border-box; font-weight: 700;"> : </span>Select the entire row</h4>
<h4 style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Open Sans', sans-serif; font-size: 18px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-weight: 700;">Shift + F3</span> : Find Previous</h4>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-34718810603472485802016-02-19T15:20:00.001+02:002016-02-19T15:20:19.544+02:00Javascript exception handler<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGTXcQ1jvG_99WVHEM6PWrlxyx0rOzlkkqbNpVckKWENyMj19vu6snKj26ymbqXOjN9f5_LB-qi6QJ3YON0SS0ak9I-j8A5eRDcYEDJU6cl-DhIJda5D1V0jwMkFbQZvUdbdTRFk64CWQ/s1600/stackoverflow.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGTXcQ1jvG_99WVHEM6PWrlxyx0rOzlkkqbNpVckKWENyMj19vu6snKj26ymbqXOjN9f5_LB-qi6QJ3YON0SS0ak9I-j8A5eRDcYEDJU6cl-DhIJda5D1V0jwMkFbQZvUdbdTRFk64CWQ/s1600/stackoverflow.jpg" /></a></div>
<br />Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-34757382646200620132015-05-13T17:00:00.001+03:002015-05-13T17:00:16.615+03:00Chrome: Could not load shockwave flashI had an expired Flash - Firefox. For some weird reason, I made an upgrade. (I don't really use Firefox)<br />
This messed up my Chrome Flash. I had "Could not load shockwave flash", and that nice looking grey thing.<br />
Went on to google it, tried several things.<br />
<br />
<ul>
<li>chrome setting, something needs to be disabled (when you have 2 plugins)</li>
<li>delete some files from some flash folder on C drive</li>
<li>uninstall plugins, reinstall them</li>
</ul>
<br />
Nothing worked.<br />
<br />
I finally <u><b>uninstalled chrome, and reinstalled it</b></u>. I didn't lose anything. Browsing history, shortcuts, home page, extensions (even an extension that is no longer in Chrome app store).<br />
<br />
Flash also worked flawlessly after this.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-52253614736670327822015-04-09T11:59:00.000+03:002015-04-09T11:59:04.800+03:00How to get the size of the tables in a databaseHow to get the size of the tables in a database
<div id="div2" style="background-color: beige; height: 230px; overflow-x: scroll; overflow-y: auto; width: 410px;">
<div style="width: 800px;">
<span style="font-family: Courier New; font-size: x-small;">
SELECT <br />
t.NAME AS TableName,<br />
s.Name AS SchemaName,<br />
p.rows AS RowCounts,<br />
SUM(a.total_pages) * 8 AS TotalSpaceKB, <br />
SUM(a.used_pages) * 8 AS UsedSpaceKB, <br />
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB<br />
FROM <br />
sys.tables t<br />
INNER JOIN <br />
sys.indexes i ON t.OBJECT_ID = i.object_id<br />
INNER JOIN <br />
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id<br />
INNER JOIN <br />
sys.allocation_units a ON p.partition_id = a.container_id<br />
LEFT OUTER JOIN <br />
sys.schemas s ON t.schema_id = s.schema_id<br />
WHERE <br />
t.NAME NOT LIKE 'dt%' <br />
AND t.is_ms_shipped = 0<br />
AND i.OBJECT_ID > 255 <br />
GROUP BY <br />
t.Name, s.Name, p.Rows<br />
ORDER BY <br />
TotalSpaceKB desc<br />
</span>
</div>
</div>
Thanks to AndrewUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-34580550555005018422014-01-10T15:50:00.002+02:002014-01-10T15:50:17.202+02:00Kindle USB issue - Cannot connect Kindle to PCMy kindle 3 (keyboard) was not connecting to my PC, but it did connect to any other PC.<br />
<br />
I tried everything I found on the internet:<br />
- restart from kindle button<br />
- restart from Kindle settings<br />
- checked all the USB ports in fromt (2 of them) and in the back (6 of them)<br />
<br />
nothing worked<br />
<br />
when i plug it in, the PC displays the Safely Remove Hardver icon in the tray, and the Kindle goes to that "USB drive mode" screen. No Kindle drive. If I "safely remove" then it still charges, the "USB drive mode" screen goes away, i can check my books, but still no kindle drive<br />
<br />
What did I do?<br />
<br />
I went to Device Manager, Kindle was visible (charging worked), and on Properties, I was browsing through the tabs. On the 3rd tab ("Volume") I had a Populate button, I clicked it. It showed me Kindle(E)<br />
<br />
BUT<br />
<br />
my E drive was a network connection (Network share), a kind of shortcut to an other computer from the LAN<br />
<br />
i disconnected my "old" E drive, the Network Share.<br />
<br />
Ta Da !<br />
<br />
All the Kindle folders suddenly showed up on the E drive right there.<br />
Case closed.<br />
<br />
Seems like the Kindle was trying to force itself to a (taken) drive letter, not sure why.<br />
<br />
If you ever have the same issue, if you don't see the Kindle drive in Windows File Explorer, try if you can see it in (My Computer - Manage) Computer Management - Disk Management, maybe all you need to reallocate some drive letters.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-29368555323439887902013-10-09T18:49:00.001+03:002013-10-09T18:49:15.163+03:00CONVERT DATETIME seems all right, but still ...A table with a varchar column that has date and other value types too.<br />
A query with a simple <span class="kwd" style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px; vertical-align: baseline;">CONVERT </span><span class="pln" style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px; vertical-align: baseline;">DATETIME</span><br />
<span class="pln" style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span>
<blockquote class="tr_bq">
<span class="pln" style="background-color: #d0e0e3; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">Conversion failed when converting date and/or time from character string.</span></blockquote>
<span class="pln" style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: 'Times New Roman'; font-size: small; line-height: normal;">Crashing. Over and over again. I start to call it X-Files.</span></span><br />
<span class="pln" style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: 'Times New Roman'; font-size: small; line-height: normal;">Until I read <a href="http://stackoverflow.com/questions/7028883/sql-datetime-conversion-fails-when-no-conversion-should-be-taking-place">THIS</a>.</span></span><br />
<span class="pln" style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: 'Times New Roman'; font-size: small; line-height: normal;"><br /></span></span>
<span class="pln" style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: 'Times New Roman'; font-size: small; line-height: normal;">Not only I know why it happened (and sortof feel like SQL is "stupid" :D) but I get an interesting idea to work around the issue.</span></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-59347660505644134172013-09-26T15:26:00.002+03:002013-09-26T15:26:41.843+03:00F7 - Visual Studio - switch between aspx and "codebehind"<br />
<div>
It was not working for me.</div>
<div>
This is what I had to do:</div>
<ul>
<li>Bring up customization dialog with "Tools\Customize..."</li>
<li>Bring up the keystroke mapper with "Keyboard..."</li>
<li>Set focus in "Press Shortcut Keys" text box</li>
<li>Press F7 or some other keystroke you want</li>
<li>The "Shortcut currently used by" box will show the command currently invoked by the keystroke.</li>
<li>Set focus to "Show Commands Containing" and type ToggleDesigner</li>
<li>This will select the View.ToggleDesigner command in the list box of commands</li>
<li>Next press the "Assign" button to assign the keystroke shortcut to the command.</li>
<li>Click "OK" to the keystroke mapper dialog</li>
<li>Click "Close" to the customization dialog</li>
</ul>
Unknownnoreply@blogger.com4tag:blogger.com,1999:blog-4180143169669041845.post-37896632368480859102013-06-27T11:52:00.002+03:002013-06-27T11:54:38.173+03:00SQL split using ParsenameInteresting way to SPLIT stuff in SQL<br />
<br />
Parsename, read all about it, <a href="http://www.sql-server-helper.com/tips/split-name.aspx">here</a>
<div id="div2" style="background-color: beige; height: 230px; overflow-x: scroll; overflow-y: auto; width: 410px;">
<div style="width: 800px;">
<span style="font-family: Courier New; font-size: x-small;">
DECLARE @FullName VARCHAR(100)<br>
SET @FullName = 'John Doe'<br>
<br>
SELECT PARSENAME(REPLACE(@FullName, ' ', '.'), 2) AS [FirstName],<br>
PARSENAME(REPLACE(@FullName, ' ', '.'), 1) AS [LastName]<br>
</span>
</div>
</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-12698672957756665322013-03-21T13:33:00.002+02:002013-03-21T13:33:48.253+02:00TextboxWatermarkExtender and Textbox with TextMode = Password<br />
<div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
I managed to do this by setting the watermark stylesheet to overlay an image in the textbox.</div>
<div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
You simply take a snapshot of how you want the watermarked textbox to look, save that, then set the watermark css of that textbox to a style that displays the image and aligns the text to the right (because otherwise it will still be visible)</div>
<div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
It's very easy and works flawlessly.</div>
<div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
The Textbox:</div>
<span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><</span></span><span style="background-color: #f0f3f4; border: 0px; color: #a31515; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: #a31515; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">asp</span></span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">:</span></span><span style="background-color: #f0f3f4; border: 0px; color: #a31515; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: #a31515; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">TextBox</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: #f0f3f4; border: 0px; color: red; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ID</span></span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">="Password"</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: #f0f3f4; border: 0px; color: red; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">runat</span></span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">="server"</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: #f0f3f4; border: 0px; color: red; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">CssClass</span></span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">="txtbox_login"</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: #f0f3f4; border: 0px; color: red; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Width</span></span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">="120px"</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: #f0f3f4; border: 0px; color: red; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">TextMode</span></span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">="Password"></span></span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><div style="background-color: transparent; border: 0px; font-size: 13px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
</span></span><span style="background-color: #f0f3f4; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px;"></span><div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
The Watermark (Set the WatermarkText property to anything you want, but just one character):</div>
<span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span></span><div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><</span></span><span style="background-color: transparent; border: 0px; color: #a31515; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: #a31515; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ajax</span></span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">:</span></span><span style="background-color: transparent; border: 0px; color: #a31515; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: #a31515; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">TextBoxWatermarkExtender</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ID</span></span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">="txtWMark2"</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">runat</span></span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">="server"</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">WatermarkCssClass</span></span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">="watermarked_psw"</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">TargetControlID</span></span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">="Password"</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">WatermarkText</span></span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">="*"</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">/></span></span></div>
<span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span></span><span style="background-color: #f0f3f4; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px;"></span><div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
The StyleSheet (You MUST align the text to the right, otherwise it will still display over the image):</div>
<span style="background-color: #f0f3f4; border: 0px; color: #a31515; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: #a31515; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><div style="background-color: transparent; border: 0px; font-size: 13px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
.watermarked_psw</div>
</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><div style="background-color: transparent; border: 0px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
{</div>
</span><span style="background-color: #f0f3f4; border: 0px; color: red; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">color</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">: </span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">White</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">font-family</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">: </span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Tahoma</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span></div>
<span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><span style="background-color: #f0f3f4; border: 0px; color: red; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">font-size</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">: </span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">11px</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">border</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">: </span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">solid</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">1px</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">#a9a9a9</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span></div>
<span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><span style="background-color: #f0f3f4; border: 0px; color: red; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">text-indent</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">:</span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">2px</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">vertical-align</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">:</span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">middle</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span></div>
<span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><span style="background-color: #f0f3f4; border: 0px; color: red; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">text-align</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">:</span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">right</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><div style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18.203125px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">background-image</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">:</span><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">url(../images/psw_wMark.png)</span></span><span style="background-color: transparent; border: 0px; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span></div>
<span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span><span style="background-color: #f0f3f4; border: 0px; color: red; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: red; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">background-repeat</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">:</span><span style="background-color: #f0f3f4; border: 0px; color: blue; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; color: blue; font-size: x-small; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">no-repeat</span></span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">;</span><span style="background-color: #f0f3f4; border: 0px; color: #222222; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: x-small; line-height: 18.203125px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><div style="background-color: transparent; border: 0px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
}</div>
<div style="background-color: transparent; border: 0px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: transparent; border: 0px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
I found this one <a href="http://forums.asp.net/t/1069447.aspx/1">here, by JeanT</a></div>
<div style="background-color: transparent; border: 0px; margin-bottom: 18px; outline: 0px; padding: 0px; vertical-align: baseline;">
It works !</div>
</span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-48154157249902296332013-02-15T11:16:00.004+02:002013-02-15T11:16:51.447+02:00SQL for CNP :D<div id="div2" style="background-color: beige; height: 230px; overflow-x: scroll; overflow-y: auto; width: 410px;">
<div style="width: 800px;">
<span style="font-family: Courier New; font-size: x-small;">
create table #cucu(bau varchar(10))
insert into #cucu (bau) values ('123')
insert into #cucu (bau) values ('3888')
insert into #cucu (bau) values ('2888')
insert into #cucu (bau) values ('6888')
insert into #cucu (bau) values ('300a')
select * from #cucu
where bau LIKE '[3,4,6][0-9][0-9][0-9]'
drop table #cucu
</span>
</div>
</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-47841507022707296542012-03-13T12:50:00.000+02:002012-03-19T12:06:08.682+02:00Samsung Galaxy S2 connection problemsSamsung Galaxy S2 connection problems<br />
<br />
Samsung Galaxy S2 connection problem<br />
<br />
I recently wanted to connect my Samsung Galaxy S2 to a PC.<br />
<br />
1. My first problem was because of the device has not been recognized.<br />
USB device not recognized windows error messsage.<br />
<br />
To fix this:<br />
<br />
Settings > Applications > Development > USB debugging checkbox - I checked it<br />
<br />
Then it connected.<br />
<br />
2. The second error was right after that. Error message:<br />
<br />
"Reconnect the device in samsung kies mode"<br />
<br />
Well, believe it or not, I had to do it bacwords<br />
<br />
Settings > Applications > Development > USB debugging checkbox - I UNchecked it<br />
<br />
and it worked<br />
<br />
[UPDATE] I tried it again, and found out that I have to have the the phone unlocked too<br />
(I use that unlock-pattern-draw-feature)<br />
<br />
This all after long hours of reading forums ... and stuff<br />
<br />
Hope it helps, comment if it did ;)<br />
<br />
cheersUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-31557365456197174892011-11-21T12:34:00.001+02:002011-11-21T12:34:34.947+02:00How does Add/Remove Programs get the size and other information?Interesting article on this one <a href="http://blogs.msdn.com/b/oldnewthing/archive/2004/07/09/178342.aspx" target="_blank">here</a>.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-81903995203158022172011-11-10T11:55:00.001+02:002011-11-10T11:55:13.561+02:00How to Build a Chrome ExtensionI saw this article on lifehacker, thought it pretty cool:
<a href="http://lifehacker.com/5857721/how-to-build-a-chrome-extension">How to Build a Chrome Extension</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-24406077791577146902011-07-14T15:23:00.000+03:002011-07-14T15:24:43.635+03:00SQL capitalize wordsthis is from L.E.<br /><br /><div id="div2" style="overflow-y: auto; overflow-x: scroll;height: 230px; width:410px; background-color:Beige;"><div style="width:800px;"><font style="font-family:Courier New; font-size:small;"><br />set ANSI_NULLS ON<br />set QUOTED_IDENTIFIER ON<br />go<br /><br />ALTER FUNCTION [dbo].[fn_capitalize] <br />( <br />@str AS nvarchar(100) <br />) <br />RETURNS nvarchar(100) <br />AS <br />BEGIN <br /><br />DECLARE <br />@ret_str AS varchar(100), <br />@pos AS int, <br />@len AS int <br /><br />SELECT <br />@ret_str = N' ' + LOWER(@str), <br />@pos = 1, <br />@len = LEN(@str) + 1 <br /><br />WHILE @pos > 0 AND @pos < @len <br />BEGIN <br />SET @ret_str = STUFF(@ret_str, <br />@pos + 1, <br />1, <br />UPPER(SUBSTRING(@ret_str,@pos + 1, 1))) <br />SET @pos = CHARINDEX(N' ', @ret_str, @pos + 1) <br />END <br />RETURN RIGHT(@ret_str, @len - 1) <br /><br />END <br /><br /></font></div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4180143169669041845.post-87786870495220778612011-06-02T12:45:00.001+03:002011-06-02T12:47:17.423+03:00SQL - turn debug on-offThis is what I do in stored procedures to turn debug print stuff on and off<br /><br /><div id="div2" style="overflow-y: auto; overflow-x: scroll;height: 230px; width:410px; background-color:Beige;"><div style="width:800px;"><font style="font-family:Courier New; font-size:small;"><br />DECLARE @isDebug BIT; SET @isDebug = 0; IF @isDebug = 0 BEGIN SET NOCOUNT ON END<br />/* ... sql stuff ... */<br />IF @isDebug = 1 PRINT (@strSQL)<br /></font></div></div>Unknownnoreply@blogger.com0