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/
