Selectall

We Share What We Get

  • Archives

Broklyne Bridge

Posted by selectall on October 25, 2009

Posted in Interesting | Leave a Comment »

Creating a single field from multiple row results

Posted by selectall on August 9, 2009

select stud_id , group_concat(paper_id) as i from tb
group by id

Original Table:
stud_id paper_id
1 1
1 2
1 3
1 4
2 2
2 3
3 1
4 2

Output:
stud_id paper_id
1 1,2,3,4
2 2,3
3 1
4 2

Posted in MS SQL 2005, Mysql Stuff | Tagged: , , | Leave a Comment »

Fast Folder Access

Posted by selectall on August 4, 2009

Fast Folder

Fast Folder Access is a shell enhancement that gives you fast access to your favorite folders in Common Open/Save dialogs, in Windows Explorer, the desktop and the Start Button.

It’s also an add-on for viewing images in Windows Explorer that lets you right-click on an image file to bring up a miniature image and image file information

Features

1 Fast access to folders in comman Open/Save -dialogs.

2 Fast access to folders in Windows Explorer and the desktop Read the rest of this entry »

Posted in IT Tech. | Tagged: , , , | Leave a Comment »

SeaMonkey

Posted by selectall on August 3, 2009

SeaMonkey 1.1.17

Web-browser, advanced e-mail and newsgroup client, IRC chat client, and HTML editing made simple — all your Internet needs in one application.

he SeaMonkey® Project

The SeaMonkey project is a community effort to develop the SeaMonkey all-in-one internet application suite (see below). Such a software suite was previously made popular by Netscape and Mozilla, and the SeaMonkey project continues to develop and deliver high-quality updates to this concept. Containing an Internet browser, email & newsgroup client, HTML editor, IRC chat and web development tools, SeaMonkey is sure to appeal to advanced users, web developers and corporate users.

powered by Mozilla Under the hood, SeaMonkey uses much of the same Mozilla source code which powers such successful siblings as Firefox, Thunderbird, Camino, Sunbird and Miro. Legal backing is provided by the Mozilla Foundation.

Posted in IT Tech. | Tagged: , , , | Leave a Comment »

Number To English

Posted by selectall on July 28, 2009

NumberToEnglish conWord = new NumberToEnglish();

dt.Columns.Add(“AmountInWord”, Type.GetType(“System.String”));

DataRow row2;

row2 = dt.Rows[0];

row2["AmountInWord"] = conWord.changeCurrencyToWords(sTHeadAmount.ToString());

Posted in ASP.net C# | Leave a Comment »

Compute Function for data table

Posted by selectall on July 28, 2009

int TotalAmount = Convert.ToInt32(dtTotalAmt.Compute(“SUM(amount_pay)”, “amount_pay > 0″));

RemAmount = RemAmount – HeadTotalAmount;

Posted in ASP.net C# | Tagged: , , | Leave a Comment »