RecordNum =0

2002-04-18 Thread Mario Martinez R.
Is that down here correct?? I'm trying to detect is this query does not retrieve any row. It does not work for me. Ideas?? Thanks friends Mario SELECT Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux IF Count=0

RecordNum =0

2002-04-18 Thread Mario Martinez R.
Is that down here correct?? I'm trying to detect is this query does not retrieve any row. It does not work for me. Ideas?? Thanks friends Mario SELECT Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux IF Count=0

RecordNum =0

2002-04-18 Thread Mario Martinez R.
Is that down here correct?? I'm trying to detect is this query does not retrieve any row. It does not work for me. Ideas?? Thanks friends Mario SELECT Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux IF Count=0

RE: RecordNum =0

2002-04-18 Thread Burcham, Steve
: Thursday, April 18, 2002 2:33 PM To: CF-Talk Subject: RecordNum =0 Is that down here correct?? I'm trying to detect is this query does not retrieve any row. It does not work for me. Ideas?? Thanks friends Mario SELECT @Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux

RE: RecordNum =0

2002-04-18 Thread VAN VLIET, SCOTT E (SBCSI)
-Talk Subject: RecordNum =0 Is that down here correct?? I'm trying to detect is this query does not retrieve any row. It does not work for me. Ideas?? Thanks friends Mario SELECT @Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title