Pawan Kanda wrote:
>
> Hi , i have the following method:
>
> public Object getValueAt(int row, int column){
> // in here i want to construct a SQL query which gives the object at a
> certain
> row and column
> }
>
> Do you know how to do it?
>
> Thanks
> Pawan
>
Maybe make your sql statement read
sql = "<your query here> " + " LIMIT " + row + ",1";
.. run your query ..
then you would just return
myrecordset.get<whatever>(column);
if you need to make many calls to this get value it would be very slow,
you should maybe run the query and set it to some object in the class
so you can just pull from it (like an array), unless it is HUGE, but
then there are trade-offs, the above will be required to run the query
every time you access the method.
---------------------------------------------------------------------
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
