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 BEGIN /*Here I put my action if Recornum=0 */ EXEC _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists