[ic] Interesting Bug or Feature??

Nick Pleis npleis@saratogaweb.com
Wed, 4 Oct 2000 13:25:12 -0500

We store our stuff all lowercase, and then force it to lowercase when
entering it into our transactions DB as well.

-----Original Message-----
From: John Beima <jbeima@reality.palb.com>
To: interchange-users@minivend.com <interchange-users@minivend.com>
Date: Wednesday, October 04, 2000 1:31 PM
Subject: [ic] Interesting Bug or Feature??

>G'Day Folks,
>I was wondering if someone had a work around for this...
>Say your catalog has a user with the username of "jbeima".
>MiniVend allows the user to login ignoring the case. So "jbeima", "Jbeima",
>"jBeima" all log the same user in.
>Now when the user buys something instead of the username "jbeima" being
>in the orderline database, whatever the user typed in the login is stored.
>the orderline username will actually contain "Jbeima" or "jBeima" depending
>what the user typed.
>So if we generate a report that queries all the orderline data and then
sorts it
>by username, this user appears to be three different people. So he has to
>for his order information in 3 different places.
>What I was wondering, is if there is a way of triggering Minivend to
re-load the
>username from the userdb when it loads the rest of the user data, so in
fact all
>his information is then later saved correctly in all the otehr tables?
>John Beima
>P.A.L.B. Systems - Phone: (780)451-1086 - Fax: (780)447-4760
>11639-122 Street, Edmonton, Alberta, Canada, T5M 0B6
>Interchange-users mailing list