what about reading the resultset into an array and then 'faking it' and using phps array functions to reorder the results etc.
Steve > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 30 April 2002 11:59 > To: [EMAIL PROTECTED] > Subject: PHP Cursor > > > Hy > > General Question: > What is the prefered way to realise a "cursor" scenario in a > SAPDB ODBC > PHP environment. Cursor scenario means there is a screen > which displayes > a subset of all fields of one dataset (all data of one row of > a database > table). With a NEXT and a PREVIOUS button I should be able to > scroll throu > all datasets (rows). The rows can be ordered by any database > field -> there > is no general available row numbering. > > I have lookt at CURSOR ("DECLARE nnnn CURSOR...") and named > Queryes with > ROWNO, but the result tables are destroyed as fast as they are build. > > What is the best way to realise this scenario also in terms > of performance > and size of data which is send to the client ? > > Any idea ? > > PS: There where some discussions on this topic, but they did > not end up > in a solution. > > > Matthias Flury > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
