Re: finding and inserting

2005-02-14 Thread Robert
Amonotod [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] From: Robert [EMAIL PROTECTED] Date: 2005/02/11 Fri PM 12:55:03 CST Nope you got it. I am just mulling in my thick head. Say what? We're quite willing to help, we just need a little more data to do so... Robert

RE: finding and inserting

2005-02-11 Thread Reidy, Ron
What do you mean by 'insert that user into a new district'? Do you mean create an oracle account? -- Ron Reidt Lead DBA Array BioPharma, Inc. -Original Message- From: Robert [mailto:[EMAIL PROTECTED] Sent: Thu 2/10/2005 11:26 AM To: dbi-users@perl.org Cc: Subject:

Re: finding and inserting

2005-02-11 Thread Robert
Let me see if I can explain it better today. :-) I have about 200 users in district 1. I need to add each of those users into district 2 using the same information that they have in district 1. I also need to make sure they are only inserted 1 time. They have a unique employeeID, so I know I

Re: finding and inserting

2005-02-11 Thread amonotod
From: Robert [EMAIL PROTECTED] Date: 2005/02/11 Fri AM 07:10:25 CST I have about 200 users in district 1. I need to add each of those users into district 2 using the same information that they have in district 1. I also need to make sure they are only inserted 1 time. They have a unique

RE: finding and inserting

2005-02-11 Thread Reidy, Ron
PROTECTED] Sent: Fri 2/11/2005 6:10 AM To: dbi-users@perl.org Cc: Subject:Re: finding and inserting Let me see if I can explain it better today. :-) I have about 200 users in district 1. I need to add each of those users into district 2 using the same information that they have

Re: finding and inserting

2005-02-11 Thread Jonathan Leffler
On Fri, 11 Feb 2005 08:10:25 -0500, Robert [EMAIL PROTECTED] wrote: Let me see if I can explain it better today. :-) See: http://www.catb.org/~esr/faqs/smart-questions.html I have about 200 users in district 1. I need to add each of those users into district 2 using the same information that

RE: finding and inserting

2005-02-11 Thread Hardy Merrill
) in PL/SQL. I leave this investigation to you and your DBA. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Robert [mailto:[EMAIL PROTECTED] Sent: Fri 2/11/2005 6:10 AM To: dbi-users@perl.org Cc: Subject:Re: finding and inserting Let me see

RE: finding and inserting

2005-02-11 Thread mark.d.andrews
', employee_id, ... FROM district_table WHERE district = 'District 1' Hope this help Mark -Original Message- From: amonotod [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 9:00 AM To: Robert Cc: dbi-users@perl.org Subject: Re: finding and inserting From: Robert [EMAIL PROTECTED

Re: finding and inserting

2005-02-11 Thread Robert
Jonathan Leffler [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Fri, 11 Feb 2005 08:10:25 -0500, Robert [EMAIL PROTECTED] wrote: Let me see if I can explain it better today. :-) See: http://www.catb.org/~esr/faqs/smart-questions.html I have about 200 users in district 1. I

RE: finding and inserting

2005-02-11 Thread Hardy Merrill
'District 2', employee_id, ... FROM district_table WHERE district = 'District 1' Hope this help Mark -Original Message- From: amonotod [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 9:00 AM To: Robert Cc: dbi-users@perl.org Subject: Re: finding and inserting From: Robert [EMAIL

RE: finding and inserting

2005-02-11 Thread mark.d.andrews
I briefly touched on in my first response. Mark -Original Message- From: Hardy Merrill [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 10:06 AM To: dbi-users@perl.org; Andrews, Mark (TS USA) Subject: RE: finding and inserting I'm no database expert (I'm probably way off here

RE: finding and inserting

2005-02-11 Thread mark.d.andrews
Robert, Did I misunderstand the question entirely? Are users in districts stored in different tables within the database? If so then my previous messages are largely useless. Can you please provide some more details on this problem? Mark -Original Message- From: Robert [mailto:[EMAIL

Re: finding and inserting

2005-02-11 Thread amonotod
From: Robert [EMAIL PROTECTED] Date: 2005/02/11 Fri AM 08:27:56 CST Oh I wish I could! I am constrained by a 3rd party application that uses Oracle as a big ole flat file. Where every table is padding with spaces! Every table. I could shoot the people that created this application. You

Re: finding and inserting

2005-02-11 Thread Robert
Nope you got it. I am just mulling in my thick head. Robert

Re: finding and inserting

2005-02-11 Thread amonotod
From: Robert [EMAIL PROTECTED] Date: 2005/02/11 Fri PM 12:55:03 CST Nope you got it. I am just mulling in my thick head. Say what? We're quite willing to help, we just need a little more data to do so... Robert amonotod -- `\|||/ amonotod@| sun|perl|windows (@@)