google-code-export / webpasswordsafe

Automatically exported from code.google.com/p/webpasswordsafe
0 stars 3 forks source link

can't search for password when using MSSQL database #34

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Deploy using MSSQL Server database
2. Try to do any password search
3. Get errors

What is the expected output? What do you see instead?
1. Should be able to search and view passwords without errors

Original issue reported on code.google.com by joshdrum...@gmail.com on 31 Dec 2010 at 12:14

GoogleCodeExporter commented 9 years ago
MSSQL doesn't allow DISTINCT keyword for columns of type TEXT, which the notes 
field included in the password search sql query is of type text.

Original comment by joshdrum...@gmail.com on 31 Dec 2010 at 12:15

GoogleCodeExporter commented 9 years ago

Original comment by joshdrum...@gmail.com on 3 Jan 2011 at 7:27