FW: Transient Delivery Failure
Someone please do something about this... This stupid southampton address keep coming to my mail box... I hope its happening the same with the other listers Will anyone look at it and remove it? Rajaram (PS: the Failed message follows) -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 5:41 PM To: [EMAIL PROTECTED] Subject:Transient Delivery Failure The attached message had transient non-fatal delivery errors THIS IS A WARNING MESSAGE ONLY - YOU DO NOT NEED TO RESEND YOUR MESSAGE! This server is configured to automatically retry delivery at configured intervals. Subsequent attempts to deliver this message are pending. --- Partial Session Transcript --- Host [sccemail] resolved to [172.21.4.74] Waiting for socket connection... 30 second wait for connect timeout exceeded. This message is 61 minutes old; it has 0 minutes left in this queue Primary queue lifetime exceeded; message placed in retry queue --- End Transcript --- : Message contains [1] file attachments -Original Message- From: Rajaram [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Subject:RE: Bad SQL. Remember - Drink responsibly - Kidding. Raj. -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Subject:RE: Bad SQL. Thank you very much. I was thinking that I needed to do a nested select. It worked great. I'll have a beer for you after I leave work! :) Dave -Original Message- Sent: Friday, May 25, 2001 1:46 PM To: Multiple recipients of list ORACLE-L I think it's just Friday. You need to rewrite your statement to read something like this: UPDATE AVAILABLE_POWER SET available_power_driver_terminated = 'Y' where available_power.driver_id in (select manpowerprofile.mpp_id from manpowerprofile where manpowerprofile.mpp_terminationdt to_date('31-DEC-2049','DD-MON-') ) At 09:01 AM 5/25/01 -0800, you wrote: I am trying to write an update statement but seem to be having problems. Below is my statement and the error in SQL*Plus. 1 UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y' 2WHERE available_power.driver_id = manpowerprofile.mpp_id 3*and manpowerprofile.mpp_terminationdt TO_DATE('31-DEC-2049','DD-MON-') SQL / and manpowerprofile.mpp_terminationdt TO_DATE('31-DEC-2049','DD-MON-') * ERROR at line 3: ORA-00904: invalid column name I know that manpowerprofile.mpp_terminationdt is a valid table column. Do I need to do some type of join on these two tables? Or is it just Friday and I should give up and go have a cold beer!!:o) Any advice would be appreciated. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ:
Re: FW: Transient Delivery Failure
It was annoying me too, so I removed it. :) Jared On Friday 25 May 2001 18:15, Rajaram wrote: Someone please do something about this... This stupid southampton address keep coming to my mail box... I hope its happening the same with the other listers Will anyone look at it and remove it? Rajaram (PS: the Failed message follows) -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 5:41 PM To: [EMAIL PROTECTED] Subject: Transient Delivery Failure The attached message had transient non-fatal delivery errors THIS IS A WARNING MESSAGE ONLY - YOU DO NOT NEED TO RESEND YOUR MESSAGE! This server is configured to automatically retry delivery at configured intervals. Subsequent attempts to deliver this message are pending. --- Partial Session Transcript --- Host [sccemail] resolved to [172.21.4.74] Waiting for socket connection... 30 second wait for connect timeout exceeded. This message is 61 minutes old; it has 0 minutes left in this queue Primary queue lifetime exceeded; message placed in retry queue --- End Transcript --- : Message contains [1] file attachments -Original Message- From: Rajaram [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: Bad SQL. Remember - Drink responsibly - Kidding. Raj. -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Subject: RE: Bad SQL. Thank you very much. I was thinking that I needed to do a nested select. It worked great. I'll have a beer for you after I leave work! :) Dave -Original Message- Sent: Friday, May 25, 2001 1:46 PM To: Multiple recipients of list ORACLE-L I think it's just Friday. You need to rewrite your statement to read something like this: UPDATE AVAILABLE_POWER SET available_power_driver_terminated = 'Y' where available_power.driver_id in (select manpowerprofile.mpp_id from manpowerprofile where manpowerprofile.mpp_terminationdt to_date('31-DEC-2049','DD-MON-') ) At 09:01 AM 5/25/01 -0800, you wrote: I am trying to write an update statement but seem to be having problems. Below is my statement and the error in SQL*Plus. 1 UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y' 2WHERE available_power.driver_id = manpowerprofile.mpp_id 3*and manpowerprofile.mpp_terminationdt TO_DATE('31-DEC-2049','DD-MON-') SQL / and manpowerprofile.mpp_terminationdt TO_DATE('31-DEC-2049','DD-MON-') * ERROR at line 3: ORA-00904: invalid column name I know that manpowerprofile.mpp_terminationdt is a valid table column. Do I need to do some type of join on these two tables? Or is it just Friday and I should give up and go have a cold beer!!:o) Any advice would be appreciated. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other