ranjan_jajodia has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks,
I have written a script which checks if an id is already present in the database and depending on that it does other things. Following is the part of the code where i have confusion:
$mysql->query(q{select id from id_table where id = '1'}); if ( $mysql->has_selected_record) { #do something; } else { #do something else }
In the above 'if loop', the condition always return true even if the id is not present in the table. Am i misunderstanding the use of 'has_selected_record()'? If yes how do i know whether the query has returned result or not? I understand I can create an iterator and get the exact result but i don't think that is needed because
1) I don't want the result- I just want to know whether there is a result or not.
2) The query will be excuted a lot of times and creating iterator each time will not be resource friendly.
I have gone throught the documentation present at CPAN along with the module Net::MySQL but unfortunately did not get much info. Could you please clear my doubt?


--Let Logic Rule--