More...
I do know that it is a SELECT but I'm getting some kind of error on the
fetch call. From this, I know there should be data but it's either failing
or I lost the handle (sth). Though, I did some simple coding and found
that it is not NULL (it is defined) but not fetching. And the code is
crsahing
-thanks
>> It's not really clear what you are trying to achieve or, more
>> importantly, why you're trying to do it this way - being passed a
>> statement handle in an unknown state.
>>
>> If you know the statement is a SELECT then if it's $sth->{Active}
>> you can try fetching from it.
>
> I do know that it is a SELECT but I'm getting some kind of error on the
> fetch call. From this, I know there should be data but it's either failing
> or I lost the handle (sth). Though, I did some simple coding and found
> that it is not NULL (it is defined) but not fetching.
>
> -thanks
>
>> On Thu, Oct 23, 2003 at 10:19:01PM -0700, [EMAIL PROTECTED] wrote:
>>> Let's assume that the $sth->prepare() was good but something failed at
>>> this line:
>>>
>>> $sth = $dbh->exeute();
>>>
>>> if ($sth) is not consistent when connection or something goes bad.
>>
>> After execute() a SELECT statement will leave $sth->{Active} true
>> if the execute was successful. That doesn't apply to non-select's
>> though.
>>
>> $sth->err and $sth->errstr will give the error details (until some
>> other method call clears them, as most do).
>>
>>> Can you or someone comment further about testing $sth if there are
>>> rows?
>>
>> It's not really clear what you are trying to achieve or, more
>> importantly, why you're trying to do it this way - being passed a
>> statement handle in an unknown state.
>>
>> If you know the statement is a SELECT then if it's $sth->{Active}
>> you can try fetching from it.
>>
>> Tim.
>>
>>>
>>> -thanks
>>>
>>> > On Wed, 22 Oct 2003 22:18:18 -0700 (PDT) [EMAIL PROTECTED] wrote:
>>> >
>>> >> How can I test the status of $sth itself?
>>> >>
>>> >> A scenario is that a $sth is passed from a sub. And now, I have a
>>> >> $sth. Of course $sth->rows return 0 or whatever int row. However, a
>>> >> test using $sth->rows is not good when something is wrong. It return
>>> >> some large number. So How can I test to see if its bad or good
>>> >> without access to previous calls?
>>> >
>>> > If the $dbh->prepare() call failed, $sth will be false. The only
>>> > portable way to tell if $sth will return rows is to fetch some.
>>> >
>>> > --
>>> > Mac :})
>>> > ** I usually forward private questions to the appropriate mail list.
>>> **
>>> > Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
>>> > Give a hobbit a fish and he eats fish for a day.
>>> > Give a hobbit a ring and he eats fish for an age.
>>> >
>>> >
>>>
>>>
>>>
>>> -----------------------------------------
>>> eMail solutions by
>>> http://www.swanmail.com
>>>
>>
>
>
>
> -----------------------------------------
> eMail solutions by
> http://www.swanmail.com
>
-----------------------------------------
eMail solutions by
http://www.swanmail.com
