RE: Fetch without Execute...

2003-10-14 Thread NIPP, SCOTT V (SBCSI)
ld.sbc.com -Original Message- From: Ronald J Kimball [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 8:25 AM To: NIPP, SCOTT V (SBCSI) Cc: [EMAIL PROTECTED] Subject: Re: Fetch without Execute... On Tue, Oct 14, 2003 at 08:06:30AM -0500, NIPP, SCOTT V (SBCSI) wrote: > I have

Re: Fetch without Execute...

2003-10-14 Thread Ronald J Kimball
On Tue, Oct 14, 2003 at 08:06:30AM -0500, NIPP, SCOTT V (SBCSI) wrote: > I have run into this problem before, but unfortunately, I can't seem > to figure out what I am doing wrong again this time... I am working on a > script to parse a data file and INSERT/UPDATE this data into a MySQL > da

Re: fetch( ) without execute( ) Error...

2003-09-04 Thread James D. White
If the error is on the first fetchrow_hashref, there is not enough code to see what the problem is. If it is the second fetchrow_hashref, finish should be called after the while, if at all. If your while loop fetches all of the rows and fetches again to get the undef value which indicates no more d

Re: fetch( ) without execute( ) Error...

2003-09-03 Thread John Day
At 01:08 PM 9/3/2003 -0400, Michael Ragsdale wrote: >At 12:43 PM 9/3/2003, NIPP, SCOTT V (SBCSI) wrote: >>I keep coming up with this error, but I AM performing an execute >>prior to the fetch. I have seen some other threads on this, and have >>upgraded the DBD:Mysql to the latest version o

Re: fetch( ) without execute( ) Error...

2003-09-03 Thread Michael Ragsdale
At 12:43 PM 9/3/2003, NIPP, SCOTT V (SBCSI) wrote: I keep coming up with this error, but I AM performing an execute prior to the fetch. I have seen some other threads on this, and have upgraded the DBD:Mysql to the latest version on CPAN. Any ideas? Here is a small portion of the code: i

RE: fetch( ) without execute( ) Error...

2003-09-03 Thread Michael Nhan
I don't think you should be calling finish before fetching. I think that is the problem here. Michael > Date: Wed, 3 Sep 2003 12:01:03 -0500 > From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: R

RE: fetch( ) without execute( ) Error...

2003-09-03 Thread NIPP, SCOTT V (SBCSI)
ROTECTED] Sent: Wednesday, September 03, 2003 11:54 AM To: NIPP, SCOTT V (SBCSI) Cc: [EMAIL PROTECTED] Subject: Re: fetch( ) without execute( ) Error... Which fetchrow_hashref line? I see two of them, but only one execute. You need to include more code for anyone to kno

Re: fetch( ) without execute( ) Error...

2003-09-03 Thread Ronald J Kimball
On Wed, Sep 03, 2003 at 11:43:48AM -0500, NIPP, SCOTT V (SBCSI) wrote: > I keep coming up with this error, but I AM performing an execute > prior to the fetch. I have seen some other threads on this, and have > upgraded the DBD:Mysql to the latest version on CPAN. Any ideas? Here is a > sm

Re: fetch( ) without execute( ) Error...

2003-09-03 Thread Jeffrey . Seger
Which fetchrow_hashref line? I see two of them, but only one execute. You need to include more code for anyone to know what's really wrong here. Jeff Seger Fairchild Semiconductor [EMAIL PROTECTED] "NIPP, SCOTT V (SBCSI)" <[EMAIL P