Jul 27, 2008 12:25 PM|anas|LINK
all i get back is a 1
yes that's because the passed user name have only one record !
please use sql managemnt studio to test the seelct query for that user and see what will returns
Try to vary the username , try another username , check the data table and see the number of records that belongs to the user