search for: store_id

Hi, In my application I want to tranfer a variable (store_id) from one page to next without putting it into session. How should I do this? Is there any way to transfer variable from one to other page using methods other than sesion? Thanx Prash -- Posted via http://www.ruby-forum.com/.

Hi, I have 2 tables as follows:- _________________ ________________ ____________ taggings | |stores | | tags | -----------------| |---------------| |------------| --tag_id | |--store_id | |tag_id | --store_id | |--store_name | |tag_name | --user_id | |---------------| |------------| -----------------| Now I want to execute followin sql query on above tables:- "select name from tags where tag_id in (select tag_id from taggings where store_id in...

Hi, How do I associate two different tables which have a lookup id (table) as common. I tried the has_many :table2, :through => look_up_table in my table1 model. Any hints? Thanks, Hari -- Posted via http://www.ruby-forum.com/.

...ActiveRecord::Base; end class Store < ActiveRecord::Base; end class Department < ActiveRecord::Base; end class Product < ActiveRecord::Base; end A StoreType has many stores and a Store has many Department. However, both Store and Department have many products. An product has the columns store_id and department_id which are mutually exclusive. This is because a Product may belong directly to a Department, or it may be a ''global'' product that belongs directly to the Store. What I''d like to do is have an association in the StoreType model that would give me all pr...

Hi, I''m having trouble naming my join models. The tables in question are: - stores (list of company branches / stocking locations) - items (inventory items) - items_stores (item xyz is stocked by store_id 7, their re-order point is 10, their sales price $27.50) - items_locations (store_id 7 keeps part xyz on shelf B252) While I believe items_stores would be proper naming for a HABTM type relationship, everything I''ve found says to make up a new name for has_many :through join models. I&...

Here''s an intersting one: I have a client who wants to store hours of operation of a business for their RoR web app. I came up with a solution, but I really don''t like it. I have a MySQL table that has these fields monday_start, monday_end, tuesday_start, tuesday_end, etc., all as time fields. That''s all find and dandy. The kicker is, the client wants the hours to

Hi all, Haven''t played with rails for a while so I''m a little stuck. I''ve got to make a search functionality across models. Let me try to explain this (sorry for lack of clarity, I''ve been reading so many search gems etc that I''m a little fuzzy now): * Stores have town and county fields * Stores has_many Products which each have their own name and

...mysql_select_db($dbName) or die("Unable to select database $dbName"); //$query = "SELECT * from auto ORDER BY Date, Time"; $query = "select auto.Callerid,store.name,emp.employee,auto.Date,auto.Time,auto.Status from auto,store,emp where auto.Strid=store.store_id and auto.Empid=emp.id ORDER BY Date, Time"; $result = mysql_query($query); $number = mysql_numrows($result); print "There are $number records in the Database:<p>"; for ($i=0; $i<$number; $i++) { $v_callid = mysql_result($result, $i, "CallerID"...