[wdvltalk] Re: Further to CONCAT

2004-03-16 Thread Bj
- 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

[wdvltalk] Re: Further to CONCAT

2004-03-16 Thread Bj
...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!) •

[wdvltalk] Re: Further to CONCAT

2004-03-16 Thread rudy
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

[wdvltalk] Re: Further to CONCAT

2004-03-16 Thread Bj
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

[wdvltalk] re: CONCAT

2004-03-16 Thread dwayne . conyers
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

[wdvltalk] Re: Email harvesting - in M$ files?

2004-03-16 Thread Teck Low
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? : : :

[wdvltalk] Re: Further to CONCAT

2004-03-16 Thread Smile-Poet
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

[wdvltalk] Re: OT: Eudora Problem

2004-03-16 Thread Smile-Poet
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.

[wdvltalk] Re: OT: Eudora Problem

2004-03-16 Thread Tucson-WebDesign - Al Guevara
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