View Single Post
Old Jun 27th, 2007, 11:31 AM   #4
programmingnoob
Hobbyist Programmer
 
Join Date: Feb 2006
Posts: 154
Rep Power: 3 programmingnoob is on a distinguished road
Quote:
Originally Posted by Infinite Recursion View Post
I suggest your alternative approach, but make sure you take the case sensitivity into consideration. Depending on how you query the database, normally you could determine if the query yielded any results based on how many records were returned from the query.

The "already exists" error is something that can be handled also, again, depending on how you are connection to the database and which method you are using to submit transactions.
oh I know how to deal with 'already exists' error....
what I was asking is what does it do when I execute the below command using C#
select * from tablename where name = 'example';
then if there is no 'example' entry in name column, then what does it return to C#, that I could check against?
I know I am not saying it in a very clear way...
programmingnoob is offline   Reply With Quote