Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Can't be Blank

Quote Reply
Can't be Blank
I am currently using the auto key generate function form dbman sql. I am getting this error message Company Id can't be blank, each time I try to create a new record. Can any one help? My url is http://www.bizsuccess.co.uk/cgi-bizSuccess/dbman/db.cgi.

Quote Reply
Re: Can't be Blank In reply to
The problem is that you have the COMPANY ID available to fill out...since it is an auto-generated field, it must be a hidden field, like the following:

Code:

<input type="hidden" name="CompanyID" value="$rec{'CompanyID'}">


Regards,

Eliot Lee
Quote Reply
Re: Can't be Blank In reply to
I have tried wht you asked me to try, but I am still getting the message

Quote Reply
Re: Can't be Blank In reply to
Double check the .cfg file and also the ID field in your MySQL table...make sure that you have selected Primary and Auto-generate.

Use MySQLMan to verify the field definition.

Regards,

Eliot Lee