Gossamer Forum
Home : Products : DBMan : Discussions :

Blank field = server error?

Quote Reply
Blank field = server error?
I have a field in my DBMan database that doesn't always get filled. It's set up as alpha and the "not null" is set to 0 (which means it can be empty, right?)

But when I try to post a record with this field blank, I get a server error (although the record is posted).

Any ideas what's happening?

John
Quote Reply
Re: [jgold723] Blank field = server error? In reply to
SOunds like one of 2 things;

1. either all is well and the debug is on, but you don't really have an error.

OR I think,

2. the record is posted as the code is OK through the write to the database, then the server does not like some aspect of the add_success sub (which displays the added record).

Depending on what you have done to the record disply, it is concievable that a blank record could CAUSE the server error. Do you get a server error when the the blank field is not blank?
Quote Reply
Re: [joematt] Blank field = server error? In reply to
Hi:

No, I don't get an error when the field is filled.

John
Quote Reply
Re: [jgold723] Blank field = server error? In reply to
I would look at the code where the record is displayed, *assuming here you are not using the Auto generate the html forms*

I did not think Perl would bomb for division by zero, I would guess it maybe is sending it into a endless loop? or something as simple as a missing ; or misplaced #.

that has been me experience.