herber-consulting.de - db2 log switch, ifxclone doesn't work in ids growth edition
jimlife.wordpress.com - mysql row number, mysql record numberHi I move my blog to my own domain http://www.jimmod.com/blog
My Life 11:32 pm
Hi..
After long time didn’t update my blog I decide to buy a domain name & move this blog to the new domain.
Please post comment at that new blog. (http://jimmod.com/blog/)
Thanks
Comments Off
My Life 6:15 pm
I move the blog to my new domain, please visit : http://jimmod.com/blog/2008/09/displaying-row-number-rownum-in-mysql/ for latest update
Sometimes you need to do query with MySQL for reporting.
And you’ll need to display the row number/ranking in query result.
Example you have this table:
table : player
fields : playerid, name & score
For reporting purpose you need to query the top 10 (highest score).
The result should be : rank, memberid, name, score.
Example :
rank playerid name score
———————————–
1 A1029 Jimmy 100
2 A9830 Lia 98
3 B28d0 Lulu 90
…
…
10 B8789 Lele 50
Now you can easily query the top 10 by using ‘limit’ and ‘order by’, but how to automatically add row number in query result?
Here’s how you do it:
select @rownum:=@rownum+1 ‘rank’, p.* from player p, (SELECT @rownum:=0) r order by score desc limit 10;
Try it 
This will create a variable rownum, initialize with value 0 & increase it by 1 for every record
Technorati Tags: mysql, select, query, rownum, row number, rank
guru4.net - scienza branche, capcha guruGURU4.net offre gratuitamente risorse e soluzioni per sviluppatori Web: script, articoli, suggerimenti, librerie complete, codice sorgente liberamente utilizzabili per lo sviluppo di pagine Web
La libreria AJAX "JavaScript SOAP Client" che consente di sfruttare la potenza e la semplicità dei Web Services per creare applicazioni dinamiche
Il framework open-source "Caching Library" per la gestione avanzata della cache di ASP.NET
kodyaz.com - activate windows 7, how to activate windows 7SQL Server and SQL tutorials, Reporting Services, OLAP, Windows 7 tools and Windows 8, Purble Place, SAP ABAP and SAP Smartforms development, Visual Studio, Javascript codes, ASP.NET
anaesthetist.com - javascript calculator, preparation and priof reptilase test
|
microshell.com - xml ampersand, max in datediff in mysqlLearn something share something
apostylee.com - webservis, asp.net web serviceasp.net, jquery ve diger web teknolojileri uzerine, birazda kisisel yazilarim
aspguy.wordpress.com - how to reduse page size in wordpress, mvc 3.0 downloadHave you ever thought that how does Google perform a fast search on a wide variety of file types? For example, how Google is able to suggest you a list of search expressions while you are typing in your keywords?
Another example is Google image search: You upload an image and Google finds the similar photos for you in no time.
The key to this magic is SimHash. SimHash is a mechanism/algorithm invented by Charikar (see the full patent). SimHash comes from the combination of Similarity and Hash. This means that instead of comparing the objects with each other to find the similarity, we convert them to an N-bit number that represents the object (known as Hash) and compare them. In the other words, if instead of the object, we maintain a number that represents the object, so that we will be able to compare those numbers to find the similarity of the two objects.
The basics of SimHash are as below:
Since the hash value can be used to represent any kind of data, such as a text or an image file, it can be used to perform a fast search on almost any file type.
To calculate the hash value, we have to decide the hash size, which normally is 32 or 64. As I said before, an unsigned value works better. We also need to choose a chunk size. The chunk size will be used to break the data down to small pieces, called shingles. For example, if we decide to convert a string such as “Hello World” to a hash value, If the chunk size is 3, our chunks would be:
1-Hel
2-ell
3-llo
Etc.
To convert a binary data to a hash value, you will have to break it down to chunks of bits. E.g. you have to pick every K bits. Google says that N=64 and K=3 are recommended.
To calculate the hash value in a SimHash manner, we have to take the following steps:
Here is the code:
private int DoCalculateSimHash(string input)
{
ITokeniser tokeniser = new Tokeniser();
var hashedtokens = DoHashTokens(tokeniser.Tokenise(input));
var vector = new int[HashSize];
for (var i = 0; i < HashSize; i++)
{
vector[i] = 0;
}
foreach (var value in hashedtokens)
{
for (var j = 0; j < HashSize; j++)
{
if (IsBitSet(value, j))
{
vector[j] += 1;
}
else
{
vector[j] -= 1;
}
}
}
var fingerprint = 0;
for (var i = 0; i < HashSize; i++)
{
if (vector[i] > 0)
{
fingerprint += 1 << i;
}
}
return fingerprint;
}
And the code to calculate the hamming distance is as below:
private static int GetHammingDistance(int firstValue, int secondValue)
{
var hammingBits = firstValue ^ secondValue;
var hammingValue = 0;
for (int i = 0; i < 32; i++)
{
if (IsBitSet(hammingBits, i))
{
hammingValue += 1;
}
}
return hammingValue;
}
You may use different ways to tokenize a given data. For example you may break a string value down to words, or to n-letter words, or to n-letter overlapping pieces. From my experience, if we assume that N is the size of each chunk and M is the number of overlapping characters, N=4 and M=3 are the best choices.
You may download the full sou
devtrends.co.uk - how disable jquery addmethod rule by condition, asp.net mvc 3.0 jquery select list
This site was
ibphoenix.com - firebird, open source databaseIBPhoenix is the premier portal for the Firebird Open Source Relational database, and the leading provider of information andservices to Firebird developers and users, those who develop applications on Firebird and those who develop the underlying Firebird database engine itself.
Un ensemble complet autour de Firebird : IBPhoenix publie son 20ième DVD Développeurs.
Le DVD Développeurs contient le livre The Firebird Book: a Reference for Database Developers - Edition II (Beta), ainsi que les binaires et programmes d'installation de toutes les dernières versions de Firebird (1.0.x, 1.5.x, 2.0.x. 2.1.x et 2.5) et les autres logiciels relatifs à Firebird. Le DVD contient aussi la documentation, les drivers, outils et le code source. Vous trouverez aussi dans ce DVD une application permettant de parcourir et faire des recherches sur les archives d
sqlservercodebook.blogspot.com - mssql how to remove substring to string, update data from one table to another
While browsing the SQL Server newsgroups, every once in a while, I see a request for a script that can search all the columns of all the tables in a given database for a specific keyword. I never took such posts seriously. But then recently, one of my network administrators was troubleshooting a problem with Microsoft Operations Manager (MOM). MOM uses SQL Server for storing all the computer, alert and performance related information. He narrowed the problem down to something specific, and needed a script that can search all the MOM tables for a specific string. I had no such script handy at that time, so we ended up searching manually.
That's when I really felt the need for such a script and came up with this stored procedure "SearchAllTables". It accepts a search string as input parameter, goes and searches all char, varchar, nchar, nvarchar columns of all tables (only user created tables. System tables are excluded), owned by all users in the current database. Feel free to extend this procedure to search other datatypes.
check out these link
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
http://it.toolbox.com/wiki/index.php/Get_Records_from_ANY_table_in_a_Database_Matching_Specified_Value
cloudant.com - mango couchdb, lucene exact search with couchdbCloudant data layer as a service with elastic scaling. Start for free. Powered by CouchDB, JSON, MapReduce.
logiclabz.com - sql server split, javascript copy to clipboardLogiclabz is a Website Design & Development company with a group of talented individuals having 10 years of Software development experience.
Logiclabz
a programming laboratory
projectdmx.com - t-sql replace, select 1)a join
|
| Home | Database Fundamentals | Data Exchange | Design | Transact SQL | About |
|
WELCOME Welcome to the data management and exchange project website. My name is Anith and I am an independent database consultant. Though, I usually work on multiple projects in parallel, over the past few months or so, I have been working exclusively for a small wealth management firm in west Tennessee. If you’d like to know more about my background, the kind of work I do and my professional qualifications, please check out the authors section of this site. I started this site about two years ago as a training platform to benefit a couple of clients I had consulted previously. Moreover, I needed an avenue to be partly involved with developing software for database access and data exchange using .NET framework. A large portion of the internal contents are about programming basics, elementary software development principles and fundamentals of relational database management. A few of the pages, primarily related to the D |
mackey.ie - ctrl alt del remote desktop, using left join and where clause
idealprogrammer.com - learn vb.net in 24 hours, vb.net code generator1,300 hours of .net video tutorials on asp.net, visual basic.net, c-sharp, sql server, visual studio, and much more.
cachemiss.com - su - informix, debian 6 libct3 sqsh sybase asa
devdaily.com - mysql create user, mysql show usersTutorials for Java, Linux, Mac OS X, iPhone, iPad, Android, Drupal, MySQL, UML, software quality, testing, and more.
omegacoder.com - c# dictionary, dictionary c#
One can get lost in the weeds when upgrading an asp.net .Net 1 website to anything from .Net 2 through .Net 4. One of the biggest problems after the initial conversion is that when built each page or control throws a build error:
Could not load type ‘MyNamespace.myWebPage’.
The issue stems from the fact that things changed, made life easier for new projects, and namespaces which were required were removed and certain attributes changed. To resolve the above issue follow these steps presented in this article.
namespace MyNamespace
{
public class myWebPage : System.Web.UI.Page {}
}
public partial class myWebPage : System.Web.UI.Page { ... }
Which initially looks like this:
<%@ Page language="c#" AutoEventWireup="false"
Codebehind="myWebPage.aspx.cs"
Inherits="MyNamespace.myWebPage" %>
The result should look like this:
<%@ Page language="c#" AutoEventWireup="false"
Codefile="myWebPage.aspx.cs"
Inherits="myWebPage" %>
One of the basic tenets of WYSIWYG is to be able to create a rubber band region using the mouse to give the user the ability to create a selectable region. This article demonstrates how to do that in any version of Silverlight and the user is given the tools to create such a bounding rectangle in any circumstances via the usage of some basic building blocks in Silverlight.
The below picture (not the one on the left) shows our goal, the dynamic creation of a bounding rubber band (a rectangle control for this demonstration) in a canvas. The below canvas is drawn in black (visually grey due to the opacity set) while the bounding rectangle shows itself in red.
The user starts the process with an initial click which designates a start location of an upper left point for our bounding box with a mouse click. Once the click happens the mouse cursor changes to a hand (if moving to the lower right) as a visible indicator that the process has started. While user continues to move to the lower right the band grows and while the mouse button has yet to be let go or released. For the demo a bounded number is shown is which relates the actual dynamic change in the X (horizontal) position. That is done for this article only and the above picture shows the rectangle with an X size of 123 pixels and can still be grown as shown by the hand icon.
In the page’s xaml
itlearner.com - 成语, 一呼百应IT学习者为广大奋斗在IT互联网站线的朋友们提供重要的IT资讯，并更多提供草根站长需要的技术文章，建站技巧等信息。
javafaq.nu - java byte signed, java compare timeEasy Learn Java: Programming Articles, Examples and Tips :
| |||||||||||||||||||
|
|
oreilly.de - ios5 programming cookbook, web 2.0Der O'Reilly Verlag ist die deutsche Niederlassung des international erfolgreichen Verlages O'Reilly Media, Inc. Die Bücher beschäftigen sich u. a. mit der Programmierung (Java, Perl, PHP), Betriebssystemen (Linux/Unix/Mac/Windows), Web-Entwicklung (XML) und Web Services.
mattsbits.co.uk - standard web banner sizes, convert email address text to image php
programmingsolution.net - tree structure jquery, ajax tree menu exampleProgramming Solutions Your Source for Information on C#,Visual Basic,PHP,JavaScript,CSS,HTML,JQuery,C# Asp.net,Visual Basic Asp.net
Category: SQL
Category: Asp.Net
Category: MDX
wow-v.com - brainiac on the tesnexu, wow vCreate, Share, and Download custom items and mobs for private WoW servers!
|
|
DONATE |
|
mirthcorp.com - mirth, mirth connectMirth Corporation develops and implements Healthcare Interoperability and Interconnectivity solutions. Mirth Connect, an Open Source software solution provides the HL7 integration engine for the Healthcare Mirth Messaging Appliances.
superasp.com.br - asp imagens dinamica, asp flushPortal de programacao ASP, Artigos, forum , script , codigos, download, ecommerce, loja virtual, loja , comércio eletrônico
Cadastre-se
ASP Spawned Mailer: O Spawned Mailer e muito facil de instalar. O usuário poderá adicionar email no seu newsletter e você irá ter um administrador para administrar toda a lista de emails.
Proteção de senha de ASP para WebPages: A senha restringi o acesso para as páginas do Web.
F-Mail 2.0: Sistema de email que utiliza o componente ASP CDONTS baseado em um banco de dados o qual tem uma página de administração completa com acesso restrito e como opção de incluir, deletar ou alterar os dados do banco e o melhor de tudo é que é totalmente grátis. O sistema possui duas opções para envio de e-mails, em uma delas é enviado e-mail para todos cadastrados no banco de dados e a outra é listado o nome de todos os cadastrados no banco e você seleciona uma pessoa para mandar-lhe um e-mail. www.f-mail.cjb.net - suporte@f-mail.cjb.net
Tutorial ASP: Um pequeno tutorial sobre a linguagem ASP.
Objetos do ASP(objeto Response ): O objeto Response se refere a todos os dados enviados do servidor para o cliente...
Visual Interdev: Tutorial em html muito bom de Visual Interdev em Inglês
Livro de Visitas em ASP: Saiba como criar um livro de Visitas em ASP.
Checkbox com mais de uma opção: Saiba como criar um checkbox com mais de uma opção.
Index Server para buscas em seu site: O Index Server é um aplicativo para o NT 4.0 / 2000 que faz uma busca no seu site.
Gerando Css janelas dinamicamente: Gerando Css janelas dinamicamente em ASP
Ver usuários online e ver onde estão.: Script bastante útil se você deseja detalhes sobre quem e onde estão os usuários no seu site.
Acesso ASP em Access via COM+ com exemplos: Acesso ASP em Access via COM+ com exemplos em ASP e Visual Basic
Dúvida ao filtrar datas(0) Populando combos dentro do recordset(0) vagas para programador ASP em Sã...(0) script loja virtual(0) MSN QUEM MEXE COM ASP PARA ME AJUDAR...(1) Surra no ASP form to email script(0) Ajuda com Isapi rewrite 3.0(0) Como funciona o componente GenSession...(0) ARQUIVO ENVIO DE EMAIL COM ANEXO VIA ...(0) ENVIO DE FORMULARIO COM ANEXO(0) Ajuda JS(0) Erro Aprovar comentários.(0) ASP - Global.asa em Aplicaçõ...(0) Transformar linhas em colunas(0)
VBScript
Erros
ASP
Abs ( )Mid ( )Array ( )Asc ( )Atn ( )CBool ( )Cbyte ( )Ccur ( )Cdate ( )CDbl ( )AscB ( )AscW ( )Chr ( )CInt ( )Clng ( )Cos ( )CreateObject ( )CSng ( )CStr ( )Cdate ( )Day ( )Eval ( )Exp ( )Filter ( )Fix ( )FormatCurrency ( )FormatDateTime ( )FormatNumber ( )FormatPercent ( )GetLocale ( )GetObject ( )GetRef ( )Hex ( )Hour ( )InputBox ( )InStr ( )InStrB ( )InStrRev ( )Int ( )IsArray ( )IsDate ( )IsEmpty ( )IsNull ( )IsNumeric ( )IsObject ( )Join ( )LBound ( )Lcase ( )Left ( )LeftB ( )Len ( )LenB ( )LoadPicture ( )Log ( )LTrim ( )MidB ( )Minute ( )Month ( )MonthName ( )MsgBox ( )Now ( )Oct ( )Replace ( )RGB ( )Right ( )RightB ( )Rnd ( )Round ( )RTrim ( )ScriptEngine ( )SEBV ( )SEMV ( )SEMV ( )Second ( )SetLocale ( )Sgn ( )Sin ( )Space ( )Split ( )Sqr ( )StrComp ( )String ( )StrReverse ( )Tan ( )Timer ( )TimeSerial ( )TimeValue ( )Trim ( )TypeName ( )UBound ( )UCase ( )VarType ( )WeekDay ( )WeekdayName ( )Year ( )Date ( )DateAdd ( )DateDiff ( )DatePart ( )DateSerial ( )DateValue ( )
800A03E9800A03EA800A03EB800A03ED800A03EE800A03EF800A03F2800A03F3800A03F4800A03F5800A03F6800A03F7800A03F8800A03F9800A03FA800A03FB800A03FC800A03FD800A03FE800A03FF800A0400800A0401800A0402800A0403800A0404800A0405800A0406800A0407800A0408800A0409800A040A800A040D800A040E800A040F800A0410800A0411800A0412800A0413800A0414800A0415800A0416800A0417800A0418800A0419800A041A800A041B800A041C800A041D800A041E800A041F800A0420800A0421800A0422800A0005800A0006800A0007800A0009800A000A800A000B800A000D800A000E800A0011800A001C800A0023800A0030800A0033800A0034800A0035800A0036800A0037800A0039800A003A800A003D800A003E800A0043800A0044800A0046800A0047800A004A800A004B800A004C800A005B800A005C800A005E800A0142800A01A8800A01AD800A01AE800A01B0800A01B6800A01B8800A01BD800A01BE800A01BF800A01C0800A01C1800A01C2800A01C3800A01C5800A01C7800A01C9800A01CA800A01CE800A01E1800A01F4800A01F5800A01F6800A01F7800A01F8800A01F9800A01FA800A1398800A1399800A139A800A139B800A139C800A139D800A802B800A03E9800A03EA800A03EB800A03EC800A03ED800A03EE800A03EF800A03F0800A03F1800A03F2800A03F3800A03F4800A03F5800A03F6800A03F7800A03F8800A03FA800A03FB800A03FC800A03FF800A0400800A0401800A0402800A0403800A0404800A0405800A0406800A0407800A0408800A0409800A040A800A040B
ASP 0100ASP 0101ASP 0102ASP 0103ASP 0104ASP 0105ASP 0106ASP 0107ASP 0108ASP 0109ASP 0110ASP 0111ASP 0112ASP 0113ASP 0114ASP 0115ASP 0116ASP 0117ASP 0118ASP 0119ASP 0120ASP 0121ASP 0122ASP 0123ASP 0124ASP 0125ASP 0126ASP 0127ASP 0128ASP 0129ASP 0130ASP 0131ASP 0132ASP 0133ASP 0134ASP 0135ASP 0136ASP 0137ASP 0138ASP 0139ASP 0140ASP 0141ASP 0142ASP 0143ASP 0144ASP 0145ASP 0146ASP 0147ASP 0148ASP 0149ASP 0150ASP 0151ASP 0152ASP 0153ASP 0154ASP 0155ASP 0156ASP 0157ASP 0158ASP 0159ASP 0160ASP 0161ASP 0162ASP 0163ASP 0164ASP 0165ASP 0166ASP 0167ASP 0168ASP 0169ASP 0170ASP 0171ASP 0172ASP 0173ASP 0174ASP 0175ASP 0176ASP 0177ASP 0178ASP 0179ASP 0180ASP 0181ASP 0182ASP 0183ASP 0184ASP 0185ASP 0186ASP 0187ASP 0188ASP 0189ASP 0190ASP 0191ASP 0192ASP 0193ASP 0194ASP 0195ASP 0196ASP 0197ASP 0198ASP 0199
