So I have a numeric field and perform a search for that fields equals a parameter sent.
if (tbltransactions.find())
{
tbltransactions.idtran = paramId
var nRows = tbltransactions.search()
}
Ok, no confusion there. Now, when the paramId variable contains an empty string, the search returns all rows! The reason why it can be an empty string is because it comes from an XML sent to a WebService. This can be easily fixed by validating the type of data of the parameter or checking if its an empty string, that’s what I’m doing so no problem there.
The issue is, is that the way it should behave? I understand I shouldnt be comparing different datatypes, maybe I’m missing something, but wouldnt it be more appropriate for it to return 0 rows instead?
Working with Version: 6.1.0 - build 1418
Regards,
JD