Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
crugerenator
Posting Yak Master
126 Posts |
 Posted - 2010-07-01 : 13:10:12
|
| I was hoping it might be possible to return a result set if a query actually returns results, but if the query returns nothing, is it possible to return false?Example in psuedo code:select * from table where id=555if results > 0, return results, else return false.Thanks! |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-07-01 : 13:24:02
|
quote:
Originally posted by crugerenator
I was hoping it might be possible to return a result set if a query actually returns results, but if the query returns nothing, is it possible to return false?Example in psuedo code:select * from table where id=555if results > 0, return results, else return false.Thanks!
Isn't this part supposed to be handled by your BLL if you have a front end.Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-07-01 : 13:34:56
|
quote:
Originally posted by X002548
quote:
Originally posted by IderaIsn't this part supposed to be handled by your BLL if you have a front end.
What?Now we're suppose to make sense of what they post?sheeesshBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam
lol  Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
|
|
|
|
|
|
return true or false depending on results?