> Don't store nulls in a field that you may want to use.
> Store the empty string ('').
not up to your usual level of advice, Bj
;o)
what you're suggesting is the lazy way out of one particular situation
it's not necessarily good general advice
nulls have their function, and avoiding the use of COALESCE is no reason not
tu use them
> To fix your database you might do a an
> INSERT INTO table (field) VALUES ('') WHERE field IS NULL
whoa
perhaps you meant
UPDATE table SET field='' WHERE field IS NULL
>...or...
>
> ...retrieve all the values into strings, and concatenate those,
> instead of trying to do it all in a query
as a general rule: always do in the query if you can, rather than in
application logic
rudy
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
