[Error].ToString doesn't exists

[Xmair]

Line 2565

Code Select Expand

local Pos = GetSQLColumnData( q, 5 ).tostring();
The function LoadHouse()

Code Select Expand

function LoadHouse()
{ 
        local a = 1, HCount = HouseCount();
        while ( a <= HCount )
        {
                local q = QuerySQL( db, "SELECT Pos FROM Houses WHERE ID=" + a ); 
                local Pos = GetSQLColumnData( q, 5 ).tostring();
                CreatePickup( 406, Vector( GetTok( Pos, " ", 1 ).tofloat(), GetTok( Pos, " ", 2 ).tofloat(), GetTok( Pos, " ", 3 ).tofloat() ) );
                if ( a == HCount )
FreeSQLQuery( q );
                a ++;
        }
print( "Loaded: " + HCount + " houses." );
}Table

Code Select Expand

    QuerySQL( db, "CREATE TABLE IF NOT EXISTS Houses ( ID NUMERIC, Name TEXT, Price NUMERIC, Owner TEXT, Sharer TEXT, Pos TEXT )" );
HouseCount function

Code Select Expand

function HouseCount()
{
        local a = 0, q = QuerySQL( db, "SELECT * FROM Houses" );
        while ( GetSQLColumnData( q, 0 ) )
        {
                a ++;
                GetSQLNextRow( q );
        }
        return a; 
FreeSQLQuery( q );
}
Error

Code Select Expand

AN ERROR HAS OCCURED [the index 'tostring' does not exist]

CALLSTACK
*FUNCTION [LoadHouse()] Scripts/Functions.nut line [2565]

LOCALS
[q] NULL
[HCount] 1
[a] 1
[this] TABLE


[KAKAN]

Why don't you use .tointeger() ??

[.]

Code:

Code Select Expand

function dummy()
{
    return null;
}

print(dummy().tointeger());
Output:

Code Select Expand

AN ERROR HAS OCCURED [the index 'tointeger' does not exist]
Do you see the issue now ? Try this way to see if I was right.

Code:

Code Select Expand

function dummy()
{
    return null;
}

print(dummy() + "");
Output:

Code Select Expand

[SCRIPT]  (null : 0x00000000)

[EK.IceFlake]

tostring doesn't exist at all.
function tostring(str)
{
    return str+"";
}

[DizzasTeR]

tostring doesn't exist at all.
function tostring(str)
{
    return str+"";
}

What stupidity is this if I may ask.

[EK.IceFlake]

tostring doesn't exist at all.
function tostring(str)
{
    return str+"";
}

What stupidity is this if I may ask.

Well I once dealt with integers and they didn't have .tostring. I assume same with floats

[KAKAN]

.tostring() exists, I have used it in my wep command

[.]

Integers/Floats/Booleans/Strings they all have tointeger(), tofloat(). tostring() The remaining types don't have it with the exception of custom objects which can manually implement it.

But I'm guessing that no one gave a f* to that post I made detailing the fact that null doesn't have it and is one of the return types of GetSQLColumnData() once it fails to retrieve the specified column data.

And as a fun story this is my 777'th post

[rObInX]

If you gave a look at S.L.C's post.
But, none did.

Here is the code coz no one understand words, only codes....

Code Select Expand

local Pos;
if ( GetSQLColumnData( q, 5 ) )
{
    Pos = GetSQLColumnData( q, 5 ).tostring();
    //rest of your stuf.
}
else No house

[Kratos_]

GetSQLColumnData operates over the value returned by query & not the actual table in the database .

Code Select Expand

local q = QuerySQL( db, "SELECT Pos FROM Houses WHERE ID=" + a );
local Pos = GetSQLColumnData( q, 5 ).tostring();
Your query is selecting just one column "Pos" from the actual table . But , you're attempting to get 6th column which the query never returns . To fix this , simply write this :-

Code Select Expand

local q = QuerySQL( db, "SELECT Pos FROM Houses WHERE ID=" + a );
// First & only column which is selected through query
local Pos = GetSQLColumnData( q, 0 ).tostring();
OffTopic : You shouldn't select entire table just for counting no of rows .

[Xmair]

Thanks to everyone, It's fixed and I learned something more.
Anyway, Another one.

Code Select Expand

onPlayerCommand Error : Cannot convert the string

Code Select Expand

else if ( cmd == "addhouse" )
{
if ( !text ) MessagePlayer("/addhouse <Pickup ID> <Housename> <HousePrice>",player)
else
{
local housepickup = GetTok( text, " ", 1 ).tointeger();
local housename = GetTok( text, " ", 2 ).tointeger();
local houseprice = GetTok( text, " ", 3 ).tointeger();
  CreatePickup( 406, player.Pos )
QuerySQL( db, "INSERT INTO Houses ( ID, Name, Price, Owner, Sharer, Pos ) VALUES ( '"+housepickup+"', '"+housename+"', 'Vice-City', 'None', '"+player.Pos+"')");
MessagePlayer("Created house, ID :- "+housepickup+". Name :- "+housename+". Price :- "+houseprice+"!",player)
}
}

[.]

Same story:

Code Select Expand

local my_str = "xyz";

print( my_str.tointeger() );
Output:

Code Select Expand

AN ERROR HAS OCCURED [cannot convert the string]
Can you convert "xyz" to a number?

[Xmair]

Hahaha @S.L.C Fixed XD