[mv] q: Can't use userdb as sql-table.. ANSWER

[Jim Balster <jbalster@dmat.com>]

******    message to minivend-users from Jim Balster <jbalster@dmat.com>     ******

I have my userdb in an SQL database, but I did it by changing the table
name:
In catalog.cfg:
(I don't remember how many of these 4 are necessary - if any)
Variable      MV_USERDB            member
Variable      MV_USERDB_ACL_TABLE  member
Variable      MV_USERNAME          MemberID
Variable      MV_PASSWORD          password

Database member   member.asc        SQL
Database member   DSN               dbi:mSQL:__SERVER_BASE__
Database member   NUMERIC    MemberID      integer
Database member   COLUMN_DEF password      CHAR(32)
Database member   COLUMN_DEF Title         CHAR(10)
Database member   COLUMN_DEF First         CHAR(32)
Database member   COLUMN_DEF Last          CHAR(32)
Database member   COLUMN_DEF name          CHAR(64)
Database member   COLUMN_DEF address1      CHAR(64)
Database member   COLUMN_DEF address2      CHAR(64)
Database member   COLUMN_DEF address3      CHAR(64)
Database member   COLUMN_DEF City          CHAR(40)
Database member   COLUMN_DEF State         CHAR(40)
Database member   COLUMN_DEF Zip           CHAR(16)
Database member   COLUMN_DEF Country       CHAR(40)
. . . and so on

Then I call USERDB as follows:
[userdb function="new_account" database="member" username="[value
new_username]" password="[value mv_password]" verify="[value mv_verify]"
KEY=MemberID]

The KEY here is database="member" which is a different name from userdb
and
matches the name in the SQL database.

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list