serial numbers, on the next page I make sure that the numbers match
to a corresponding regular _expression_. If one does not match, then
the user is notified that they entered a wrong serial number and
should enter it again. If they all pass the regex, they get inserted
into a table. Well, I need to either evaluate those numbers before I
insert or pull them back out and make sure that none of them are
within 5 digits of each other. Example list:
3M0123456789, 2KB234234345, 22L897657898, 3M0123456790. All of these
serial numbers are contained on one invoice. I would need to flag
this invoice as the first number in the list is 1 digit lower than
the last number and the first 3 characters match. I have attempted to
do my insert first, and then compare the group by selected them again
and doing a loop, but I can't get that to work. Any ideas?
Thanks!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
