Yes, I can do that, but the subroutine is the same that execute other SELECT-like statements. It does: prepare execute fetch result print Then it must understand when SELECT * INTO OUTFILE must be executed and do not try to fetch data. Is there any criteria that say that there is no data to fetch?
thanks. Ioannis Livassov ----- Original Message ----- From: "Tom Gao" <[EMAIL PROTECTED]> To: "edatanew.com" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, September 08, 2002 6:50 PM Subject: Re: select * into outfile > 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 > > --------------------------------------------------------------------- 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
