Yup... one of those random Friday afternoon stumpers If I have a table of transactions like this little thing here. With SQL how would I grab ID 2 based on the face that ID 3 is 0
I need to get the next successful transaction after a failed transaction but not sure how to go about it. ID Approved Date 1 1 -7/6/2009 2 1 -7/5/2009 3 0 -7/4/2009 4 1 -7/3/2009 5 0 -7/2/2009 6 1 -7/1/2009 -- Casey ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
