you need to execute your query first you can avoid execute by using the just 'do' or else you'll need to execute your query before getting results
Tom ----- Original Message ----- From: "edatanew.com" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 09, 2002 12:35 AM Subject: select * into outfile > Hello! > > I have one subroutine in Perl (DBI) that prepares and executes SELECT-like > queries and fetches the output from them. > When I submit SELECT * INTO OUTFILE query, then $sth->fetchrow_array() > generates Error: > Error 19 (fetch() without execute()) > > How to avoid it? > How can this subroutine distinguish SELECT * INTO OUTFILE queries in order > not to fetch the result? > > Thanks!!!!! > > Ioannis Livassov > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php