[ic] Interesting Bug or Feature??
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.
From: John Beima <firstname.lastname@example.org>
To: email@example.com <firstname.lastname@example.org>
Date: Wednesday, October 04, 2000 1:31 PM
Subject: [ic] Interesting Bug or Feature??
>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
>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
>username from the userdb when it loads the rest of the user data, so in
>his information is then later saved correctly in all the otehr tables?
>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