How do I get the contents of a selected row from a YUI datatable?

I'm trying to get the contents of a cell in a row in a YUI datatable.

I can use myDataTable.getSelectRows()[开发者_JAVA百科0] to get the first selected row. However, how do I get the contents of the first cell in that row?

It looks like getSelectRows() returns an array of record IDs. You can retrieve the corresponding record using getRecord(). Once you have a record, use getData() to retrieve the value of the field you are interested in.

var recordID = myDataTable.getSelectRows()[0],
    record = myDataTable.getRecord(recordID);
console.log(record.getData("myField"));

http://developer.yahoo.com/yui/docs/YAHOO.widget.DataTable.html#method_getRecord http://developer.yahoo.com/yui/docs/YAHOO.widget.Record.html#method_getData

I think I may have the answer for you assuming you have not already found it yourself.

I have the same kind of page with a datatable and a textarea field, when you select a row in the datatable calls the same page displays further detail from the selected row in the textarea field and retains selection of the selected row.

1: To do this I apply the following example MySQL query called AllMyBroadcasts...

SELECT @rownum :=@rownum + 1 RowNumber, p.* FROM tblBroadcasts p, (SELECT @rownum := 0)r ORDER BY Date DESC

the tblBroadcasts table has fields : Date, Narrative, ID

2: I then provide the following to the table row of my YUI Datatable within HTML hyperlink tags.

href="MyPage.php?SelectedBroadcastID=' .$row_Broadcasts['ID'].'&RowNumber=' .($row_Broadcasts['RowNumber'] -1 )

3: When the href is clicked MyPage reload with additional parameters SelectedBroadcastID and RowNumber the SelectedBroadcastID I use in a second query against tblBroadcasts called MySlectedBroadcast which a simple query on outputting all fields where the ID = SelectedbordcastID. I then to my field to display the narrative of my selected row in my textarea field.

The second paramater I do the following with.

$SelectedRowID = 0; if( isset($_GET['RowNumber'])) { $SelectedRowID = $_GET['RowNumber']; }

Above I placed just after code covering my two queries.

4: Then finally to get the datatable to select the row of the selected row I include the following to the var yuidatdatable section of the datatable script...

yuidatatable1.select(yuidatatable1.getRow());

The -1 value referred to step 2 serves as a work around to fact that yuidatatable works on a 0 base and the MySQL referred to in step 1 on a 1 base.

There you go !

Perhaps there is a better why using get from within YUIDatatable scripting, be nice to know if so. That said this work fine for me and perhaps if you have not found an answer I hope this helps.