You could do it with cf. <cfif queryname.recordcount eq '0'>
Then do what you need to do. Thank you. Steve Burcham Webmaster RDO Equipment Co. Phone (701) 239-8755 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: 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 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 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
