similar to: count sql failing with unknown table....

Hi group, I try to write a frame to a table (RODBC). I use colnames(temp6) <- c("ind_id","ser_id","period_id","year","calc","mean") sqlSave(channel, temp6, tablename = "series_indices_test",append= TRUE, rownames=FALSE, verbose = FALSE, test = FALSE, nastring = -999999, fast = FALSE) This is giving me an error: Error in

Hello List, i have been agonizing over this for days, any reply would be greatly appreciated! Situation:___________________________________ My original dataset is a .csv dataset (w/ 2M records) with 4 variables: job_id (Primary key, won't be used for analysis, just used for join tables), sector_id (categorical variable, for 19 industry sectors), sqft (con't variable for square

Hi. I''m having a problem with my testing. The following table in my development database (MySQL 4.1.12, InnoDB): +-----------------------+------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+------------------------+------+-----+---------+----------------+ |

Thanks for the input Blair Zajac and Chris (Nolan and Hall), and for others. If all of you have time, please follow this (the question still relates to the previous posts by me): I have provided full steps to reproduce the symptoms. If it matters, 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;

Hi all, I''m having a bit of a problem with unit testing. I''ve simplified my models to try and get my head round it but I''m still struggling. I''m using STI and trying to write tests for the extended models (code below). I''ve written test cases for the extended models which themselves extend the test case for the parent model, so BarTest extends

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 was

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).

Hello ferret users, I have a problem with ferret dropping stored fields in the index. Not all fields I want to store get stored, so they can be searched, but can''t be retrieved in a search. Index creation: INDEX = Index::Index.new(:path => ''/home/gregor/wisa/index'', :analyzer => Analysis::WhiteSpaceAnalyzer.new) SR =

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

Hi all, I started playing a couple days ago with Rails and it find it very interesting. But I''m a bit stuck with making it work with a concatenated primary key. I want to use my own names for the DB fields and I''m using SQL Server 2005. My tables look roughly like this: CREATE TABLE USERS ( USR_ID VARCHAR(25) NOT NULL PRIMARY KEY, USR_PASS VARCHAR(25) ) CREATE TABLE

Hi! For the following example I want to retrieve the last 10 LastEntries for experis_date >= now. class User < ActiveRecord::Base has_one :last_entries def self.last_entry_items find(:all, # :include => "last_entries", # :conditions => "last_entries.expires_date >= now()", :order => "id desc", :limit => 10) end end class

hey, i have this problem in the database i have 32 records and the sql filtered 4 records #getting the callerid records depending on the given paramaters and paginate it @callerid_pages = Paginator.new self, CallerId.count, 10, @params[''page''] @caller_ids = CallerId.find(:all, :conditions =>["geotags.firm_id = ? ", @firm_id], :order => " geotags.address1