Wednesday, October 9, 2013

CONVERT DATETIME seems all right, but still ...

A table with a varchar column that has date and other value types too.
A query with a simple CONVERT DATETIME

Conversion failed when converting date and/or time from character string.
Crashing. Over and over again. I start to call it X-Files.
Until I read THIS.

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.

Thursday, September 26, 2013

F7 - Visual Studio - switch between aspx and "codebehind"

It was not working for me.
This is what I had to do:
  • Bring up customization dialog with "Tools\Customize..."
  • Bring up the keystroke mapper with "Keyboard..."
  • Set focus in "Press Shortcut Keys" text box
  • Press F7 or some other keystroke you want
  • The "Shortcut currently used by" box will show the command currently invoked by the keystroke.
  • Set focus to "Show Commands Containing" and type ToggleDesigner
  • This will select the View.ToggleDesigner command in the list box of commands
  • Next press the "Assign" button to assign the keystroke shortcut to the command.
  • Click "OK" to the keystroke mapper dialog
  • Click "Close" to the customization dialog

Thursday, June 27, 2013

SQL split using Parsename

Interesting way to SPLIT stuff in SQL

Parsename, read all about it, here
SET @FullName = 'John Doe'

SELECT PARSENAME(REPLACE(@FullName, ' ', '.'), 2) AS [FirstName],
PARSENAME(REPLACE(@FullName, ' ', '.'), 1) AS [LastName]

Thursday, March 21, 2013

TextboxWatermarkExtender and Textbox with TextMode = Password

I managed to do this by setting the watermark stylesheet to overlay an image in the textbox.
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)
It's very easy and works flawlessly.
The Textbox:
<asp:TextBox ID="Password" runat="server" CssClass="txtbox_login" Width="120px" TextMode="Password">

The Watermark (Set the WatermarkText property to anything you want, but just one character):
<ajax:TextBoxWatermarkExtender ID="txtWMark2" runat="server" WatermarkCssClass="watermarked_psw"TargetControlID="Password" WatermarkText="*" />

The StyleSheet (You MUST align the text to the right, otherwise it will still display over the image):
bordersolid 1px #a9a9a9;

I found this one here, by JeanT
It works !

Friday, February 15, 2013

SQL for CNP :D

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