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

Reply via email to