Pulling Data from Sqlite

BYOND Forums

Announcements · BYOND Help · Bug Reports · Feature Requests · Beta Testers · Beta Bugs · Developer Help · Design Philosophy · Demos & Libraries · Tutorials & Snippets · Art & Sound · Classified Ads · Game Updates · Contests & Events · Linux Talk · On Topic · Off Topic

ID:2050387

Mar 10 2016, 7:30 am

(See the best response by Ter13.)

Mouchy

Code:

    var/database/query/q = new("SELECT item_id FROM Player_Inventory WHERE byond_key = ?", byond_key)
        var/list/row
        if(q.Execute(db))
            while(q.NextRow())
                row += q.GetRowData()
            return row

Problem description:
So I have a database query returning multiple rows of results.

I am them looping through collecting the row data.

In the end I am printing out the results like this:

world << list2params[row] //This is the returned value

I am expecting to see:
item_id=5&item_id=6&item_id=7

What I am seeing is:
item_id=7&item_id=7&item_id=7

This has to be the mistake but I am not getting what I am doing wrong.
row += q.GetRowData()

Mar 10 2016, 7:31 am
Ter13	EDIT: Nevermind. Can you show the actual query you are performing?

Mar 10 2016, 7:34 am In response to Ter13
Mouchy	Ter13 wrote: EDIT: Nevermind. Can you show the actual query you are performing? Updated If I world << in the while loop the correct values are coming across.

Mar 10 2016, 7:38 am Best response
Ter13	Oh. I see. The problem is that you are adding associative indices to the list. You can't add the same associative index to a list multiple times.

Mar 10 2016, 7:41 am In response to Ter13
Mouchy	Ter13 wrote: Oh. I see. The problem is that you are adding associative indices to the list. You can't add the same associative index to a list multiple times. Ah that makes sense. So I would need to parse out the item_id before I added it to the list. That makes sense. Thanks for the help.