mysql> create table test (id int not null);
Query OK, 0 rows affected (0.05 sec)
mysql> insert into test (id) values (null);
ERROR 1048: Column 'id' cannot be null
Cheers,
barneyb
> -----Original Message-----
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 05, 2003 8:16 AM
> To: CF-Talk
> Subject: Re: Debugging CFQUERYPARAM
>
> Charlie Griefer wrote:
> >
> > does your database accept null values/empty strings for
> those columns?
>
> MySQL does not enforce NOT NULL constraints even if they exist.
>
> Jochem
>
> --
> When you don't want to be surprised by the revolution
> organize one yourself
> - Loesje
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
