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, '', ''],
);
Quote Reply
Re: [dandot] Add record shows admin In reply to
There's a section towards the bottom of the .cfg file that looks like this:

Code:

# Auth user field. This is the field position in the database used for storing
# the userid who owns the record. Set to -1 if not used.
$auth_user_field = 9;
It doesn't look like you're using a field like that at all, so you need to change the 9 to -1.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Quote Reply
Re: [JPDeni] Add record shows admin In reply to
thanks JPD , that did the trick! Wish I went here earlier, was driving me crazy, I renamed fields, changed the order, made a new form, nothing worked :-)

thanks again,
Dandot