Dear Francisco,
On Thu, 10 Feb 2005 09:02:12 -0300, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Thanks for you response. You're welcome, but please keep the discussion on the mailing list, as you will probably get a better response, especially since MySQL is not my specialist area. > well, i like move free in a table of a database, like the mysql_data_seek > command of php, the link of the command is: > > http://cl2.php.net/function.mysql-data-seek Ahah! That's helpful. In terms of Informix terminolgy, that's a 'scroll cursor''; in other DBMS terms, that's a 'scrollable cursor'. > i need do the same on dbi. You need to bug Tim Bunce to get it added to DBI. I've been unsuccessful, in part because I've lacked the time to complete an implementation of it that can be used by drivers without native support for scrollable cursors. > i need move free in a table of a database, without use the "while" sentense, > because i can't come back to the first row in this table when i use "while" You will probably have to do inside your program what the database otherwise does for you - namely keep the results in an array so that you can get back to any previously fetched result when required. So, you have a wrapper function which you use as the fetch method. Some time ago - maybe two years ago, maybe even longer than that - I wrote a prototype in Perl that simulated a scroll cursor. If you find a DBI mailing list archive, search for my name and 'scroll' and you should be able to find it. It is, AFAIK (AFAICR) operational code, but you'd have to validate it. The production code would have to intercept other fetch methods too and manage them correctly too. The fetchall_* methods are a bit problematic, perhaps -- you'd be likely to end up with two copies of the data in memory, one in cache and one in the result. > thanks for you patience > > Saludos > > Francisco > > >-- Mensaje Original -- > >Date: Thu, 10 Feb 2005 00:08:09 -0800 > >From: Jonathan Leffler <[EMAIL PROTECTED]> > >Reply-To: Jonathan Leffler <[EMAIL PROTECTED]> > >To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > >Subject: Re: i need help > >Cc: dbi-users@perl.org > > > > > >Dear Francisco, > > > > > >On Tue, 8 Feb 2005 19:01:55 -0300, [EMAIL PROTECTED] <[EMAIL PROTECTED]> > >wrote: > >> hello: > >> > >> First all, sorry because my english is bad > > > >Of course you are excused. My Spanish is deplorable. > > > >> I need mode back to the first row the pointer with dbi in mysql > > > >I am really having a hard time working out what this might mean; I > >cannot assemble it into something meaningful. You are using Perl + > >DBI + MySQL -- and an appropriate DBD module. > > > >I'm not clear what sort of pointer you need to the first row. > > > >May I suggest trying one of the translation services - I usually use > >'Babelfish': > > > >http://babelfish.altavista.com/ > > > >This will do a Spanish-English translation - for entertainment, you > >can retranslate the English into Spanish again, and see how badly it > >was mangled. If the double translation is recognizable, the chances > >are the English speakers here will be able to understand what you were > >trying to say. > > > >I was reading your message on Gmail and two sponsored links appeared > >underneath: > > > >Sponsored Links > >Trusted Translations Inc. > >www.trustedtranslations.com - Expert English-Spanish Translations > >Accurate, Fast and Reliable ! > >Superior Translations > >www.latincompany.com - English-to-Spanish translation is our > >speciality. Contact us now! > > > >I know no more about them than that. > > > >> Gracias > >> > >> Francisco > > > >-- > >Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h> > >Guardian of DBD::Informix - v2003.04 - http://dbi.perl.org > >"I don't suffer from insanity - I enjoy every minute of it." > > -- Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h> Guardian of DBD::Informix - v2003.04 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
