Re: SQL-Support (Was: Re: [mv] Minimate partial upload fails)

[Mike Heins <mikeh@minivend.com>]

******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******

Quoting Stefan Hornburg (racke@linuxia.de):
> > Quoting Mark Stosberg (mark@summersault.com):
> > > 
> > > Mike Heins wrote:
> > > > 
> > > > You have to have a key. I don't know how you are expecting the database to
> > > > identify a record without one.
> > > 
> > > I forgot to mention something. :) Regardless of this point, MiniMate
> > > should not be reporting "success" if the inserts are not happening
> > > correctly, which appears to be part of the issue here.
> > > 
> > 
> > MV does the insert, DBI says it succeeds, so it be.  You can code the
> > Postgres-specific version of Minivend if you want, but I certainly
> > will not support it. The code is there, waiting to be cloned and made into
> > something custom.
> > 
> > Minivend will not do anything database-specific.
> 
> This is OK, but SQL support would be better if database writes would
> occur in one statement. Now MiniVend does from
> 
> INSERT 0 SARAH BLUE
> 
> insert into table (key) values (0)
> update table wife = sarah where key = 0
> update table gown = blue where key = 0
> 
> If MiniVend does
> 
> insert into table (0, sarah, blue)
> 
> one can use Mysql's autoincrement feature.

And how would you prevent failure on NOT NULL conditions?

-- 
Internet Robotics, 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <mikeh@minivend.com>

Clothes make the man.  Naked people have little or no influence on
society.  -- Mark Twain
-
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