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 [I]tablename[/I] WHERE [I]condition[/I]

[ck9663]

SELECT 1 FROM [I]tablename[/I] WHERE [I]condition[/I]

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

[CODE=perl]

if (exists SELECT 1 FROM `mml log` WHERE Commands LIKE '%$IMSI%')
begin
do
while(my $ref = $sth->fetchrow_array ref){

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

[/CODE]

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

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

[/code]

also what is `mml log`

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

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

[/code]

[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