Re: Working with recordsets

From: Steve Holden (steve_at_holdenweb.com)
Date: 01/08/05 

Date: Sat, 08 Jan 2005 14:22:33 -0500

AdSR wrote:

> chema.rey@gmail.com wrote:
>
>> Hi.
>>
>> I have one recorset that I would like to pass to 2 functions, one is
>> for create an CSV file and the other one is to create a HTML file. The
>> problem is that the recordset is totally read in the first function,
>> and then when I pass it to the second funtion the recordset is in the
>> last record.
>>
>> I've read docs, but I think that one cursor doesn't have something
>> like movefirst() method. Anybody have an idea to solve this?
>>
>> Thank's.
>>
>
> Try loading the whole recordset with the fetchall() method and use the
> resulting sequence in your functions. It won't be memory-efficient but
> it will be easy to do.
>
> AdSR

Or, if this doesn't suit, try creating two separate cursors from the
same connection and execute the same query on each. There's some chance
that your database driver/backend combination will optimize the queries
then.

regards
  Steve 

-- 
Steve Holden               http://www.holdenweb.com/
Python Web Programming  http://pydish.holdenweb.com/
Holden Web LLC      +1 703 861 4237  +1 800 494 3119

Relevant Pages

  • Re: Update fields in previous row from fields in current row
    ... I don't think i can "pull the data in one line at a time". ... The data is in a csv file and imported into a recordset. ... in the first UDT. ...
    (microsoft.public.vb.database.ado)
  • Re: Data throughput
    ... The query is used to fill a CSV file that a third party ... >SQL Server MVP ... >> a recordset being returned to the application. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Import comma delimited file
    ... Excel file can be converted into) in good form just as you can to a ... The .csv file needs to be uploaded to the server. ... So I'd suggest going through this recordset one row at a time and within ... ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool... ...
    (microsoft.public.inetserver.asp.db)
  • Using Excel to import .csv file into Access table
    ... Using Excel 2003, I need to get a csv file into an Access table. ... Open table as ADO recordset ... Check size of array to confirm field count ...
    (microsoft.public.excel.programming)