database variables calculation in ruby

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • monica23
    New Member
    • Nov 2011
    • 1

    database variables calculation in ruby

    Hi everybody, in my database, am trying to print the value of total and then add it to the price,
    i was able to fetch the value of total but when i tried to add it to to price so as to get value of sum in this line
    of code

    Code:
        sum = price + %s, row[0]  
        puts "sum"
    nothing happens. where am i supposed to perform the operations, is outside the loop. below is the code, any help please

    Code:
        #!/Ruby19/bin/ruby 
        require 'cgi'
    
        cgi = CGI.new
        puts cgi.header
    
        require "dbi"
    
    
    
         price = '100'
        begin
           # connect to the MySQL server
             conn = DBI.connect("DBI:Mysql:db:localhost", 
        	                    "root", "root566")
    
            rs = con.query("SELECT total from product where product_id = '20'")
    
           row = stmt.fetch do
              
           end
           puts "<font color=green size=4><b>get total values</b></font><br><br>"
    
         printf '<b>total:</b> %s<br>', row[0]
    
         sum = price + %s, row[0]  
        puts "sum"
         
           
                 
        rescue Mysql::Error => e
            puts e.errno
            puts e.error
            
        ensure
            con.close if con
        end
Working...