http://www.theserverside.com Most recent forum messages en Jive Forums Silver 5.5.30 (www.jivesoftware.com) Sat, 25 May 2013 23:23:51 -0400 http://www.theserverside.com/discussions/thread.tss?thread_id=39681 Thu, 20 Apr 2006 12:23:28 -0400 Thu, 20 Apr 2006 12:23:28 -0400 Thu, 20 Apr 2006 12:23:28 -0400 Apr 20, 2006 Poetic Justice 0 http://www.theserverside.com/discussions/thread.tss?thread_id=39681
Obtain connection
Call connection.setAutoCommit(false)
try{
   operation #1
   operation #2
   operation...]]> Thu, 30 Mar 2006 08:34:06 -0500 Thu, 30 Mar 2006 08:34:06 -0500 Thu, 30 Mar 2006 08:34:06 -0500 Mar 30, 2006 Bob Armour 0 http://www.theserverside.com/discussions/thread.tss?thread_id=39681 select count(*) from mytable

Add a where clause to count the number of rows in a selection:
select count(*) from mytable where surname='Smith'

To get a range:
select * from mytable where...]]> Thu, 30 Mar 2006 03:15:33 -0500 Thu, 30 Mar 2006 03:15:33 -0500 Thu, 30 Mar 2006 03:15:33 -0500 Mar 30, 2006 Einar Valen 1 http://www.theserverside.com/discussions/thread.tss?thread_id=39681
1) Query to get the total number of entries.
2) ?
3) Query and get rows 350,000 - 350,500 of 56,000,000 entries.

How can I ignore a different transactions inserts/deletes at step 2?]]> Wed, 29 Mar 2006 12:45:24 -0500 Wed, 29 Mar 2006 12:45:24 -0500 Wed, 29 Mar 2006 12:45:24 -0500 Mar 29, 2006 Matthew Wilson 3