Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 23rd, 2012  |  syntax: None  |  size: 2.35 KB  |  hits: 8  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. puts "query: " + query
  2. #SELECT * FROM splayd_selections WHEREjob_id='2' AND selected='TRUE'
  3.  
  4.                 m_s_s = $db.select_all query
  5.  
  6.                 $db.select_all query do |ris|
  7.                         puts "#{ris}"
  8.                 end
  9. ## using the block:
  10. [14, 126, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:87e0f4c,'0.22149E0',8(12)>, 18435]
  11. [15, 167, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:87e0920,'0.20374E0',8(12)>, 13048]
  12. [16, 165, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:87e02e0,'0.16485E0',8(12)>, 13049]
  13. [17, 172, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:87dfc3c,'0.16179E0',8(12)>, 13050]
  14. [18, 78, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:87df5d4,'0.16478E0',8(12)>, 13387]
  15. [20, 109, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:87deef4,'0.20473E0',8(12)>, 13388]
  16. [21, 131, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:87dc53c,'0.15774E0',8(12)>, 13217]
  17. [22, 130, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:87dbc90,'0.21544E0',8(12)>, 13218]
  18. [24, 168, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:87db63c,'0.16857E0',8(12)>, 13047]
  19. [25, 132, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:87dae94,'0.16809E0',8(12)>, 13216]
  20.  
  21.  
  22.                 m_s_s.each do |t| puts "#{t}"  end
  23.  
  24. ## using the .each :
  25. [25, 132, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:88397b4,'0.16809E0',8(12)>, 13216]
  26. [25, 132, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:88397b4,'0.16809E0',8(12)>, 13216]
  27. [25, 132, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:88397b4,'0.16809E0',8(12)>, 13216]
  28. [25, 132, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:88397b4,'0.16809E0',8(12)>, 13216]
  29. [25, 132, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:88397b4,'0.16809E0',8(12)>, 13216]
  30. [25, 132, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:88397b4,'0.16809E0',8(12)>, 13216]
  31. [25, 132, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:88397b4,'0.16809E0',8(12)>, 13216]
  32. [25, 132, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:88397b4,'0.16809E0',8(12)>, 13216]
  33. [25, 132, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:88397b4,'0.16809E0',8(12)>, 13216]
  34. [25, 132, 2, "TRUE", nil, "WAITING", "FALSE", "TRUE", #<BigDecimal:88397b4,'0.16809E0',8(12)>, 13216]
create a new version of this paste RAW Paste Data