Member Avatar for teafang
teafang 0 Newbie Poster

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)?

  • 1 Contributor
  • 0 Replies
  • 52 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.