TimeStamp

Hi, I want to display a list of new messages from a user's chat page.

At the moment, my code is: SELECT Message FROM <tableid> WHERE TargetUser = <currentuser> AND TimeStamp = (from between the time when the user last opened the page and now).

Is there any way to calculate this?

I have saved the time when the user exited the page into a variable and the time when the user opened it again into a different one.

I just want to know how to get all the messages where the target user is the current one and the timestamp is from between the time when the user last opened the page and now.

-- 

According to the SQL Reference at https://developers.google.com/fusiontables/docs/v2/sql-reference

you will need an extra filter clause on the timestamp column

to set the lower bound.

You don't need an upper bound, because you want to see everything till now.

Save the timestamp in TinyDB (tag = "LastTimeStamp") after each message, for future reference next time you start this app.

See the SQL Reference for the special formats recognized for timestamp comparison.

Filtering on DATETIME

When filtering on a column of type DATETIME, the <value> should be formatted as one of the following supported formats:

⦁ MMM dd, yy
⦁ MM/dd/yy
⦁ MM-dd-yy
⦁ MMM-dd-yy
⦁ yyyy.MM.dd
⦁ dd-MMM-yy
⦁ MMM/yy
⦁ MMM yy
⦁ dd/MMM/yy
⦁ yyyy

-- 

Oh, and by the way, you need timestamp >= , not timestamp =.

-- 

So would this work?

SELECT Message FROM <tableid> WHERE TargetUser = <currentuser> AND TimeStamp >= <LastTimeStamp>

-- 

Try it.

Catch the outgoing SQL statement somewhere so we can read it,

and see how it worked.

-- 

I'm not quite sure how to get the SQL statement, but it definitely worked! :)

Thanks!

--

I'm not quite sure how to get the SQL statement

use Do it, see also https://puravidaapps.com/fusionerror.php

--