Latest Snippets

Postback - showModalDialog

You'll notice if you do a postback/submit within a dialog window in IE, it posts...

General snippet posted by Christoff Truter on 2009-09-23 07:19:57
View Snippet

 

Set Maximum Request Size

In your web.config, find the system.web node and add the httpRuntime child node,...

ASP.net snippet posted by Christoff Truter on 2009-07-29 11:55:22
View Snippet

 

Force site to run in IE7 Compatibility mode

Recently we developed an intranet application simply using all the microsoft com...

General snippet posted by Christoff Truter on 2009-07-22 10:00:19
View Snippet

 

FileSystemWatcher example

An example of how to monitor the filesystem using the filesytemwatcher class in ...

C# snippet posted by Christoff Truter on 2009-06-27 22:08:12
View Snippet

 

Format Currency

Format a string into a currency format, similar to the FormatCurrency function i...

Javascript snippet posted by www.sonofsofaman.com on 2009-06-12 09:52:50
View Snippet

 

MD5 hash

The following snippet demonstrates how to create a MD5 hash using SQL 2005...

MSSQL snippet posted by Christoff Truter on 2009-06-11 10:01:37
View Snippet

 

Register Globals off

If you don't have access to your php.ini or the ability to set register_globals ...

PHP snippet posted by Christoff Truter on 2009-06-09 11:47:26
View Snippet

 

Table Variables

SQL 2000 introduced an alternative to temporary tables called table variables....

MSSQL snippet posted by Christoff Truter on 2009-06-08 15:59:55
View Snippet

 

MD5 hash

Calculate the MD5 hash of a given string...

C# snippet posted by Christoff Truter on 2009-06-02 14:08:47
View Snippet

 

Row Number

How to number rows of a query using mysql...

MySQL snippet posted by Christoff Truter on 2009-05-22 14:36:53
View Snippet

 

Snippets

Row Number

How to number rows of a query using mysql 

set @c:= 0;
select someid, @c:=@c+1 as rownumber 
from sometable


posted by Christoff Truter on 2009-05-22 14:36:53

 

Comments

Alternative row numbering

select someid, @c:=@c+1 as rownumber
from sometable, (select @c:=0) c


comment posted by Christoff Truter on 2009-05-22 14:38:51

 


Write a comment

* *
*

* Required fields

Latest MySQL Snippets

Row Number

How to number rows of a query using mysql...

posted by Christoff Truter on 2009-05-22 14:36:53
View Snippet