[almcaeobtac]

I'm trying to fix a friend's code, but I don't understand SQL at all. Basically no data is loading. It might be because it isn't saving too. The only error in the logs is this:

[SM] Native "SQL_FetchInt" reported: Error fetching data from field 3

What does this mean?

[Dravu]

In your SQL query, you only return 2 columns. Your coding is trying to grab a 3rd column that doesn't exist.

[Monkeys]

Columns use indexes, so you start with getting from column "0"

(It's a lot easier to see what's wrong if you show what you did, aka. your query ;p)

[almcaeobtac]

It's difficult. It's not my code, and he doesn't want to share it. Plus, in the error logs, it doesn't even return the correct line number for the error.

[Monkeys]

Well, most likely it's just a wrong index used for the column.

Check the query, the "SELECT ... FROM" part. The results are arranged exactly as they are there. Each column is seperated by a comma and they start with index 0.

So this "SELECT alpha, and, omega FROM universe WHERE god = 0;"
would result in
column 0: alpha
column 1: and
column 2: omega

In his case, he probably fetched from column 3 while he meant column 2. Or column 3 isn't an int.


(Offtopic: That isn't a query I just made up, it's actually part of a project I once made )

[almcaeobtac]

What about when it's like this:

Format(buffer, sizeof(buffer),"SELECT * FROM Player WHERE STEAMID = '%s';",SteamId);