Nope, you change the field to not null then it won't allow null values in
the database. Since the data already has null values, the Alter Table would
probably fail.

I'm still trying to figure out what any of this has to do with an index? Do
you have an index on this description field?

Cal
http://www.calevans.com


-----Original Message-----
From: Phil Driscoll [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 7:59 AM
To: Steve Brett; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] my sql text query


Good heavens, another PHP developer in Leeds:)

I think (I haven't tried this!) you could change the field type to
not-null - then your array should get populated with empty strings for any
records where this field is not set.

Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to