search for: stock_id

...yGetstockdataMySQL <- function(startdate, enddate, ticker) { con <- dbConnect(MySQL(), user="blahblah", password="blahblah", dbname="blahblah", host="localhost") rs <- dbGetQuery(con, "SELECT price.close FROM price INNER JOIN stocks ON stocks.stock_id=price.stock_ID WHERE (price.date_holding BETWEEN 'startdate' AND 'enddate') AND stocks.stock_ticker_yahoo IN ticker";) } I get all sorts of errors. I want to pass variables startdate, enddate and ticker. It would also be nice to pass the username, password and dbname informat...

I have a search form on my rails site. once the a user has entered a query it displays the results in a table with an extra field button so it can be added to there own portfolio called add to my stocks. How do i get the data for the stock they want to add and put this into a new table called mystocks. Is using a form submit button the right choice? Any examples much appreciated Regards Nick

1. A category has parent categories. 2. A product is in many categories and a category has many products. 3. Products and category both have images in the same image table. ie. a product and / or category could have multiple images.<=== my question is related to this So among other things I presume I have to do the following: class Category < ActiveRecord:Base #...

Hi, how can I map: :joins => "LEFT OUTER JOIN stocktbl ON stocktbl.stock_id = artisttbl.stock_id" into a stocktbl model object? -- Regards Andrew --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk...

...sword') fr <- dbGetQuery(db, 'SELECT date as "Date", open as "Open", high as "High", low as "Low", close as "Close", volume as "Volume", random() as "Adjusted" FROM stocks s INNER JOIN historical_prices hp ON s.id = hp.stock_id WHERE s.symbol = \'SDL\' ORDER BY date DESC limit 50') # copied from the mysql code in the quantmod source fr <- data.frame(fr[,-1],row.names=fr[,1]) fr <- xts(as.matrix(fr[,-1]), order.by=as.Date(fr[,1], origin='1970-01-01'), src='technica', updated=Sys.time()) c...

On my lab systems, the automatic updates were failing because of the problems with ipod libraries from EPEL being in the way. It turns out that was a good thing, because when I "fixed" it, a massive set of packages was updated, including the new gtk3. These packages are the ones causing problems, I think. gtk3-3.22.10-4.el7.x86_64 gtk3-devel-3.22.10-4.el7.x86_64 In the release notes,

Hi, I''m currently running an apache/jboss cocoon/flow/hibernate/ajax paypal (directpayment) project and am looking into the possibility of porting it across to ruby/rails. For that reason I would like to know the following: 1. Can I call my java classes or would I be looking at a complete rewrite in ruby? 2. How effective is ruby in terms of seperation of concerns regarding design from