in reply to Re: EOF required before writing DB?
in thread EOF required before writing DB?

Appreciate the input guys. So it is no bad form to have records not written by appending to the end of the table?

I will impliment the order by clause. I was under the impression that I was not doing things correctly. I rather learn the correct way of doing things.

Regards,

Simon

  • Comment on Re: Re: EOF required before writing DB?

Replies are listed 'Best First'.
Re: Re: Re: EOF required before writing DB?
by sdyates (Scribe) on Mar 07, 2002 at 18:36 UTC
    I looked into this a little further. Calling

    $dbh->disconnect

    closes the database connection. I am calling this script at the end of each SQL command. All seems to be working well so far. The ...ORDER BY was also handy and I should have thought of this before. See what happens when one does not use perl everyday...