[ic] Interesting Bug or Feature??

[Nick Pleis]

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",
and
>"jBeima" all log the same user in.
>
>Now when the user buys something instead of the username "jbeima" being
stored
>in the orderline database, whatever the user typed in the login is stored.
So
>the orderline username will actually contain "Jbeima" or "jBeima" depending
on
>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
look
>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
>jbeima@palb.com
>
>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
>Interchange-users@www.minivend.com
>http://www.minivend.com/mailman/listinfo/interchange-users