Skip to Content
Former Member
Apr 08, 2010 at 07:17 PM

Select Options Invalid Entries FOr Select Statement


Hello All,

I have 4-6 Single value entries in my select options say s_test. And Im using this in select statement, I want to catch the s_test entries where it doesn't find entries in the SELECT Statement. How do i achieve this? I tried searching the forum but didnt get any help.

I'm putting it as

select * from ztable where zfield in s_test.

s_test has like 5-6 entries and if the 4th entry is not there in the table I need to catch that. I dont want to loop around s_test and catch it instead is ther any other easy way.