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

[Eugene Apanasenko <janzen@iol.cz>]

******    message to minivend-users from Eugene Apanasenko <janzen@iol.cz>     ******

Hi All!

Has anyone ever managed to store user information in SQL-table?

I use MiniVend V3.14-4 and decide to store users information in SQL-table. I added the following
lines in my
catalog.cfg:
#Database            userdb       userdb.asc        TAB
Database            userdb       userdb.asc        dbi:Oracle:ORCL
Database            userdb ChopBlanks   1
Database            userdb UPPERCASE    1
Database            userdb USER   evlap
Database            userdb PASS   mypwd
NoImport  userdb

I created a table Userdb with the structure of Userdb.asc, erased userdb.db file and cleaned
userdb.asc out. Now when I create a new user, a new record seems to be added to the table. But when
I enter an extra info (such as Name, Address etc) in ord/checkout.html page (I use this one from
simple demo) and press "Update info, don't place order" button, Minivend updates the table with
__empty__ values, though I have theese fields not blanked (series of queries like this one are
produced:
 update userdb SET ADDRESS = '' where CODE = 'testuser').
I haven't got a clue why values from the form are ommited.

Thanks in advance, Eugene

-
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