- Original Message -
From: Smile-Poet
...But two rows are NULL because the ex-US entries
have null 'vend_state' fields...So how does one pull
addresses in printable form?)
Don't store nulls in a field that you may want to use. Store the empty
string ('').
To fix your database you
...or...
...retrieve all the values into strings, and concatenate those, instead of
trying to do it all in a query
After all, you can go after the title of Most Sophisticated SQL User
later... after you actually got the basic stuff done... remember always KISS
(Keep It Simple, Stupid!)
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
From: rudy
not up to your usual level of advice, Bj
hangs head in shame
brightens up
Actually I'll take that as a compliment! :-)
[Memo to self: stop trying to use brain before 11am]
-
Email provided by http://www.ntlhome.com/
The WDVL
Sorry, the site is www.sqlservercentral.com
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
my friends:
Thanks for your input.
Teck
__* On Mon, 15 Mar 2004 19:40:30 -0800, Mark Groen ( [EMAIL PROTECTED] ) wrote: *__
: - Original Message -
: From: rudy
: To: [EMAIL PROTECTED]
: Sent: March 15, 2004 5:56 PM
: Subject: [wdvltalk] Re: Email harvesting - in M$ files?
:
:
:
I am following the conversation and it is helping greatly in expanding my
awareness; I am sure others working through the php/mysql learning zone
would agree.
Thank you Rudy for the additional points on extracting addresses. I didn't
make it clear then as the book had been hurled through the
Sorry Peter. All I can do is tell you I abandoned Eudora a year or two
back because it stopped sending anything. I still download some addresses
into it, but not those I have much to reply to. There were three instances
in use too; they all stopped. That was my second return to OE.
Eudora has a afine support site, Type in some of the error message or a
description oi it, and youll goin to find the answer
Id its paid for, you can email them.
Al
At 3/16/2004 04:18 PM, you wrote:
Sorry Peter. All I can do is tell you I abandoned Eudora a year or two
back because it