Archive for August, 2007

Zoeken in stored procedures

Published at 30/08/2007 in TSQL. 2 Comments 

CREATE PROCEDURE [dbo].[sp_find_procs_containing]@search VARCHAR(100) = ” AS SET @search = ‘%’ + @search + ‘%’

SELECT ROUTINE_NAME, ROUTINE_DEFINITION

FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE @search ORDER BY ROUTINE_NAME

Voorkom Session Timeout ASP.NET

Published at 23/08/2007 in asp.net. 0 Comments

Via een basepage kan je met de volgende code, de session timeout afvangen:

bron


public class basePageSessionExpire : System.Web.UI.Page
{
    public basePageSessionExpire()
    {
    }

    override protected void OnInit(EventArgs e)
    {
        base.OnInit(e);

        if (Context.Session != null)
        {
            if (Session.IsNewSession)
            {
                string szCookieHeader = Request.Headers["Cookie"];
                if ((null != szCookieHeader) && (szCookieHeader.IndexOf("ASP.NET_SessionId") >= 0))
                {
                    Response.Redirect("sessionTimeout.htm");
                }
            }
        }
    }
}

Usefull links

Published at 09/08/2007 in Links. 0 Comments

http://pastebin.com/

Dit is een nuttige site waar je even source code kan posten als je dit nodig hebt om hulp te vragen op andere forums welke geen code highlight hebben.

http://www.famfamfam.com/

Opzoek naar icoontjes voor je website of applicatie kijk dan eens op famfamfam

Op http://www.sxc.hu kan je terecht voor gratis mooie stock foto’s

30+ best AJAX powered WordPress plugins

Published at 08/08/2007 in AJAX and WordPress. 0 Comments

Hier is een lijst met de beste, AJAX aangedreven plugins voor WordPress

LyteBox 2.0

Published at 08/08/2007 in Javascript and WordPress. 0 Comments

Ik was al bekend met LightBox, nu is er ook LyteBox, die hetzelfde kan maar nu ook voor HTML content. Voor de liefhebbers is er ook een WordPress smaakje

Wat doet het nu ? Het opent een bovenliggend iframe en toont de geselecteerde link of plaatje in dit iframe. Het werkt voor plaatjes:

veldf.jpgdsc03869.jpg

En ook voor html content: Google Search

CRUD generator voor SQL Server Manager

Published at 08/08/2007 in Tools. 0 Comments

Deze addin voor SQL Server Manager, genereert CRUD (CReate,Update,Delete)stored procedures op basis van een tabel. Simpel maar doeltreffend

http://weblogs.sqlteam.com/mladenp/archive/2006/12/28/55599.aspx

Optional filter parameters

Published at 08/08/2007 in TSQL. 0 Comments

To filter a table with one query you can do the following: 


EmployeeID int
DepartmentID int
ManagerID int
LocationID int

Now assume you want users of your application to be able to find an Employee by specifying any of the criteria they so desire. User1 may just want to find all employees who Joe Manager [ManagerID: 5] manages, User2 may want to find all employees who Joe Manager manages, but only if they are in the Technology Department [DepartmentID: 49]. Using the technique I shared with my co-worker would result in a proc that looks like this:


CREATE PROCEDURE ap_SearchEmployee
(
@EmployeeID int = -1,
@DepartmentID int = -1,
@ManagerID int = -1,
@LocationID int = -1
)

as

SET NOCOUNT ON

SELECT * FROM Employee e
WHERE
(@EmployeeID = -1 OR e.EmployeeID = @EmployeeID)
AND (@DepartmentID = -1 OR e.DepartmentID = @DepartmentID)
AND (@ManagerID = -1 OR e.ManagerID = @ManagerID)
AND (@LocationID = -1 OR e.LocationID = @LocationID)

The where clause checks each parameter to see if it is -1 which means we don’t want to filter our results by that parameter. If the parameter is not -1 it then checks the fields value with that of the parameter. By using this technique my co-worker was able to remove the duplicate logic and nasty if/else blocks within his stored procedure which provided him with a much cleaner solution!

source