Wow... I just re-read what I wrote. I sounded like a jerk didn't I. Sorry about that didn't mean it that way.
-----Original Message----- From: DURETTE, STEVEN J (ATTASIAIT) Sent: Wednesday, October 21, 2009 11:15 AM To: cf-talk Subject: RE: Checking line 26 or 27 I think the logic is a little off. You only need either line 26 or line 27. <cfset invoicenumber = "" /> <cfif lineNumber is 26 and len(i)> <cfset invoiceNumber = trim(right(left(I, 74), 20)) /> </cfif> <cfif previousLineNumber is 26 and not len(invoicenumber)> <cfset invoiceNumber = trim(right(left(I, 74, 20)) /> </cfif> That will set invoice number to the value in either 26 or 27 (I assumed this was in a loop). Having a bigger section of code would have helped more. Also, there is probably a cleaner way to do this, I just did it on the fly right now. Steve -----Original Message----- From: Damo Drumm [mailto:damien.dr...@quinn-group.com] Sent: Wednesday, October 21, 2009 9:23 AM To: cf-talk Subject: Re: Checking line 26 or 27 All i need it to do is, check if line 26 has text in it, and if so not to check line 27 this piece of code is doing part of that, only its checking Line 27 also and inputting whats in it also <cfif previouslinenumber eq 26> <cfset linenumber = 27> </cfif> <cfif (linenumber eq 26) OR (linenumber eq 27)> <cfset invoicenumber = trim(right(left(i,74),20))> <cfif (invoicenumber neq previousnumber) AND (invoicenumber neq "")> </cfif> >>>The Invoice will not change > >This is absolutely true,... until the guy who said it will not change is >changed ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4