Gossamer Forum
Home : Products : Gossamer Links : Discussions :

recip can not contain the value ''

Quote Reply
recip can not contain the value ''
When I try to modify a record, I am getting an error that reads:

recip can not contain the value ''

There is nothing in the recip field??? What can be causing this and how do I fix it?

Regards,

Richard

Richard Bilger
RBilger@MERGINET.com
MERGINET.com: Emergency Responders Web Site
http://www.merginet.com
Quote Reply
Re: [RBilger] recip can not contain the value '' In reply to
That basically means that the field cannot be null or empty. If you don't want to require the column/field, edit the table properties to set that column to NULL, and then re-sync your definition file.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [Heckler] recip can not contain the value '' In reply to
The recip properties for Not Null were set to No. I changed it to Yes then resync and got the error that the field could not be left blank. So I switched it back, did another resync and get the same message as before. Any more ideas?

Richard Bilger
RBilger@MERGINET.com
MERGINET.com: Emergency Responders Web Site
http://www.merginet.com
Quote Reply
Re: [RBilger] recip can not contain the value '' In reply to
Is that with the Links SQL PHP front end or with the Perl CGI?

Adrian
Quote Reply
Re: [brewt] recip can not contain the value '' In reply to
Perl CGI

Richard Bilger
RBilger@MERGINET.com
MERGINET.com: Emergency Responders Web Site
http://www.merginet.com
Quote Reply
Re: [RBilger] recip can not contain the value '' In reply to
Take a look at your table properties again. Make sure you do not have a field mask, or something else requiring an input from the template. One way to help debug, is see if you set a template field to that what happens. Sometimes its the template parser, not the database, that is checking for the valid input. (well, technically, not the template parser itself, but the pre-connect-to-database validation codes on the input data).

I've finally got a few sites up, and am getting them tweaked (took ages for the DNS to switch over!) I'll have some test sites up soon, so I can check these things out in real time :)


PUGDOG´┐Ż Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.