And perhaps a design of using the license plate as the id, and the offense(s) as a multivalued field would have been more MV-like.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dillane, Bob Sent: Thursday, October 06, 2005 09:04 To: [email protected] Subject: RE: [U2] Unidata Pattern Lookups Hi Jeff, We wrote a similar module and have the same problem with license plates having what Unidata sees as patterns. If you enclose the string within quotes it should work. We do: LIST H08.PS.VEHICLES WITH @ID LIKE "...'4296XH'..." HTH, Bob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey Butera Sent: Thursday, October 06, 2005 11:30 AM To: [email protected] Subject: [U2] Unidata Pattern Lookups We have an application I wrote which records parking stickers for the college. It saves data using the person's ID and license plate (with certain bad characters removed). However SELECTS against the file occasionally fail if the license plate string is interpreted by Unidata as a pattern. For example: :LIST H08.PS.VEHICLES WITH @ID LIKE ...4296... 0717266*4296XH 1 record listed :LIST H08.PS.VEHICLES WITH @ID LIKE ...4296XH No records listed. I'm not terribly familiar with pattern matching in Unidata, but am wondering if there's a UDT option I can switch off in certain situations to avoid this. (I'm looking thur my UDT Options Command Ref and can't see anything yet...) Our Public Safety office is irritated because searching on an exact plate sometimes fails yet a partial plate succeeds. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "...our behavior matters more than the beliefs that we profess." Elizabeth Deutsch Earle ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
