I have to add that this is just the reason why I stress using spaces between signs, variables, Boolean operators, and a liberal use of parentheses.
> -----Original Message----- > From: Jerry Banker [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 08, 2008 4:46 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Universe 10.1 Itype possible parsing problem > > What it is doing is evaluating as: > If @record is less than 3 is greater-than or equal to @record<6> then 1 > else -1 > Or > In other words: > If 0 is greater-than or equal to 20071217:224240 then 1 else -1 > > > -----Original Message----- > > From: john reid [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, January 08, 2008 3:57 PM > > To: list > > Subject: [U2] Universe 10.1 Itype possible parsing problem > > > > In the following query, a file is listed with two identical itypes, > > save for field 2 spacing, as shown below. Fields 3 and 6 are all equal > > in the query shown. > > > > The difference is that there is no space between the > and = . This > > appears to yield wrong results, the bad one being shown as field 2 > > (all minus ones) in the query. > > Anyone seen this? > > john > > field 3 field 6 > > 1 -1 20071217:224240 20071217:224240 > > 1 -1 20071218:165115 20071218:165115 > > 1 -1 20071217:211056 20071217:211056 > > 1 -1 20071218:105346 20071218:105346 > > > > -- > > IF @RECORD<3> = @RECORD<6> THEN "1" ELSE "-1" > > IF @RECORD<3>= @RECORD<6> THEN "1" ELSE "-1" > > john > > ------- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
