If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: getting count of query??? how?

hi all

ive got a problem once again.
i have a normal select query of the form:

select x,y,z from abc,def where conditions

now problem is that before executing the query itself i need to chk the count of the result itll return( that is num of rows that will be returned by my query) and only if the count matches a certain value want to execute it . If anyone knows how i can do ths please help me out with whatever hints/code u can..
thnx

-shuchi

You try and try again..but then give up, there's no sense in being a complete fool about it!!!

oops ok i managed to get that..duhh used @@rowcount!..lol!
ok new problem tho..before using value of rowcount i have to specify the query ofcourse but i dont want it displayed.
any way i can select the relevant rows via a query but not display it as output but the rowcount value shud be updated

ne ideas..?hope there isnt another function for this!

-shuchi

You try and try again..but then give up, there's no sense in being a complete fool about it!!!