Please enable JavaScript to view this site.

Navigation: Advanced topics > Programming topics > Database API > QueryResult object

PHPrunner32x32     ASPRunnerPro manual


Database API: value( fieldname or index )

Scroll Prev Next More

 

This is an alternative way of working with the query. Covenient to use when the query returns a single record.

 

This function should not be used together with fetchAssoc or fetchNumeric.

 

Syntax

 

value( fieldname or index )

 

Arguments

fieldname or index

 

Return value

 

Value.

 

Example1

 

set rs = DB_Query("select * from Cars where id=20")
ResponseWrite ArrayElement(rs,"make")

 

Example2

 

set rs = DB_Query("select  count(*) from Cars");
ResponseWrite ArrayElement(rs,0)