search for: order_numb

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). He...

...e 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, :clas...

...-- -- Dumping data for table `child` -- INSERT INTO `child` VALUES (''2005121212121201'', ''charlie'', ''bowman''); -- -------------------------------------------------------- -- -- Table structure for table `parent` -- CREATE TABLE `parent` ( `order_number` varchar(16) NOT NULL default '''', `client_id` varchar(16) NOT NULL default '''', `submitted_by` varchar(8) NOT NULL default '''', PRIMARY KEY (`order_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `parent` --...

...image_width: '''' other_display_type: subitem_count: answer_total: item_text: "<span style=\"font-weight:bold\">When a good has positive network externalities, this means that when using the product:</span>" order_number: 26 item_alias: '''' image_path: '''' maximum_number_responses: maximum_length: item_type_id: 3 database_sql: '''' other_text: "Other, please specify" required_yn: N However there -- Poste...

...@order_account = OrderAccount.new(params[:order_account]) 29 @order_account.valid? 30 31 OrderUser.transaction do 32 @order_user.save! 33 Order.transaction do 34 @order = @order_user.orders.build(params[:order]) 35 @order.order_number = Order.generate_order_number 36 @order.save! 37 end 38 OrderAddress.transaction do 39 # Addresses 40 @billing_address = @order_user.order_addresses.create(params[:billing_address]) 41 @billing_address.order_id = @order.id...

hello it seems like this question has appeared a few times with no answer: how do you get rails to issue ''write'' statements (ie ''CREATE/UPDATE'') to the database without committing each time? I tried setting ActiveRecord::Base.connection.begin_db_transaction before calling any action on my object, but as soon as myObject.save or myObject.update is called,

Hi Railers, Does anyone have any guidance on setting up a simple way to handle product variations (e.g garment size/color)? Initially, I had thought that I would make a variation model which defined the extra bits, but it seems quite inflexible especially so if a store were to sell non-clothing items that also had variants of one flavor or another. product has_many variations title

...rrect. I have a sample of the shipping order. You can use your own system to generate it, just please make sure you have placeholders where all the database stuff goes so that I can easily change it out. E.g. - If a cell has the order number, then i would expect to see something like @order.order_number in the file you deliver to me so that I can map it to my own database columns. Please reply to me directly if you can help and let me know how much you will charge for this task and what kind of time frame you can deliver it in. My need is pretty immediate because right now I''m do...