Andreas Metzner writes:
> Hello all,
>
> I'm using the libmysql.dll API to interface to a mySQL-Server Database.
> The GUI client is generic, so the user can bind any SELECT query on
> a large database (Logging database).
>
> How can I prevent the mySQL client to use mysql_store_result (),
> since this would transfer the whole query result to the client.
>
> With mysql_use_result () I have the problem, that the client do not
> know in front, how many records matched the query.
>
> But if the GUI client user wants to see the last but 30 query result
> records, e.g.,
> I have to know recordnumber of the last matching record.
>
> Does anyone had the same problem, since I guess it's a fundemental one ?!
>
> Thank You in advance.
>
> Andreas Metzner
> MAN Roland AG
> Software Management DICO
> [EMAIL PROTECTED]
Hi!
Solution is quite simple. Use our mysqlgui.
You will find it on our pages.
It can accomodate a result set of 10 Gb in 100 Kb of RAM.
And your user can open as many spreadsheets containing huge result
sets as he / she wishes to, in the same time.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
