Day-By-Day Computer Tricks

T-SQL Generic Select

2011-11-07T11:58:00.006-05:00

When you have a table and wants to create a Stored Procedure that selects records on that table passing one or various fields as a filter, you can use the sample code below to create a SP to deal with that.

-- #############################

DECLARE @Name VARCHAR(200), @Abbr VARCHAR(2), @Active CHAR(1), @DivisionId INT

SET @Name = 'Pan'

SET @Abbr = NULL

SET @Active = NULL

SET @DivisionId = NULL

SELECT *

FROM MOE_Division

WHERE (Division_Name LIKE '%' + @Name + '%' OR ISNULL(@Name, '') = '') AND (@Abbr = Division_Abbrev OR ISNULL(@Abbr, '') = '')

AND (@Active = Active_Status OR ISNULL(@Active, '') = '')

AND (@Active = Active_Status OR ISNULL(@Active, '') = '')

AND (@DivisionId = Division_Id OR ISNULL(@DivisionId, '') = '')

-- #############################

CREATE PROCEDURE GET_MOE_Division

    @Division_Id int,

    @Division_Name varchar(50),

    @Division_Abbrev varchar(10),

    @Active_Status varchar(1)

AS

SELECT * FROM MOE_Division

WHERE (Division_Name LIKE '%' + @Name + '%' OR ISNULL(@Name, '') = '')AND (@Division_Abbrev = Division_Abbrev OR ISNULL(@Abbr, '') = '')

AND (@Active_Status = Active_Status OR ISNULL(@Active, '') = '')

AND (@Division_Id = Division_Id OR ISNULL(@DivisionId, '') = '')

-- #############################

-- It will return all records

SELECT * FROM GET_MOE_Division(NULL, NULL, NULL, NULL)

-- It will return all records where Division_Abbrev = 'SP'

SELECT * FROM GET_MOE_Division(NULL, NULL, 'SP', NULL)

-- It will return all records that are Active and part of the name is 'Pan'

SELECT * FROM GET_MOE_Division(NULL, 'Pan', NULL, 'A')

How to search all columns of all tables in a database for a keyword?

2010-11-11T17:26:00.003-05:00

Nice script from Narayana Vyas Kondreddi to deal with finding content on SQL tables.

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

;-)

Quick Subversion Setup

2010-06-13T18:06:00.003-05:00

Download SVN at http://subversion.tigris.org/servlets/ProjectDocumentList?folderID=8100.

I download and copy the svn setup file onto my DEV-SOURCE machine then run the install and complete the wizard. I used all the default settings except I unchecked the desktop and quick launch icons.

C:\Users\Administrator>cd installs

C:\Users\Administrator\Installs>svn-1.4.6-setup.exe

Once completed subversion is installed at C:\Program Files (x86)\Subversion.

To make using subversion easier I set it on the PATH using the setx tool. You need to log out and log back in so that the PATH environment variable is updated.

c:\Users\Administrator>setx PATH "%PATH%;C:\Program Files (x86)\Subversion\bin"

SUCCESS: Specified value was saved.

c:\Users\Administrator>shutdown /l

Creating the source code repository can be done with the svnadmin create command. I then change to the new repository to make sure all went well.

C:\Users\Administrator>svnadmin create c:\svn_repository

C:\Users\Administrator>cd c:\svn_repository

c:\svn_repository>dir

 Directory of c:\svn_repository

05/01/2008  04:32 PM              .

05/01/2008  04:32 PM              ..

05/01/2008  04:32 PM              conf

05/01/2008  04:32 PM              dav

05/01/2008  04:32 PM              db

05/01/2008  04:32 PM                 2 format

05/01/2008  04:32 PM              hooks

05/01/2008  04:32 PM              locks

05/01/2008  04:32 PM               234 README.txt

               2 File(s)            236 bytes

              7 Dir(s)  132,327,505,920 bytes free

To configure subversion I set the authorization and passwords as follows:

c:\svn_repository>notepad conf\svnserve.conf

Add these lines to the bottom:

anon-access = none

auth-access = write

password-db = passwd

c:\svn_repository>notepad conf\passwd

Add your user name and password:

evan = *****

Then I create the subversion service and start it.

c:\Users\Administrator>sc create svnserver binpath= "C:\Program Files (x86)\Subversion\bin\svnserv

e.exe --service -r c:\svn_repository" DisplayName= "Subversion" depend= tcpip start= auto

[SC] CreateService SUCCESS

c:\Users\Administrator>net start svnserver

The Subversion service is starting.

The Subversion service was started successfully.

Finally you will need to open up the subversion port 3690 in windows firewall for remote access.

c:\Users\Administrator>netsh advfirewall firewall add rule name="Subversion" dir=in action=allow

protocol=TCP localport=3690

Ok.

To test this out download and install tortoise svn on your client machine. Right click in a directory and go to TortoiseSVN -> Repo-browser. Connect to the server in my case DEV-SOURCE and make sure you can create a few folders. Happy coding!

In Time:

If you want to generate a unique passwd file for different repositories, you can edit svnserve.conf on each repository to point to that generic passwd file - you can only use relative paths (ex.: SVN -> c:\SVN, repositories -> c:\repos, repository named CE -> c:\repos\ce2, passwd file -> c:\SVN\passwd, CE repository svnserve.conf file -> c:\repos\ce2\svnserve.conf, info for password-db on svnserve.conf -> password-db = //.C:/SVN/passwd)

(extracted from http://www.evanclosson.com/devlog/subversiononservercore)

How to remove all the svn hidden folders and their content from your local folder

2009-10-30T17:27:00.002-05:00

Create a bat file like delete_svn.bat with the following content:

for /f "tokens=* delims=" %%i in ('dir /s /b /a:d *svn') do (
rd /s /q "%%i"
)

Remark: "%%i" is all together

Nice article with DateTime patterns for .NET

2009-10-26T13:36:00.001-05:00

http://www.geekzilla.co.uk/View00FF7904-B510-468C-A2C8-F859AA20581F.htm

IE Command Line Switches

2009-10-26T13:14:00.004-05:00

Kiosk Mode: -k
(ex.: iexplorer -k http://www.centralequine.com/)

Turn off add-ons: -extoff
(ex.: iexplore -extoff http://www.centralequine.com/)

Remark: To get off kiosk mode, ALT+F4

Quickly Find Used IP Addresses on Your Network

2009-07-29T19:21:00.000-05:00

Instead of manually pinging all IP addresses on your LAN you can use this nice command:

FOR /L %i IN (1,1,254) DO ping -n 1 192.168.0.%i | FIND /i "Reply" >> c:\ipaddresses.txt

Using DefaultButton property of Panel with LinkButton control in ASP.NET

2008-08-20T17:41:00.003-05:00

DefaultButton works fine on IE browsers but they don't act the they should on Firefox or Safari.

After some research and tests, I've found very easy solution for the problem without a need of complicated Javascript or Custom Controls.

The secret is create an asp:Button that will be the target of the DefaultButton and set a style "display:none" for it. Then, you have to add that control event:click to use the same event:click of the LinkButton that you are using to submit/post the content of the Panel.

Let me show an example:

HTML

<asp:Panel ID="panel1" runat="server" DefaultButton="btnHiddenSubmit">

New Status:

<asp:TextBox ID="txbNewStatus" runat="server" />

<asp:LinkButton ID="lnkBtnNewStatusCancel" runat="server" Text="Cancel" />

<asp:LinkButton ID="lnkBtnNewStatusSubmit" runat="server" Text="Submit" />

<asp:Button ID="btnHiddenSubmit" runat="server" />

</asp:Panel>

CODE BEHIND:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

btnHiddenSubmit.Attributes.Add("style", "display:none;")

End Sub

Protected Sub lnkBtnNewStatusSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles lnkBtnNewStatusSubmit.Click, btnHiddenSubmit.Click

'Do what you need to do when you click the submit button

End Sub

I hope that is clear enough...

NAS Software

2008-01-29T23:14:00.000-05:00

One link: www.freenas.org.
This is one of the best products that I have used in a long time. Very easy to install and setup and works like a charm and guess what? Totally free...

DataFormatString inside GridView

2007-12-04T19:11:00.000-05:00

If you are having problems formating dates inside a gridview, I have the solution. After some research, i've found this post on Microsoft Forums: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=475524&SiteID=1.

To format a date (or any other format for that matter) you have to turn-off the HtmlEncode for that bound. Ex.:

< asp:BoundField DataField="fieldname" DataFormatString="{0:dd/MM/yy hh:mm tt}" HeaderText="header" SortExpression="sortexpression" />

change to:

< asp:BoundField DataField="fieldname" DataFormatString="{0:dd/MM/yy hh:mm tt}" HtmlEncode="false" HeaderText="header" SortExpression="sortexpression" />

That's it: HtmlEncode="false" is the secret.

Trick to not cache images for ASP.net

2007-08-22T14:10:00.000-05:00

If you have a page which contains a image control for displaying a .gif or .jpeg file and you have an upload control to update this picture and after the postback you still have the old image displaying, you are been victim of browser caching controls. The imediate solution is refresh the browser to get the new picture.
This happend because the browser things that the file/image is the same and doesn't refresh/reload the image to save processing/transfer time.

The solution is add a param to the end of the image URL.

I normally use (in VB):

Dim mTimeStamp As DateTime = now
image1.ImageUrl = "imagename.jpg" + "?" + mTimeStamp.Ticks.ToString

DIV center alignment behaviour

2007-08-11T15:26:00.000-05:00

Center alignment for DIV and browser behaviour:

IE works with just text-alignment: center
For Safari and Firefox: position:relative; white-space: normal; text-align: center;

Example:
div style="float: left; margin: 10px; width:522px; position:relative; white-space: normal; text-align: center;"

Vista and Samba NAS Devices

2007-07-19T11:58:00.000-05:00

If any of you are having problems with Vista logon to NAS devices running Samba, try:

Run secpol.msc

Go to: Local Policies > Security Options

Find "Network Security: LAN Manager authentication level"

Change Setting from "Send NTLMv2 response only" to "Send LM & NTLM - use NTLMv2 session security if negotiated"

Vista defaults to only send the more secure NTLMv2 protocol, which these NAS devices / Samba do not support.

(Quoted from: https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=660925&SiteID=1)

Samba on Fedora

2007-07-17T23:27:00.001-05:00

After suffering a bit installing Fedora 7, it came time to setup the Samba. This is the scenario: 2 Mac Minis, 4 iMacs, 1 Vista Pc, 1 MacBook, 1 Toshiba running XP Professional and a Fedora 7 running on a Core 2 Duo. After a lot of research, this line has saved me:
chcon -R -t samba_share_t /folder-that-you-are-sharing
After, of course, the proper setup of smb.conf under /etc/samba

Steers and Queers (Not)

2007-07-17T23:18:00.000-05:00

Finnaly we have arrived in Austin. Everything is going smoothly and we already have a home. Kelli got a new job and I'm still following the plans to come to Atlanta every couple weeks.
I am happy that people believes on the saying "Texas has only steers and queers". That makes me believe that all this people that have not been in Austin doesn't know what they are talking about (and, therefore, not likely to overpopulate this fine and pleasant town).

Windows Vista Annoyances - Hibernate Not Working

2007-05-21T01:04:00.000-05:00

If your hibernate mode is not showing as an option anymore, go to command prompt (or Start, Run) e type "powercfg.exe /hibernate on".
That will fix the problem.