similar to: multiple checkboxes from another sql table

I''m having issues getting checkboxes to update a cross-reference table correctly. I keep seeing entries in the locations_users table, for location_id and user_id, "11" and "2", respectively. The user id is fine, but there is no such location with id 11. There are only 5 locations and their ids go from 1-5! I can''t seem to find where the 11 is coming from.

I am displaying a bunch of records from a table called "assets". Next to each record i have a checkbox. When this box is checked i want to be able to save the id of the record into another table called "flagged_assets". All I need is the ID, nothing else. Im struggling with the logic to save to another table. I know how to do it if the asset_id is already in the

I am trying to use the fourth normal form for my applications so that i can get the information in the appropriate language. I have a table called manufacturers. I have another called descriptions. The descriptions are in two languages and each description belongs to a particular language. So two records in the Descriptions table one in English and One in French for each manufacturer. The

Hello all. I am trying to get the following SQL to work in Ruby on rails and Oracle. SELECT bugsheet.*, bugcomplete.bc_time FROM bugsheet, bugcomplete WHERE bugsheet.bs_id = bugcomplete.bc_id AND bugsheet.bs_patchrel like ''5.1.12-B4%'' ORDER BY bs_cdate DESC, bc_time DESC If I type that into an SQL program it works fine, if I try and use the following in RoR:

Please could someone suggest what might be wrong here. In my view I''m displaying a series of check boxes and when the form is submitted I want the controller to iterate over the values and contatenate them all into a string "1" if the box was checked and "0" if it wasn''t. I''m new to Ruby and Rails and I can''t seem to get any values out of

I''m having trouble figuring out how to do Ferret queries across multiple tables as you would in a normal SQL call. For example, let''s say I have two ActiveRecord classes, Book, and Author, where Book has a ''description'' field and Author has a ''name'' field, and where Book has a belongs_to relationship with Author (Book belolngs to Author,

All, Rails 1.1.6. Any AR find() call that generates a SELECT * type query against a table with a DATETIME column in SQL Server whose value occurs before 1970 will fail, because of the coercion of SQL Server datetime types to Time values in Ruby. See sqlserver_adapter.rb line 490 (record[col] = record[col].to_time if record[col].is_a? DBI::Timestamp) If I remove the coercion (just commenting

Hello! I have this page where I list all users in a table. There is checkbox in every row. My User-model has a "checked"-attribute. I have implemented the checkboxes like this: <%= check_box("user[]", "checked") %> Which outputs this: <input id="user_12_checked" name="user[12][checked]" type="checkbox" value="1"

All, Win XP SQL Server 2000 Rails 1.1.6 (AR 1.14.4) I have two objects (Job and Warning) in a HABTM relationship. Below are the pertinent sections of the model files and the schema for the join table. job.rb: class Job < ActiveRecord::Base has_and_belongs_to_many :warnings, :foreign_key => ''JobReferenceNumber'' set_table_name :JobData set_primary_key

All, I''m populating a view with checkboxes in a list. I want to be able to assign to my has_many relationship using the post values of these checkboxes. Essentially, I want to populate the relationship table which will create the correct join values in my model. Here is my check_box_tag code: <%= check_box_tag("@current_job[target_list_ids][]",

Hey Rails People, I''m doing my first Rails app and I''m having a newbie problem with the count method.... Mysql::Error: #42S02Unknown table ''jobs_sectors'' in where clause: SELECT COUNT(*) FROM jobs WHERE (jobs_sectors.sector_id = 1 ) Extracted source (around line #4): 1: <div class="sectors"> 2: <ul> 3: <% for sector in @sectors

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

Hi I have another question for how best to do this. Now I have been following the tutorial at: http://www.tunaslut.com/learning-ruby-drop-down-lists-in-one-to-many-relationships, however when I change the view over from <% @cities.each do |city| %> <tr> <td><%=h city.city_name %></td> <td><%=h city.country_id %></td> to: <%

Please always cc the list... the group usually has better answers than any one person, and I don't do private consulting on the net. For future reference, there is also an r-sig-db mailing list where this question really belongs. Since I almost never use jdbc, I would need a reprex (hint you are ignoring my advice... a good way to get ignored), which this still isn't. There is probably

Hi I''m having a really hard time trying to get a specific form in RoR to work. I''m trying to build a really simple page which lets the user make a pizza by setting check boxes. The choose their toppings, click submit and the form does a callback and shows them how much it will cost to have a pizza with those toppings on. At the moment I have the following: View: <%=

I am attempting to document a join between two tables. There seems to be no writing to my database. Please help me out it is driving me absolutly crazy. Basically i''ve got a table of directors that is called when the new/edit controller model for films is activated. It shows the user a selectable list of directors they can apply to films. The problem is in the update/create part. I

Hi Friends, I am trying to import a table from SQL server to R(2.9.0), however i am getting errors while running the below codes. Can anyone identify and let me know where did i go wrong??? Thanks in anticipation :) library(RODBC) myconn <- odbcConnect("RDATABASE") myconn RODB Connection 6 Details: case=nochange DSN=RDATABASE Description=Database for R UID=Madana_Babu

Perhaps I should create a table row to hold an array of category ID''s? There''s probably an easy standard way of doing this in RoR and I just can''t wrap my brain around a practical way to do this right off. Specifically... I have a table that contains my product category names and another table that contains my actual product names with other product specific

Hello, I'm new to R so this is probably a simple question for somebody. I have an RScript that reads a CSV on the disk using read.table(...). It then does a boxM test using that data. However, I'm now trying to load the same data via an SQL command, but I can't seem to get the data structure defined so R will like it -- using the included "iris" dataset. I've tried

I am migrating to sql server 2000 from postgres and I have tried char(1), int, tinyint and bit datatypes to replace booleans, but without luck. the 1''s and 0''s are stored properly in the db, but checkboxes and dropdowns are not being auto-populated in rails. Anyone experience this before? thanx -- View this message in context: