From 2c48ceedd81225a4e740d4a86457eafc2b22c86e Mon Sep 17 00:00:00 2001 From: lbsa71 Date: Wed, 13 Feb 2008 21:15:05 +0000 Subject: * Fixed bug in avatarpicker so now you can search on single word [Provided by openlifegrid.com] --- OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'OpenSim/Framework') diff --git a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs index d3a5835..ac45aaa 100644 --- a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs +++ b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs @@ -374,11 +374,10 @@ namespace OpenSim.Framework.Data.MSSQL { Dictionary param = new Dictionary(); param["first"] = querysplit[0]; - param["second"] = querysplit[1]; IDbCommand result = database.Query( - "SELECT UUID,username,surname FROM " + m_usersTableName + " WHERE username = @first OR lastname = @second", + "SELECT UUID,username,surname FROM " + m_usersTableName + " WHERE username = @first OR lastname = @first", param); IDataReader reader = result.ExecuteReader(); -- cgit v1.1