Squirrel/Server/Functions/SQLite/sqlite column data

Latest revision as of 17:05, 25 October 2010

This function returns the column count in the query result struct. Note that column values are automatically converted to integers, floats or strings. If the result struct has no rows/columns, the function will return null.

[edit] Syntax

int/float/string sqlite_column_count( UserPointer result, int column )

[edit] Arguments

• result - This is a pointer to a result struct retrieved from sqlite_query or sqlite_next_row
• column - This is the column you wish to return the value for. Column indexes begin from 0

[edit] Example

This will print the returned data if there is any when someone types 'result' into the server console.

 
function onScriptLoad()
{
	LoadModule( "lu_sqlite" );
	pSQDatabase <- sqlite_open( "database.sqlite" );
	
	return 1;
}
 
function onConsoleInput( szCommand, szText )
{
	if ( szCommand == "result" )
	{
		local query = sqlite_query( pSQDatabase, "SELECT Foo FROM Bar WHERE FooBar='" + szText + "'" );
		if ( query )
		{
			local data = sqlite_columndata( query, 0 );
			if ( data ) print( "Result: " + data );
			else print( "No data found!" );
		}
	}
	
	return 1;
}
 

[edit] 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.

[edit] 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