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

[Ton Verhagen <ton@verhagen.net>]

******    message to minivend-users from Ton Verhagen <ton@verhagen.net>     ******

Stefan Hornburg <racke@linuxia.de> writes:
>******    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.

Do you mean that the length of the name of the key should be > 2
or should the length of the value of the key be > 2 ?

>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.

Do you mean I have to use:
Database books KEY my_keyname

I'd be interested in receiving your 'crude' patch. Thanks!

Regards,

Ton


>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

-
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