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: MDaemon_at_southampton.gov.uk [SMTP:MDaemon_at_southampton.gov.uk] Sent: Friday, May 25, 2001 5:41 PM

To:     rajaram_k_at_netzero.net
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:rajaram_k_at_netzero.net] 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:DFarnsworth_at_Ashleyfurniture.com] 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-RRRR') )

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'
> 2 WHERE available_power.driver_id = manpowerprofile.mpp_id
> 3* and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-YYYY')
>SQL> /
> and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-YYYY')
> *
>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: DFarnsworth_at_Ashleyfurniture.com
>
>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: ListGuru_at_fatcity.com (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: rharter_at_emc-inc.com

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: ListGuru_at_fatcity.com (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: DFarnsworth_at_Ashleyfurniture.com

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: ListGuru_at_fatcity.com (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: http://www.orafaq.com
--
Author: Rajaram
  INET: rajaram_k_at_netzero.net

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: ListGuru_at_fatcity.com (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: http://www.orafaq.com
-- 
Author: Rajaram
  INET: rajaram_k_at_netzero.net

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: ListGuru_at_fatcity.com (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).