search for: mediumint

...multiple sectors, see below for DDL. The query generated by sector.jobs.count seems a bit funny. I''m no MySQL expert but should there be more references to the join between jobs and jobs_sectors? Thanks for you time, Tim DDL as promised..... CREATE TABLE `jobs_sectors` ( `job_id` mediumint(9) NOT NULL default ''0'', `sector_id` mediumint(9) NOT NULL default ''0'' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `jobs` ( `id` int(10) unsigned NOT NULL auto_increment, `title` varchar(254) NOT NULL default '''', `description`...

...= 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 smallint(4) calc mediumint(6) mean mediumint(6) and execute colnames(temp6) <...

...+-----------------------+------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+------------------------+------+-----+---------+----------------+ | pupil_set_id | mediumint(10) unsigned | | MUL | 0 | | | pupil_id | mediumint(10) unsigned | | MUL | 0 | | | link_id | bigint(20) unsigned | | PRI | NULL | auto_increment | | external_pupil_id | int(11) | YES |...

I have the following a table and a fixture(csv file). create table aaaa ( id mediumint unsigned not null auto_increment, name varchar(192) not null, parent_id mediumint unsigned null, note varchar(192) not null, primary key(id) ) TYPE=InnoDB; id,name,parent_id,note 1,Admin Group,,"" 2,Guest Group,,"" I expected that null was inserted to parent_id, but 0...

...I''m running Ruby 1.8.2, Rails 1.0, and MySQL 5.0.15 on Windows XP Professional. 1. First, the setup MySQL ----- create database testdb; create table ranks (id tinyint unsigned not null auto_increment, description varchar(50) not null unique, primary key(id)); create table customers (id mediumint unsigned not null auto_increment, name varchar(50) not null, phone varchar(25), address varchar(50), rank_id tinyint unsigned not null, primary key(id), foreign key (rank_id) references ranks(id)); Leave the tables blank. This is intentional. Rails ----- > rails myapp > cd myapp > ruby s...

..._FILE__) + ''/foo_test'' 44 45 class BarTest < FooTest 46 47 def class_to_test 48 Bar 49 end 50 51 def test_say_hello 52 assert_equal "hello", class_to_test.new.say_hello 53 end 54 55 endsql:CREATE TABLE `foos` ( `id` mediumint(9) NOT NULL auto_increment, `type` varchar(255) default NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Dear Tariq; About elastix.org, this can be use with Asterisk or it is coming as a complete IP Telephony, Call Center, IVR and Reporting? Because, I do not need to install another IP Telephony on the server which already has asterisk which is an IP Telephony, this will cause a problem in the service (for example, when listening for SIP port of 5060).

Hi, ? I am trying to store queues.conf to a MySQL database using dynamic realtime. I have a working ODBC connection and the queueing system already works but I want to store the queues.conf file to a database. I am following the guide from Asterisk the definitive guide, the ebook can be found at: http://ofps.oreilly.com/titles/9781449332426/asterisk-DB.html ? I have a database called asterisk