SQLite set multiple values

eyal282 · **Author**

Format(sQuery, sizeof(sQuery), "UPDATE %s SET value = %s, timestamp = %i WHERE AuthId = \"%s\"", Name, Value, timestamp, AuthId);

This query throws an error, as I can't set value and timestamp together. How to set it?

mug1wara · 08-09-2018 , 10:50 Re: SQLite set multiple values

"timestamp" is an sql function...

eyal282 · 08-09-2018 , 11:10 Re: SQLite set multiple values

Quote:

Originally Posted by mug1wara

"timestamp" is an sql function...

Please also answer the thread's question so I won't need to ask again when I actually need it and tell me how to set and get the timestamp in sql

Walgrim · 08-09-2018 , 11:23 Re: SQLite set multiple values

If you want to get the timestamp, use the GetTime() function.
https://sm.alliedmods.net/new-api/sourcemod/GetTime

mug1wara · 08-09-2018 , 11:23 Re: SQLite set multiple values

Sure, would be easier though if you tell us what error it is.

eyal282 · *Last edited by eyal282; 08-09-2018 at 11:50.*

Quote:

Originally Posted by mug1wara

Sure, would be easier though if you tell us what error it is.

Something near the symbol ","

@Walgrim

I meant getting and setting timestamp with sql.

Walgrim · 08-09-2018 , 12:08 Re: SQLite set multiple values

Quote:

@Walgrim

I meant getting and setting timestamp with sql.

If I'm not wrong you want to set the playtime of a player using timestamp?

eyal282 · 08-09-2018 , 13:35 Re: SQLite set multiple values

Quote:

Originally Posted by Walgrim

If I'm not wrong you want to set the playtime of a player using timestamp?

I want last updated using timestamp

Neuro Toxin · 08-09-2018 , 17:32 Re: SQLite set multiple values

You are spamming the crap out of this forum with SQL help.

Have you consideres using google?

SQL [question]

Stackoverflow has all the answers.

Psyk0tik · 08-09-2018 , 18:30 Re: SQLite set multiple values

Quote:

Originally Posted by Neuro Toxin

You are spamming the crap out of this forum with SQL help.

Have you consideres using google?

SQL [question]

Stackoverflow has all the answers.

I was gonna suggest to him to just make 1 thread called "SQL Questions" that he can just update with any new questions he may have. It seems that most of the threads he made just has Mug1wara mostly replying along with 1-2 other people.