What's the canoninical way of dealing with a NOT NULL column?
[prev]
[thread]
[next]
[Date index for 2004/07/30]
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4764A.CE894DBD
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I've solved my problem: I was trying to do an INSERT without giving a
value for a NOT NULL column.
=20
I tried adding __PACKAGE__->constrain_column( PARENT =3D> qr/\S/ ) for th=
e
relevant column, but that didn't help. (I guess it doesn't check columns
for which no value is given.)
=20
Perhaps I'm not looking hard enough, but I can't find an answer in the
documentation or the list archives.
=20
http://www.bbc.co.uk/ - World Wide Wonderland
This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
stated.
If you have received it in error, please delete it from your system.=20
Do not use, copy or disclose the information in any way nor act in
reliance on it and notify the sender immediately. Please note that the
BBC monitors e-mails sent or received.=20
Further communication will signify your consent to this.
------_=_NextPart_001_01C4764A.CE894DBD
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii"=
>
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN class=3D385160915-=
30072004>I've=20
solved my problem: I was trying to do an INSERT without giving a value fo=
r a NOT=20
NULL column.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D385160915-30072004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN class=3D385160915-=
30072004>I=20
tried adding __PACKAGE__->constrain_column( PARENT =3D> qr/\S/=
) for=20
the relevant column, but that didn't help. (I guess it doesn't check=
=20
columns for which no value is given.)</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D385160915-30072004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D385160915-30072004>Perhaps I'm not looking hard enough, but I can=
't find=20
an answer in the documentation or the list archives.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV><br>h=
ttp://www.bbc.co.uk/ - World Wide Wonderland<br><br>This e-mail (and any =
attachments) is confidential and may contain<br>personal views which are =
not the views of the BBC unless specifically<br>stated.<br>If you have re=
ceived it in error, please delete it from your system. <br>Do not use, co=
py or disclose the information in any way nor act in<br>reliance on it an=
d notify the sender immediately. Please note that the<br>BBC monitors e-m=
ails sent or received. <br>Further communication will signify your consen=
t to this.</BODY></HTML>
------_=_NextPart_001_01C4764A.CE894DBD--
 |
What's the canoninical way of dealing with a NOT NULL column?
Ian McDonald-ONLINE 15:35 on 30 Jul 2004
|
