Not sure what the standard method means, but you want to avoid using an execute query as it will cause lags, if this is what you are referring to.
I gave you an idea in my code snippet. You can execute the handler function once the result is determined:
Code:
public _SqlGetUserIndex
(fail_state, Handle:query, error
[], error_code, data
[], data_size
)
{
// check fails, etc....
new id = data
[0]
if(SQL_NumResults
(query
))
{
VarTest
[id
] = SQL_ReadResult
(xQuery,
0)
UserFound( id );
}
else
{
VarTest
[id
] =
-1
UserNotFound( id );
}
}