Any SQL statements to return no records found?

[poolboi]

hey guys,

just wanna know if there's any SQL statements that will help u to determine if a match is found when u use the SELECT statement?
so if the SELECT statement don't match anything it will return false statement or something like that

[code green]

SELECT 1 FROM tablename WHERE condition

[ck9663]

SELECT 1 FROM tablename WHERE condition

To extend this code:

if exists(select 1 from yourtable where yourcondition)
begin
  do this
  and this
  and this
end
else
begin
   do this
   and this
   and that
end

You only need to enclosed it with BEGIN..END if there are two or more statements that needs to be executed in IF or in ELSE.

-- CK

[poolboi]

i'm not sure if the syntax is right
but i think the exists should be enclose within the brackets
my code as said above is

 
   if (exists SELECT 1 FROM `mml log` WHERE Commands LIKE '%$IMSI%')
   begin
      do  
        while(my $ref = $sth->fetchrow_arrayref){
 
                       print "<tr></tr>";
                       for (my $i=0; $i<$numFields; $i++){
                        print "<td>", $$ref[$i], "</td>\n";  
 
   }
}
end  
else
    begin
     do
        print "<p>Sorry! No Records have been found!</p>";
   end
 
 

and i'm getting errors like

a) exist arguement is not a hash or an array
b) number found where operator expected near "SELECT 1" (Do you need to predeclare SELECT?)

[Delerna]

your if should be like

if exists(SELECT 1 FROM `mml log` WHERE Commands LIKE '%$IMSI%')
 
 

also what is `mml log`

if it is a table or view name then it should be like this

if exists(SELECT 1 FROM [mml log] WHERE Commands LIKE '%$IMSI%')
 
 

[poolboi]

hm...if i put the exists outside i'm still getting a synta error
i'm using perl anyway to process this code

[ck9663]

You're mixing PERL and SQL. Check with PERL forum how to connect to sql-server using PERL and how to define data object in PERL and how to process it.Then you pass your select on that connection and process it.

-- CK