main logo
Subject: Re: FIXED: MIN MAX fails
Author: Finlay Dobbie
Posted: 2002/09/28 06:56:43
 
View Entire Thread
New Search


On Saturday, September 28, 2002, at 12:48 pm, Nichole Pinkard wrote:

> mycur=mydb.sqlselect("select max(score) from teacher")
>
> I thought the value was stored in "mycur.recordcount" but this is
> returning
> a value of 1. When I do the same query in visql I get the correct
> score of
> 320.
>
> Where should I look for the returned value?

In the first row of the first column of the cursor. Perhaps you should
re-read the docs on cursors...

-- Finlay
 
©2002 Finlay Dobbie
<-- Prior Message New Search Next Message -->