Re: empty set in mysql

[red blue]

thanks worked a treat for any1 else who is having same problems this is what i did

select count(variable) from tablename where colomname = something;

this then came back as

count(variable)
0

then in java i did a sql search with a resultset
i got the value like this
int num = rs1.getInt("count(variable)){
re-direct code
}
hope that help others