Yes, that is why my code set invoice = "". Then set invoicenumber = line 26. Go to line 27 if invoicenumber has a length then continue on, if not set the invoice number to the value on line 27.
Ok, so my code didn't work... Is something else changing invoice number? Can I see the whole loop. If you don't want to share with everyone you can send it directly to me at sd1985 (at) att (dot) com Steve -----Original Message----- From: Damo Drumm [mailto:damien.dr...@quinn-group.com] Sent: Wednesday, October 21, 2009 11:36 AM To: cf-talk Subject: Re: Checking line 26 or 27 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:327450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4