hi , i have problem when my application board (content http client) sending data to database SQL-font.
i have try to run the query in PC, it can work, but if my remote httpclient(board) connect to InstantRails server to send data to SQL is not working well..
query:
SELECT o1.* LEFT JOIN o1 stats AND o2 stats ON o1 name = o2 name AND o1 created_on < o2 created_on WHERE o2 name IS NULL ORDER BY o1 name ASC
two aliases refer to same table : stats.
how to write query for data sending from my board? i want INSERT INTO database and query in aliases table. so anyone got idea? or how i connect the database SQL to my board? what should i setting in SQL? session? change localhost connection to pc server(such as 10.6.2.57)?