Advertisement
Guest User

Untitled

a guest
Jun 17th, 2016
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. get '/all_users/' do
  2. conn = TinyTds::Client.new(username:'nicole', password:'pass', dataserver:'Nikki-PCMydatabase', database:'Thedatabase')
  3. recordsArray = "{"clientList":["
  4. clientArray = Array.new
  5. sql = 'select * from dbo.ServerUsers'
  6. records = conn.execute(sql) do |record|
  7. client = AndroidtableClientsSearch.new(record[0],record[1],record[2],record[3], record[4])
  8. clientArray<<client.to_s
  9. end
  10. recordsArray<<clientArray.join(',')
  11. recordsArray<<"]}"
  12. recordsArray
  13. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement