Squirrel/Server/Functions/SQLite/sqlite column count

Revision as of 16:50, 25 October 2010

This function returns the column count in the query result struct.

Syntax

int sqlite_column_count( UserPointer result )

Arguments

• result - This is a pointer to a result struct retrieved from sqlite_query or sqlite_next_row

Example

This will print the column count from the query when '/colcount' is typed into the server console.

 
function onScriptLoad()
{
	LoadModule( "lu_sqlite" );
	pSQDatabase <- sqlite_open( "database.sqlite" );
	
	return 1;
}
 
function onConsoleInput( szCommand, szText )
{
	if ( szCommand == "colcount" )
	{
		local query = sqlite_query( pSQDatabase, "SELECT Foo FROM Bar WHERE FooBar='" + szText + "'" );
		if ( query ) print( "Column count - " + sqlite_columncount( query ) );
	}
 
	return 1;
}
 

Notes

The function LoadModule and sqlite_open and sqlite_query and print and event onScriptLoad and onConsoleInput were used in this example. More info about them in the corresponding pages.

For a larger example, check the SQLite database example from the wiki tutorials.

Related Functions

These functions are provided by the official module lu_sqlite.

• sqlite_close
• sqlite_column_count
• sqlite_column_data
• sqlite_free
• sqlite_next_row
• sqlite_open
• sqlite_query