similar to: Migration and Mysql row ID

Hello, I created a table in MySQL with this command CREATE TABLE example (pk INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(pk), id VARCHAR(30),col1 VARCHAR(30),col2 VARCHAR(30)) ### In R, I can connect to this table: library(DBI) library(RODBC) chan <- odbcConnect("MySQL51", uid="root", pwd="xxx") first <- sqlQuery(chan, "select * from example")

Hi, I would like to figure out how to determine what the id of the last element in a table is. Is there an equivalent to the Table.find() method which will tell me the number of elements in a table? also, maybe more importantly, where are the available methods on tables documented? What i am trying to do is to increment the id and work through a table and check whether the id i am currently

for the following example dataset:- Category Variable 1 127 1 261 1 142 1 183 1 234 1 162 2 173 2 321 2 168 2 197 2 213 2 261 3 198 3 126 3 167 3 154 3 134 3 187 3 109 3 210 I have performed Anova on the measured variable (column#2) for the groups 1,2&3 (column#1). Now I want to randomize the values in C#2 and reperform the test, say, a hundred times. Please suggest a way for this

I am trying to do something right from Agile Web Dev with Rails book and it does not work. I must be missing something obvious. I have a one-to-many relationship: class Draft < ActiveRecord::Base has_many :endorsees end class Endorsees < ActiveRecord:: Base belongs_to :draft end >From my reading, methinks I should be able to say: d = Draft.new d.endorsees << Endorsee.new

Hi. I''m having a problem with my testing. The following table in my development database (MySQL 4.1.12, InnoDB): +-----------------------+------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+------------------------+------+-----+---------+----------------+ |

Having issue updating a model with JSON. I simply *"model.attributes=json"*, which does update the attributes but not the id, or uuid in this case. I want to save or create the record (if it''s id exists). Seems like this would be documented, but I''m not finding anything. I''m using a MOM to pass JSON between apps. Thanks. -- You received this message because

Hi. I am developing an industry specific crm that allows busineses to track customers in a particular way. Each customer will be assigned a customer number. The first customer will have a customer number of 1, the second customer_number = 2, etc... Note that this customer number is not global but particular to the account that created the customer (see schema snip below). I need to have a

Dear R-listers, I want to reperfrom a poisson distribution test that presented in a recent-published biological research paper (Plant Physiology 2008, vol 148, pp. 1189-1200). That test is about the occurrence number of a kind of gene in separate chromosomes. For instance: The observed gene number in chromosome A is 36. The expected gene number in chromosome A is 30. Then, the authors got a

Is there a way to assign a CSS style to an element I am not currently interacting with? For instance, if I have two TD elements of a table. I click on one of them, and I want to have a style change in the other element. Is this possible? I''m guessing script.aculo.us might be able to help me.... but considering how nothing on their site is loading for me right now I have no way of

Hi, I''ve used .save to save the attributes, but on my table there is an autoincrementing id (not the primary key) that doesn''t need to be inserted... but save try to INSERT it anyway... is there a way to avoid save from acting this way or to whisper him to be more polite this time? ;) Thanks, Enrico -- "The only thing necessary for the triumph of evil is for good men to do

I am getting an error that I can''t figure out. I have a class called Test with 3 fields, id, x, and y. When I do Test.new(''x''=>1, ''y''=>2).save, I get an error saying that id (my ''not null primary key'') can''t be null. But isn''t active record supposed to deal with setting that for me? Here''s the code

the compiler tell me it: invalid column name: INSERT INTO ago.prova_stats (cognome, nome, id, telefono) VALUES(''Medda'', ''Ivan'', :id, 70565611) where ago.prova_stats is the table used by me and that have only the columns ''cognome'',''nome'' and ''telefono''. My table hasn''t the column

Just wandering if anyone can tell me how to format date when writing test data to upload to the db via a migration. ie, to match the date migration column format thanks -- Posted via http://www.ruby-forum.com/.

I am attempting to redirect to the show method after creating a new object. So, for example, once a new post is created the user is presented with the new post in a show view. The problem is I can''t get the correct <at> post.id to send to the show method. Rails always returns 0 for this value. Here''s what I have so far: class ContentController < ApplicationController

I have a script that I am using to populate a database from a CSV file: RAILS_ENV = ''development'' require File.dirname(__FILE__) + ''/../../config/environment'' require ''csv'' # Destroy existing data Residence.destroy_all # IMPORT DATA FROM apartments.csv db_file = "#{RAILS_ROOT}/db/apartments.csv" CSV.open(db_file, "r",

I've attached a 2 examples of patterns for updating an array. They're simplified examples of some code generation I'm doing where I need to pass a large, unknown number of arguments (ints, doubles, pointers to other information) to a function. The two patterns are: Stack[0] = 0; Stack[1] = 1; Stack[2] = 42; And Int I = 0;

Hi I need to push newly created item id to file. (ie. its autoincrement value) I tried this on controller but it wont work, it cant find id value for the newly created item. def create @imitem = Imitem.new(params[:imitem]) system "echo \"@imitem.id\" > /tmp/myid" any help ? --~--~---------~--~----~------------~-------~--~----~ You received this message because you

I have two tables like: Table A: id (autoincrement) name Table B id id_of_A desc I want to add a record to table A and based on the id of A, I want to add a record to table B. I don''t think there is any SQL command that support this (at least in MySQL 4.1, so I use LAST_INSERT_ID()). (Is there any other way? or MySQL 5 support any special SQL command?) But I need

Here''s a gedanken experiment for those w/ far more knowledge than I about ActiveRecord, etc.: Let''s say my database is very remote and on a very slow machine. Let''s further say that my app has an action that leads to a very simple insert into the "impressions" table of the db, a la "INSERT INTO impressions(docid) VALUES($docid);" - and

There is a table: execute (<<-SQL) CREATE TABLE "tasks" ( "id" serial primary key, "number" serial, "version" integer DEFAULT 0 NOT NULL, "latest_version" boolean DEFAULT ''t'' NOT NULL, "hidden" boolean DEFAULT ''f'' NOT NULL, "type" character varying (1) NOT