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]]
I have done this before, and here is what worked for me:
DECLARE @RecordCount int
SET @RecordCount = SELECT COUNT(COLUMNNAME)
FROM TABLENAME
WHERE CONDITION = SOMETHING
IF @RecordCount 0
BEGIN
...
I think you are
2 matches
Mail list logo