Hi everyone, Could you point out what is wrong the count and the while loop below?
Here is part of the script: ---------------- $sql_alias = qq( select aliasName = l.name from master..syslogins l, $eachdb..sysusers u, $eachdb..sysalternates a where a.suid = l.suid and a.altsuid = u.suid and u.name = "dbo" order by l.name ); &sybase_connect("$eachserver",'master',"$sql_alias"); $count = 0; while( my @aliasdata = $sth->fetchrow_array){ print "$aliasdata[0]"; $count_alias = $count++ ; if ($count_alias == 0){ print FILE<<EOF ------------------------------------- There is no dbo alias user in $eachdb --------------------------------------- EOF ; }#end if else{ print FILE<<EOF ------------------------------------------------- Alias Name Aliased User ------------------------------------------------- $aliasdata[0] dbo EOF ; ----------------------------- ########this is the resule of the output file######## # but this is NOT what i want -------------------------------------------------- There is no dbo alias user in FCCSUN26W..cdbs -------------------------------------------------- ------------------------------------------------- Alias Name Aliased User -------------------------------------------------- jchamber dbo -------------------------------------------------- Alias Name Aliased User ------------------------------------------------- lnagy dbo ------------------------------------------------- Alias Name Aliased User ------------------------------------------------- rvenkata dbo #### This is what I WANT for the out put #either print ----------------------------------- there is dbo alias found in this db ------------------------------------ ### or print -------------------------------------------- Alias Name Aliased User --------------------------------------------- jchamber dbo lnagy dbo rvenkata dbo __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]