No, I think im confusing you now :-) in some cases the invoice number is on line 26, and it other cases the invoice number is on line 27. all runs fine when the invoice number is on line 27 because theres nothing on line 26 to print so therfore it leaves it but its messing up when the invoice is on line 26, becase its still checking line 27 aswell. and brings in data from there. I tried your below code but its still doing the same for me, and yes i have it in a loop hope thats makes sence to you ;-)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4