search for: column_default

...ersion 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.COLUMNS WHERE TABLE_NAME =...

...t;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.COLUMNS WHERE TABLE_NAME = ...

I still want to get this into Rails for all connection adaptors, but for now I''ve hacked my own addition on for just PostgreSQL. The following code extends every Column object returned by MyModel.columns to support a new #required? method, which indicates if the column may or may not be null. The following is a huge hack - suggestions on a cleaner way to add this functionality

...he following error: DBI::DatabaseError: Execute OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction mode. HRESULT error code:0x80020009 Exception occurred.: SELECT COLUMN_NAME as ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, COL_LENGTH(''S_RESIT I''ve tried using transactions in rails but to no avail, if I have 10 windows open and refresh all at once, several windows will produce that error. MS suggests (http://support.microsoft.com/default.aspx?scid=kb%3Ben-...

I am unable to get ActiveRecord session support to work under 2.x against a SQL Server database. I''m starting to wonder if anyone is running 2.x against SQL Server? Is anyone running under the following configuration: Rails 2.x SQL Server 2000 DB (using AR adapter in ODBC mode) AR store for ActionController session store. I''d like to chat with you if you are. Thanks, Wes --

...ts ---------------------------- 2005-03-03 09:53:54.290717 2005-03-03 09:53:54.290717 2005-03-03 09:53:54.290717 2005-03-03 09:53:54.290717 (4 rows) it looks like (from only reading the code) that table_structure will map the default values of each field in column_defaults.collect do |row| field = row[0] type = type_as_string(row[3], row[2]) default = default_value(row[1]) length = row[2] [field, type, default, length] end so, each time default_value sees ''now'' it will call Time::now.to_s -...