Gossamer Forum
Home : Products : DBMan : Discussions :

Add record shows admin

Quote Reply
Add record shows admin
Hi all,

Im using the auto-generate options to add records to my database. I have a form with 30 fields and everytime I fill in a new record all fields are filled with the information I provided except for 1, no matter what I enter it adds the value 'admin' to the database. I can't figure out why this is happening! Anyone an idea?

Many thanks in advance
Dandotra

I;ve included the database setup, the column that is giving me the problems is PaperKind

%db_def = (
Catalognumber => [ 0, 'alpha', 10, 10, 1, '', ''],
IssuedTogether => [ 1, 'alpha', 21, 21, 0, '', ''],
OldDandOnumber => [ 2, 'alpha', 7, 7, 0, '', ''],
Province => [ 3, 'alpha', 15, 15, 0, '', ''],
City => [ 4, 'alpha', 40, 40, 0, '', ''],
PostalCode => [ 5, 'alpha', 6, 6, 0, '', ''],
Issued => [ 6, 'alpha', 21, 21, 0, '', ''],
Surcharge => [ 7, 'alpha', 60, 60, 0, '', ''],
Print => [ 8, 'alpha', 12, 12, 0, '', ''],
PaperKind => [ 9, 'alpha', 10, 10, 0, '', ''],
Format => [10, 'alpha', 4, 4, 0, '', ''],
NumberParts => [11, 'alpha', 30, 30, 0, '', ''],
IssuedBooklets => [12, 'alpha', 20, 20, 0, '', ''],
DescripSTUB => [13, 'alpha', 80, 80, 0, '', ''],
DescripLABEL => [14, 'alpha', 80, 80, 0, '', ''],
DescripRECEIPT => [15, 'alpha', 80, 80, 0, '', ''],
Value => [16, 'alpha', 8, 8, 0, '', ''],
Color => [17, 'alpha', 15, 15, 0, '', ''],
PriceUnused => [18, 'alpha', 8, 8, 0, '', ''],
PriceUsed => [19, 'alpha', 8, 8, 0, '', ''],
PriceLetter => [20, 'alpha', 8, 8, 0, '', ''],
Remarks => [21, 'alpha', 80, 80, 0, '', ''],
CrossRef1 => [22, 'alpha', 15, 15, 0, '', ''],
NumberCat1 => [23, 'alpha', 10, 10, 0, '', ''],
CrossRef2 => [24, 'alpha', 15, 15, 0, '', ''],
NumberCat2 => [25, 'alpha', 10, 10, 0, '', ''],
CrossRef3 => [26, 'alpha', 15, 15, 0, '', ''],
NumberCat3 => [27, 'alpha', 10, 10, 0, '', ''],
Order => [28, 'alpha', 1, 1, 0, '', ''],
LabelStock => [29, 'alpha', 1, 1, 0, '', ''],
);
Subject Author Views Date
Thread Add record shows admin dandot 2202 Apr 5, 2005, 3:45 AM
Thread Re: [dandot] Add record shows admin
JPDeni 2113 Apr 5, 2005, 6:34 AM
Post Re: [JPDeni] Add record shows admin
dandot 2106 Apr 5, 2005, 6:58 AM