Database returns no results
Hopefully an easy question for you pros. I'm having a minor issue when there are no results in the database for a query. It's trying to set a variable to the results and if there are no results it tosses an exception. How can I script for no results?
Re: Database returns no results
Hey again all,
I found a resolution and thought I would share. I set this particular variable to NULL before it enters the loop where it will be defined, then I placed an IF statement to handle if null.
If you have a better way of handling this please let me know. Also if you have questions about what I did (as I may have been too vague) I'll be happy to answer.