search for: column_name

...ATE TABLE schema_info (version int) 54 SQL:BatchCompleted select * from CREATE TABLE schema_info (version int) 54 SQL:BatchCompleted CREATE TABLE schema_info (version int) 54 SQL:BatchCompleted select * from CREATE TABLE schema_info (version int) 54 SQL:BatchCompleted SELECT COLUMN_NAME as ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, COL_LENGTH(''schema_info'', COLUMN_NAME) as Length, COLUMNPROPERTY(OBJECT_ID(''schema_info''), COLUMN_NAME, ''IsIdentity'') as IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA...

...;"XYZ789", "id"=>"", "description"=>"CIA flight...", "flightdate(1i)"=>"2005", "flightdate(2i)"=>"11", "flightdate(3i)"=>"24"}} [4;35;1mReport Columns (0.070000) SELECT COLUMN_NAME as ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, COL_LENGTH(''reports'', COLUMN_NAME) as Length, COLUMNPROPERTY(OBJECT_ID(''reports''), COLUMN_NAME, ''IsIdentity'') as IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COL...

...s error in the db/schema.rb file. ____________________________________________________ # Could not dump table "region" because of following ActiveRecord::StatementInvalid # OCIError: ORA-00918: column ambiguously defined: SELECT lower(i.index_name) as index_name, i.uniqueness, lowe r(c.column_name) as column_name FROM user_indexes i, user_ind_columns c WHERE i.table_name = ''REGION'' AND c.index_name = i.index_name AND i.index_name NOT IN (SELECT index_name FROM user_constraints WHERE constraint_type = ''P'&...

I have a class named Source and a controller named SourceController etc. When I use Source.column_names in the view all names except names ending in _id is listed, although according to the documentation all names should be listed When I use Source.column_names in the source controller it lists correctly all names also the ones ending in id. When I first call Source.column_names in the controlle...

How does one do a SELECT MAX query in rails? I''ve searched and searched and tried lots of things with no luck. I want to implement "SELECT MAX(column_name) from table_name and have it return the maximum value from column_name. I just need to get that one value, not the whole object... Thanks for any ideas... Shelby _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://li...

...: def set_blog_website faq = Faq.find(params[:id]) faq.blog_website = params[:value] faq.save! @faq = faq do_ret end Surely there is a generic way I can do this so that I can do something like def set_blog_website @faq = update_column(:blog_website) end def update_column(column_name) faq = Faq.find(params[:id]) faq.column_name = params[:value]<<-- here''s what I don''t know how to do! faq.save! @faq = faq do_ret end Any ideas on how I could set the attribute? Faq is an ActiveRecord::Base object. Thanks --~--~---------~--~----~------------~...

...ist.h | 40 +++++- cmds-subvolume.c | 57 +++----- man/btrfs.8.in | 19 +-- 4 files changed, 339 insertions(+), 195 deletions(-) diff --git a/btrfs-list.c b/btrfs-list.c index 1246a25..b0d8d13 100644 --- a/btrfs-list.c +++ b/btrfs-list.c @@ -50,62 +50,151 @@ struct { char *name; char *column_name; int need_print; + int width; } btrfs_list_columns[] = { { .name = "ID", .column_name = "ID", .need_print = 0, + .width = 6, }, { .name = "gen", .column_name = "Gen", .need_print = 0, + .width = 6, }, { .name = "c...

...ils was responsive again. If anybody else has this problem or if anybody wants to include the change into the next ActiveRecord version, here is what I''ve changed: in activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb at line 341 (in the #columns method): - select column_name, data_type, data_default, nullable, + select /*+ RULE */ column_name, data_type, data_default, nullable, Best regards and thanks for the great framework, Andreas Gungl

Hello everyone, I have another question related to a legacy schema I am working with. Do dynamic finders work with legacy schemas in general? The schema I am working with uses hungarian prefixes for column names. For example fOpen is 0 if a bug is closed and 1 if it is open (type smallint). When I try @bugs = Bug.find_all_by_fOpen(1), I get the following exception: undefined method

to wrap each instance variable of an ActiveRecord object between "<td>" and "</td>", is there a way to "loop through" them, at least in the debug mode, no matter there is getter methods to get them or not, or at least the ones with the getter methods? Such as <% @stories.each do |s| %> <%= "<tr>" %> <% s.each_property

...quot;, :force => true do |t| t.column "username", :string t.column "created_on", :datetime t.column "email", :string t.column "note", :text end And everything works fine, but in development, it has to run this query for each view select column_name, data_type, data_default, nullable, decode(data_type, ''NUMBER'', data_precision, ''VARCHAR2'', data_length, null) as length, decode(data_type, ''NUMBER'', data_scale, null) as scale from user_catalog cat, user_synonyms syn, all_tab_columns col...

...1 8.618 3.1 8.618 g49 2.4 6.672 2.4 6.672 g49 4.2 11.676 4.2 11.676 g49 2.5 6.95 2.5 6.95 g55 2.6 7.228 2.6 7.228 g55 3.4 9.452 3.4 9.452 g55 3.3 9.174 3.3 9.174 What I want to do is scale the data by each group So in pseudo-code for(group in groups){ if(column_name = regex(group_.*)){ data[column_name] = scale(data[group,column_name]) } } This way I get "group wise" normalization of my data, but still have the original values which I will normailze "database wide" for some comparisons. Can anybody help solve t...

...# # # # # # # v3 # # # # # # # v4 # # # # # # # v5 # # # # # # # v6 # # # # # # # I want to give the following column names to each data.frame: ("SDev", "PC1", "PC2", "PC3", "PC4", "PC5", "PC6") Works fine for one data.frame: column_names <- c("SDev", "PC1", "PC2", "PC3", "PC4", "PC5", "PC6") names( df1 ) <- column_names How is it to be done at once for all data.frames that the function objects(pattern = "SomePattern") can find? I've tried s...

I''d like my published boolean to be excluded from the calculation as to whether a version is created or not. Can anyone suggest a way to do that? Thanks, Walter -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To

...programming, schema designs, etc. Just select the columns and types (from a very limited list -- date, text, longtext). Of course in PHP I could just have the program create tables and keep another table of the lists that has each column in a particular list in a row (list_num, name_of_list, column_name, column_type). Another way to do it that doesn''t result in the end user having to create new tables is to have a table that has core columns for ALL lists (id, title, description) and then join that table to columns by type of data on the fly. So, select * from core_list_items where l...

Hi, I read the example in http://wiki.rubyonrails.com/rails/pages/HowtoUseMultipleDatabases, it show us how to connect to other database, each time we start a new action, however, this doesn''t work while you try to connect to two different database within the same action. SO I wonder is it possible to bind to two or more database within the same action???? Thanks you very much Saiho

Hello, In my database, I have a table "products" with attributes : - id - title ->string - desc -> text I use active record, but I don''t know why recover the type of this attribute with active record? I try attributes_before_type_cast but I don''t see the type Can you help me? Excuse for my english (I''am a young student french) -- Posted via

Hi, Sometime when I attach a dataset, R gives me the following message/warning:"The following object(s) are masked from package:datasets: column_name". Does anyone know what it means? Since it seems that the dataset was attached and I could manipulate the data from the dataset without problems, I am wondering what was R trying to tell me. Thanks, Tom [[alternative HTML version deleted]]

Hello There, As a new comer to RoR, I started to follow the article http://developer.apple.com/tools/developonrailsleopard.html. In short you create to entities and one one-to-many relation linking them. Everything was good until the establishment of the relation. I am unable to go any further than "Linking Models Together" : I can create the "vendors" mentionned in the

Hi! It''s rather ruby question than rails... I have a single ''list'' action where i call paginate method. I can receive none, 1 or 2 variables that specify conditions for paginate method. How to write the code so i can call paginate without conditions if all conditions variable are nil, with a single condition if one of conditions variables is not empty and with 2 if