[Help] toJSON/fromJSON

[Tekken]

HI, i need some help on toJSON and fromJSON.

My problem is this:

I save ID, NUMBER like this:

local json = toJSON({ ID, NR }) 

Everything work's ok but I need to save like 20 ID's and 20NR's but each time will overwrite the old ID/NR and I don't want that...

Any help ?

[Walid]

show me your code

[Tekken]

I can't show my full code but

SAVE

local theID = getElementModel(element) 
local thenr = getElementHealth(element) 
local json = toJSON({theID, theNr}) 
--- Bla, bla 
dbQuery(db, "INSERT INTO table(json) VALUE(?)", json) 

LOAD

local theID, theNr = unpack(fromJSON(json)) 

[ALw7sH]

you used INSERT not UPDATE

so nothing will be rewrited

[Tekken]

you used INSERT not UPDATE

so nothing will be rewrited

Yes but will still overwrite the old values...

[ALw7sH]

no it wont lol

[Tekken]

Ohh, man but that's my problem..., why don't you understaind ? IS OVERWRITING old values!!

[ALw7sH]

http://www.w3schools.com/sql/sql_insert.asp

The INSERT INTO statement is used to insert new records in a table.

[Tekken]

Do you know how to/fromJSON work's ? when i send that data in THE SAME json will OVERRITE old data! and keep only the last one.

[Walid]

Do you know how to/fromJSON work's ? when i send that data in THE SAME json will OVERRITE old data! and keep only the last one.

Man you are inserting new values every time did you tired :

dbExec(db, "UPDATE table(json) SET value = ? WHERE yourData = ?", json) 

[Tekken]

Do you know how to/fromJSON work's ? when i send that data in THE SAME json will OVERRITE old data! and keep only the last one.

Man you are inserting new values every time did you tired :

dbExec(db, "UPDATE table(json) SET value = ? WHERE yourData = ?", json) 

this will just give NULL.

[Walid]

dbExec(db, "UPDATE table(json) SET value = ? WHERE yourData = ?", json) 

this will just give NULL.

maybe you did something wrong that's why i asked you to show me your code.

Edited May 1, 2015 by Guest

[Tekken]

Everything works ok only that thing, and i think that's normal, I came here because i thought somebody will give me a better idea.

[ALw7sH]

How we can help you if you dont want to show us your full codes? and the way that you reply us is so rude

[Tekken]

How we can help you if you dont want to show us your full codes? and the way that you reply us is so rude

I was a bit angry because i have some problems, but you didn't want to understand.

[Walid]

How we can help you if you dont want to show us your full codes? and the way that you reply us is so rude

I was a bit angry because i have some problems, but you didn't want to understand.

Bro how we suppose to know what is creating problem, you need to show us your full code because it's the only one solution.

[ALw7sH]

It's ok, can you explain what you want to do and show us your sql save/load codes?