QueryRowData

Returns the cells of a query row as a structure

Method Signature

QueryRowData(query=[query], rowNumber=[integer])

Arguments

Argument

Type

Required

Description

Default

query

true

The query object to which the row should be returned.

rowNumber

integer

true

Position of the query row to return.

Examples

The simple queryGetRow example

Here we've a example to get the particular row value from myquery.

<bx:set myQuery = queryNew( "id,name,age", "integer,varchar,integer", [ 
	[
		1,
		"Dharshini",
		20
		],
	[
		2,
		"Subash",
		18
		]
	] ) >
<bx:dump var="#queryrowdata( myQuery, 2 )#"/>

The simple getRow example

We've example to get the particular row value from myquery using script syntax.

<bx:script>
	var myQuery = queryNew( "id,title,author", "integer,varchar,varchar", [
		[
			1,
			"Charlottes Web",
			"E.B. White"
		],
		[
			3,
			"The Outsiders",
			"S.E. Hinton"
		],
		[
			4,
			"Mieko and the Fifth Treasure",
			"Eleanor Coerr"
		]
	] );
	writeDump( myQuery.getRow( 3 ) );
</bx:script>

Additional Examples

Run Example

q = queryNew( "id,name", "int,varchar" );
q.addRow( 4 );
q.setCell( "id", 1, 1 );
q.setCell( "id", 2, 2 );
q.setCell( "id", 3, 3 );
q.setCell( "id", 4, 4 );
q.setCell( "name", "one", 1 );
q.setCell( "name", "two", 2 );
q.setCell( "name", "three", 3 );
q.setCell( "name", "four", 4 );
dump( q );
dump( QueryRowData( q, 2 ) );

PreviousQueryReverse NextQueryRowSwap

Last updated 7 months ago

Was this helpful?

hashtagMethod Signature

hashtagArguments

hashtagExamples

hashtagThe simple queryGetRow example

hashtagThe simple getRow example

hashtagAdditional Examples

hashtagRelated