Ibatis query gives many results but only one is needed?
You can limit result set to only one row by adding 'LIMIT 1' to your sql query.
I am optimizing database usage on ibatis SQL queries. I have a situation where the query results many entries but only one of them is needed. QueryForList gives too much extra information through the slow connection and QueryForObjectis not working if result is not unique.
How I should do this? I don't wanna use the list. Get(0) with QueryForListif I just can omit transfering the unnecessary data.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
Is there a Query-Mapper like iBATIS.NET but with dirty tracking, lazy-loading and cascading updates?
One to many relation using mybatis or ibatis?
Ibatis startBatch() only works with SqlMapClient's own start and commit transactions, not with Spring-managed ones?
Hey! Strength gives almost no bonus to damage, but directly increases the chance to hit! What gives?
How many bushels of corn are needed for a typical ethanol plant? How many acres of corn would be needed to satisfy that demand?
How to iterate over results of a linq-to-sql query result and append the results?