search for: smallint

...E, rownames=FALSE, verbose = FALSE, test = FALSE, nastring = -999999, fast = FALSE) This is giving me an error: Error in sqlSave(channel, temp6, tablename = "series_indices_test", append = TRUE, : unable to append to table %sseries_indices_test My table definition is: ind_id smallint(3) ser_id smallint(4) period_id tinyint(2) year smallint(4) calc mediumint(6) mean mediumint(6) This error is related to the underscores I use in the table. Because, when I change the table definition to (removing underscores): indid smallint(3) serid smallint(4) periodid tinyint(2) year smalli...

...domain` varchar(255) NOT NULL DEFAULT '', `uidnumber` int(6) NOT NULL DEFAULT '1000', `gidnumber` int(6) NOT NULL DEFAULT '1000', `createdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `expiredate` date NOT NULL DEFAULT '0000-00-00', `active` smallint(1) NOT NULL DEFAULT '1', `disablepwdchange` smallint(1) DEFAULT NULL, `disablesmtpd` smallint(1) DEFAULT NULL, `disablesmtp` smallint(1) DEFAULT NULL, `disablewebmail` smallint(1) DEFAULT NULL, `disablenetdisk` smallint(1) DEFAULT NULL, `disableimap` smallint(1) DEFAULT NULL,...

...d nor does my iax peers/users table have any problems either. Below is how I set up my queues_table and queue_member_table: CREATE TABLE queue_table ( name VARCHAR(128) NOT NULL PRIMARY KEY, musiconhold VARCHAR(128), announce VARCHAR(128), context VARCHAR(128), timeout NUMERIC(11,0), monitor_join SMALLINT, monitor_format VARCHAR(128), queue_youarenext VARCHAR(128), queue_thereare VARCHAR(128), queue_callswaiting VARCHAR(128), queue_holdtime VARCHAR(128), queue_minutes VARCHAR(128), queue_seconds VARCHAR(128), queue_lessthan VARCHAR(128), queue_thankyou VARCHAR(128), queue_reporthold VARCHAR(128), an...

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 `find_by_fOpen'' for Bug:Class But when I try @bugs = Bug.find(:all, :conditions => ["fOpen = ?", 1]), I get the expected find results. Any ideas? Thanks, Eden -------------- ne...

...s it so that booleans are escaped as booleans, not integers. Specifically, this situation will now work find_all(["send_date=? and sent=?", Date.today, false]) Which matches peoples expectations, but it causes some problems with the postgresql unit tests. Specifically, the use of smallint as a boolean approved smallint DEFAULT 1, This means the adapter tries to compare ''t'' and an integer, which psql barfs on. Now it''s probably a few lines to fix our unit tests, but we may be breaking other peoples applications. What are people''s thoughts...

...I'd like to encode from a 22050 Hz source wav file (only in that case), but i get the following error message: "Invalid floating point operation" I use delphi: vorbis_encode_init_vbr(vi,2,22050,0.5) . . . While (i < readCount div 4) Do Begin buffer[0][i] := smallInt((pArray(@readbuffer)[i shl 2 + 1] shl 8) or pArray(@readbuffer)[i shl 2 + 0]) / 32768; buffer[1][i] := smallInt((pArray(@readbuffer)[i shl 2 + 3] shl 8) or pArray(@readbuffer)[i shl 2 + 2]) / 32768; inc(i); End What could be wrong??? Thank you! crc ---------...

I''m new to RoR and trying to make a HABTM relationship work. I have no problems with displaying the fields (after I pumped the data into MySQL manually outside of RoR), but when I try to edit a record, it =does= save the changes in the primary record, but =not= the join table. When I look in the development log, I see the update to the main table, but nothing about the join

I am using a smallint database column to store several boolean flags. The flags are accessible thru facade column accessors. I''d like to hide the database column so all access is thru the facade accessors. How do I do it? TIA, Jeffrey

Hi, im new to RoR so sorry if the questions sounds stupid to you. Im trying to build a tool for a browsergame. The game allows access to its database and the db looks like this: table villages: `id` int(9) unsigned NOT NULL default ''0'', `x` smallint(3) NOT NULL default ''0'', `y` smallint(3) NOT NULL default ''0'', `tid` tinyint(1) unsigned NOT NULL default ''0'', `vid` int(9) unsigned NOT NULL default ''0'', `village` varchar(20) NOT NULL default '''', `...

...you can help me. I use a Delphi conversion (from Aleksandr Shamray), but it doesn't work when I'd like to convert a *.RAW into a mono *.ogg file. vorbis_encode_init_vbr(vi, 1, 44100, 0.5); //because of the mono the program stops at line: //* uninterleave samples */ . . buffer[1][i] := smallInt((pArray(@readbuffer)[i shl 2 + 3] shl 8) or pArray(@readbuffer)[i shl 2 + 2]) / 32768; . . Why????? Please, help me! Thank You! <p>--------------------------------- Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online --- >8 ---- List archives: http://www.xiph.org/a...

I have not been able to get DB migrations to work at all in Rails 1.0 for me. On multiple platforms I continually get the same errors. It took me awhile to figure out some initial things, such as Migrations don''t seem to support Enum column types, and doesn''t really support Foreign key relationships (the constraints at least). After changing my DB schema to jive more with the

...you will change the entry field to be a select that picks from "1" to "5" but the validation will continue to fail for this field.  Rails will continue to give you an error saying that the priority should be between 1 (High) and 5 (Low).  After you change this field to being a SmallInt (use phpMyAdmin or something similar for this), it will work as if there were no problems at all.  The scaffolded code will work just fine at this point. The same problem affects one of the checks in the listing of the items.  The tick mark (indicating done) will not appear because the code expect...

...rows affected (0.02 sec) mysql> CREATE TABLE users ( -> id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, -> login VARCHAR(255) NOT NULL UNIQUE, -> name VARCHAR(255) NOT NULL, -> password CHAR(13) NOT NULL, -> uid SMALLINT NOT NULL DEFAULT 2000, -> gid SMALLINT NOT NULL DEFAULT 2000, -> home VARCHAR(255) NOT NULL DEFAULT '/var/vmail', -> maildir VARCHAR(255) NOT NULL, -> quota VARCHAR(10) NOT NULL DEFAULT '10000000S'); Query OK, 0 r...

...but gives me the below error on Linux CentOS 4.3. Any ideas? Thanks, Chirag class CreateUsers < ActiveRecord::Migration def self.up create_table :uers do |t| t.column :timestamp, :timestamp_with_time_zone t.column :userval, :integer, :limit => 1, :null=> false #will use smallint becuase of plug-in end end def self.down drop_table :users end end == CreateUsers: migrating ================================================ -- create_table(:users) rake aborted! RuntimeError: ERROR C42601 Mmultiple default values specified for column "id" of table...

...`secret` varchar(80) default NULL, `setvar` varchar(100) default NULL, `disallow` varchar(100) default 'all', `allow` varchar(100) default 'g729;ilbc;gsm;ulaw;alaw', `fullcontact` varchar(80) NOT NULL default '', `ipaddr` varchar(15) NOT NULL default '', `port` smallint(5) unsigned NOT NULL default '0', `regserver` varchar(100) default NULL, `regseconds` int(11) NOT NULL default '0', `username` varchar(80) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `name_2` (`name`) ) TYPE=MyISAM ROW_FORMAT=DYNAMIC;

...rsion) ) WITHOUT OIDS; CREATE TABLE licensed ( name character varying(30) NOT NULL, version character varying(10) NOT NULL, publisher character varying(15) NOT NULL, serial character varying(25) NOT NULL, lm boolean NOT NULL, license_file text, licenses integer NOT NULL, num_disks smallint NOT NULL DEFAULT 1, CONSTRAINT licensed_pkey PRIMARY KEY (name, version, publisher) ) WITHOUT OIDS; I have no trouble with the scaffolding for sites, computers, and technicians but it throws up on the others. Please forgive me if this is obvious. This is my first time trying to use rails. Any...

Hi, Everything is in the title. With Rails 2.3.4 and MySQL 5.0.41: If have a table like this: +----------------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL |

Hi, Anyone got any cool tricks for converting a Rails site (in this case, a typo installation) from a mysql database to a postgresql database? I''ve got it almost working -- I''m doing a SQL dump from mysql and loading it into postgres. However, mysql does booleans as a tinyint with 0 = false and 1 = true. When I try to import that into a postgres database that expects booleans

...O | PRI | NULL | auto_increment | | domain_id | int(11) | NO | MUL | NULL | | | user | varchar(40) | NO | MUL | NULL | | | password | varchar(128) | NO | | NULL | | | uid | smallint(5) unsigned | NO | | 999 | | | gid | smallint(5) unsigned | NO | | 999 | | | quota | bigint(20) | NO | | 0 | | | active | tinyint(1) | NO | | 1 | | | allow_i...

...(@encbits); speex_encode(encstate,@buffenc[0],@encbits); sz := speex_bits_nbytes(@encbits); SetLength(buffBytes,sz); speex_bits_write(@encbits,@buffBytes[0],sz); setlength(s3,length(buffbytes)); CopyMemory(@s3[1],@buffbytes[0],length(buffbytes)); Decode: d:array of smallint; speex_bits_read_from(@decbits,@s3[1],length(s3)); speex_decode(decstate,@decbits,@buffdec[0]); setlength(d,length(buffdec)); for j:=0 to length(buffdec)-1 do d[j]:=Round(buffdec[j]); I hope you will help me. Regards, Paul P.S. May be you have links to sites with exam...