search for: item_numb

...my sql dump to produce a very simple database. If anyone can get rails to work with this THEY WILL BE MY HERO!!. This is the statment I would normally use to create the join. "select * from parent,child where parent.number = ''2005121212121200'' and CONCAT(SUBSTRING(child.item_number,1,14),''00'') = parent.number" As you can see child.item_number is links to the parent with CONCAT(SUBSTRING(child.item_number,1,14),''00'') = parent.number. The last two digits of parent.number are incremented for each child.item_number. To top it off,...

This is my first rails app with a legacy database and I''m having a terrible time getting the models set up correctly. I have an order table that has a primary field named order_number. I have a name table with a primary of item_number. These two tables are liked by the item_number and the order_number, but not as you might think. If the order_number is 2500, then each entry in the name table will have it''s item number incremented by 1 (i.e. 2501,2501,2503). Here are my models class Order < ActiveRecord::Base...

...or in webrick then it crashes leaving nothing in the log. ruby: symbol lookup error: /usr/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.so: undefined symbol: mysql_sqlstate Here is the standard query I would normally write to get the data. select * from child,parent where CONCAT(SUBSTRING(child.item_number,1,14,''00'') = parent.order_number and parent.order_number = ''4444444444444400'' Here are my models and my database.yml class Parent < ActiveRecord::Base set_table_name :parent set_primary_key :order_number has_many :child,...

...le to specify the covariance matrix structure for the residuals. Here's the syntax using the lmer function in lme4 (which doesn't currently allow alternate error covariance structures). Does anybody know how to transform this to work with nlme? fit = lmer(data$DV ~ X + time + (X*time) + (1|Item_Number) + (1|Subject), data) Much appreciated, Ben Amsel -- View this message in context: http://www.nabble.com/Syntax-for-crossed-random-effects-in-nlme-tp25239714p25239714.html Sent from the R help mailing list archive at Nabble.com.

Hello everyone, I am looking for a way to pass off a simple payment to paypal using our own interface. I understand that this requires making full use of Paypal''s API since we won''t be using their shopping cart or anything. I found the article by Pranav Bihari on his site and in the Wiki on using SOAP4R and the paypal WSDL file to interface with paypal web services, but I