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-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: [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: http://www.orafaq.com
> --
> Author: Rajaram
> 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: http://www.orafaq.com
--
Author: Jared Still
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).
