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

[Stefan Hornburg <racke@linuxia.de>]

******    message to minivend-users from Stefan Hornburg <racke@linuxia.de>     ******

Mike Heins <mikeh@minivend.com> writes:

> ******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******
> 
> 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.

Ciao
        Racke

-- 
LinuXia Systems, eCommerce and more => http://www.linuxia.de/ or 05130-377132.
Unsere Partner: Cobolt NetServices (http://www.cobolt.net), CAPCON Systemhouse
(http://www.capcon-systemhouse.com), ecoservice gmbh (http://www.ecoservice.de)
Unser Fokus liegt auf Open-Source-Software (MiniVend, Debian GNU/Linux, etc.)

-
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