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

[Mark Stosberg <mark@summersault.com>]

******    message to minivend-users from Mark Stosberg <mark@summersault.com>     ******


Stefan Hornburg wrote:
> 
> 
> 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.

Thanks for your responses Mike and Stefan. 

The above is the sort of change I was asking about it. Without
understanding the internals of MV, I'm not sure what sorts of things
would break it's database abstraction layer, which certainly has it's
merits. Now I've realized that partly what happened here was an
interface misunderstanding. I thought
"Partial Update: Add Records" would just be doing inserts and no
updates, in which case a key wouldn't be needed. Perhaps the feature I
want-- to add a bunch of new rows from a file doing just inserts-- is
not currently available. 

  Thanks,

     -mark
  
  <<-------------------------------------------------------------->>
personal website                <    Summersault Website Design
   http://mark.stosberg.com/     >       http://www.summersault.com/
-
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