Re: [mv] Bug report Interchange UI --- mysql table update doesn't work always

[Stefan Hornburg <racke@linuxia.de>]

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

Ton Verhagen <ton@verhagen.net> writes:

> ******    message to minivend-users from Ton Verhagen <ton@verhagen.net>     ******
> 
> Hi All,
> 
> While testing the Interchange UI I encountered something that looks like a bug.
> 
> Updating the info in the (mysql) tables works for some tables but not for all.
> 
> I have defined a couple of Mysql tables (first field shown below),
> 
> This WILL work
> Definition: Table 1
> Database  courses  COLUMN_DEF   "code=char(3) NOT NULL PRIMARY KEY"
> Database ...etc
> 
> This WON'T work
> Definition: Table 2
> Database  books  KEY          id
> Database  books  COLUMN_DEF   "id=INT NOT NULL AUTO_INCREMENT PRIMARY KEY"
> Database ...etc
> 
> The definition for table 1 works okay, however, the definition for table 2 
> won't do the trick (won't update info while using the UI). It seems to me 
> that the Interchange UI (direct table edit) doesn't handle an integer key 
> properly. Is this indeed a bug or am I missing something here?

Integer key is OK, but you shouldn't use key fields with 1 or 2 characters.
id is a abbrev for a MiniVend form variable, use idf or something else
for the key name. 

Insertion on AUTO_INCREMENT key columns doesn't work without specifying
key, I made a crude patch for that, ask me if you need it.

Ciao
        Racke

-- 
LinuXia Systems && Cobolt NetServices, eCommerce and more
Shop- und Datenbanklösungen mit MiniVend, Firewalls auf Debian-Basis
http://www.linuxia.de - http://www.cobolt.net
--> Coding from hell and back <--- 
-
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