[dusk]

Thanks for the information. What transactions are we talking about?


Different question. I want to send one query in another ones function. If I do that I get this warning:

pawn Код:

[WARNING] cache_get_row_count - no active cache

pawn Код:

public OnDMZoneLoad()
{
    new query[50];
    for(new i; i < cache_get_row_count(); i++)
    {
        format(query,sizeof(query),"SELECT * FROM dm_area_points WHERE AreaId = %d",cache_get_row_int(i,0));
        new Cache:r = mysql_query(DbHandle,query);
        if(cache_get_row_count())
        {
            //something
        }
        cache_delete(r);
    }
    return 1;
}

I would make the second query threaded, but I will need data from the first one...

This has been on my mind for quite some time.. Or is my table design flawed?