search for: column_name

Displaying 20 results from an estimated 121 matches for "column_name".

2006 Jan 19
3
problems with migrations in sql server
...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...
2005 Nov 24
1
Log question
...;"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...
2006 Jul 04
3
OCIError: ORA-00918: column ambiguously defined
...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'&...
2009 Mar 01
1
Strange behavior of Source.column_names
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...
2005 Dec 30
9
SELECT MAX
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...
2008 Feb 10
4
method from string?
...: 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 --~--~---------~--~----~------------~...
2013 Apr 11
0
[PATCH] Btrfs-progs: enhance 'btrfs subvolume list'
...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...
2006 Feb 07
5
OCI adapter slowdown on dictionary access
...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
2006 Jan 05
8
Repost - Do dynamic finders work with legacy schemas?
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
2010 May 13
6
to "loop through" the instance variables of ActiveRecord?
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
2006 Jan 11
8
Oracle and Rails seems really slow.... In development
...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...
2009 Jul 31
1
scale subsets of grouped data in data frame
...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...
2010 Mar 11
3
Define column names to a series of data.frames
...# # # # # # # 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...
2010 Sep 16
5
vestal_versions -- can I set it to ignore certain columns?
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
2006 Jul 08
9
How to handle dynamically columned tables in rails
...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...
2006 Jan 19
4
multiple database in the same actions?
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
2008 Mar 03
2
how can i know type of attribute with active record
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
2006 Oct 21
2
object(s) are masked from package - what does it mean?
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]]
2008 Mar 08
9
Newbie worries with "Developing Rails Applications on Max OSX Leopard"
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
2006 Mar 13
6
Specifying none/single/many conditions at the same time
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