RE: mSQL Database Updates

["Russ" <russ@khouse.org>]

Hello,

The best way to decide what to use with Minivend is to figure out your
requirements and find the best tool.

Do you have to support a data entry technician on windows?  If so, using
mySQL is best because with myODBC you can link an M$ Access form to the
table.
If you're the DET (or you have a smart DET), it would make sense to use
whatever you like best!

In regards to Perl, if you're a C man  you'll be able to deal with Perl very
easily.

Russ Mann

-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of Phil Welch
Sent: Tuesday, July 20, 1999 5:08 PM
To: minivend-users@minivend.com
Subject: mSQL Database Updates


I'm new to MiniVend, but by following the instructions I was able to install
it in just a few minutes on my superb.net hosted isp site.  (Judging by some
of the comments, not all isp's so actively support MiniVend.)  Just as
easily I switched MiniVend over to mSQL and was delighted to see how
transparently the switch was made; the table created, populated and became
available.  Nice work Mike....

However, when I updated (I added an item) my mSQL products, everything
"instantly" went south in a hand basket.  I only later discovered the
administrative maintenance menu, which appears to be "the way" to do table
updates.

I am not a Perl person, which gives me some concern about my use of
MiniVend, hence I've been slowly warming up to it's use.  I am however a C
person and would prefer to deal with additional features outside of MiniVend
in C using the mSQL table(s) as the interface point.  At first blush this
doesn't appear to be possible, given my experience todate, but I thought I'd
broach the subject to see what I'm up against, and whether anyone else has
succeeded doing mSQL table updates outside of MiniVend.

I notice that most folks speak of MySQL.  I would prefer to use mSQL since I
have written software which allows me to SELECT, INSERT, UPDATE, DELETE,
REVIEW, etc., any mSQL table with any corresponding HTML form merely by
adding a symbolic link to a single cgi module.  Hence I would prefer not to
get into MySQL internals until I've finished my current endeavors.

Any thoughts or guidance would be appreciated.

Regards,

Phil Welch