1. how to find out how many records returned in recordSet coderanch.comKola wrote : "Do i have to loop through the recordset to find out how many results were returned?" yes, this is the only way i know to get this information. I'm not a SQL expert and dont know if there's a SQL statement to bring this kind of information into the resultset, but it's a interesting subject of study. |
2. finding the closest time in database record coderanch.com |
3. Find record on a form from a combo box coderanch.com |
4. Can't find record in 'tablename' on select in MqSql coderanch.comi am getting Can't find record in 'tablename' error. I am using MySql. What is cause for this error? As I know if we insert and delete from a table while selecting from the same table, We can get this error. but what is my doubt is we also get 'lock wait time out exception'. Can any one clarify this. In ... |
5. Can't find record in 'tablename coderanch.comi am getting Can't find record in 'tablename' error. I am using MySql. What is cause for this error? As I know if we insert and delete from a table while selecting from the same table, We can get this error. but what is my doubt is we also get 'lock wait time out exception'. Can any one clarify this. In ... |
6. Need help in find the text from 1000 Records coderanch.com |
7. Find geographical records based on zip code and radius coderanch.comI want to find geo records based on zip code and a radius. It does not have to be very accurate, so curvature of the earth based on lat and long are not necessary. But I do need some general calculation to do this. Also, I am using Hibernate, so it would be nice to shoehorn the calculation into HSQL Here ... |