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
