Checking existence query?

[Mr. C Lamont Gilbert]

All I want to know is if Name is not null. I have a unique constraint on my name so I need to ensure none exists which is the same as the one I plan to use.

I am using

String qstring = "SELECT Name FROM masterFuncCnctrs WHERE Name = '" + name + "' AND ComponentID = " + component.getID() + ";";

and rs.next() to tell me if such a name exists or not. Is there a better query for this since I am not even looking at the returned name, only if it exists or not.

[Jeanne Boyarsky]

This version is slightly more efficient because the database doesn't have to return as much data.

String qstring = "SELECT count(*) FROM masterFuncCnctrs 
WHERE Name = '" + name + "' AND ComponentID = " + component.getID() + ";";  

Did you want a unique name in general or per component id? The unique index would do it for name only.