[mv] UserDb as SQL-table...

[Eugene Apanasenko <janzen@iol.cz>]

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

Hi All!

I use MiniVend V3.14-4 and have decided to store users information in SQL-table. I add 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 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 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.

Should I modify existing chekout.html file to make userdb work? And in some way?

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