similar to: Irregular Time Series: zoo & its: Pros & Cons

Hi, I just installed ROracle and RDBI. The connection to the database seems to work also. My problem is when I am selection rows that really exist in the database, it is returning nothing. Where should I look to see what could be my problem? Thank you very much, Mathieu > drv <- dbDriver("Oracle") > summary(drv, verbose=TRUE) <OraDriver:(6721)> Driver name:

Hi all!! I would like to know if anyone has experienced this behaviour with ROracle package. I'm attaching information to reproduce the issue. Bug maybe? Thank you very much for your attention. Ramon. ################################################################## ################################################################## oraExecStatement BUG : RS-DBI driver: (ORA-02005:

Dear R-users, I was able to make ROracle package to connect to the DB (Oracle91, 64bit, on Solaris). But after executing siple SQL query, "fetch" commaned gives me an empty dataframe. ### RORACLE INSTALATION PROCEDURE ### R CMD INSTALL --configure-args='--enable-extralibs' --enable-oracle32=no ~/tmp/ROracle_0.5-5.tar.gz #since we have 64bit Oracle9i instalation PROBLEM:

I''ve upgraded to Rails 1.1.2, and I''m trying to push this change through to our build server (Linux/Oracle) and we are getting some errors in the unit tests using Oracle. Looking at the data in the tests reveals a precision problem. Looking at the tables tells the whole story. My development database contains this table: SQL> describe dls_grids; Name

I am trying to use the Rails Recipe for sending emails with attachments. However, when I add an attachment, my body fails to render. The resulting email has the attachment, but is blank otherwise. In the book, it mentions that this is "broken" in rails 1.0 and to upgrade to a newer version or edge rails. Well, I am running on 1.1.2 and it''s still happening. When I look

Hi, Hopefully a quick example will illustrate what I''m trying to do. <table> <tr> <td>test</td> <td>test</td> </tr> <tr> <td>row 2</td> <td>row 2</td> </tr> <tr> <td>row 3</td> <td>row 3</td> </tr> </table> Using AJAX, I''d

Hi all, I curently have a big problem. One request (listed above) using context take up to 1000 more time than the on RAW or ext2 database. I have ran this request on a single IA32 machine with Redhat and dbf on ext2. The average reponse time is less than a sec. The same request on RAC 4 nodes cluster on RAW take the same average time. On ext2 idem. But on OCFS it took up to 15 sec randomly

Hi all, I curently have a big problem. One request (listed above) using context take up to 1000 more time than the on RAW or ext2 database. I have ran this request on a single IA32 machine with Redhat and dbf on ext2. The average reponse time is less than a sec. The same request on RAC 4 nodes cluster on RAW take the same average time. On ext2 idem. But on OCFS it took up to 15 sec randomly

I rememeber seeing an article about how to cope with legacy databases where the primary key is defined as VARCHAR2. I only want read-access to the data. Does anyone have a link to such an article? Or can give advice? -- Posted via http://www.ruby-forum.com/.

Full_Name: Michael Hecht Version: 1.7.1 OS: WinNT Submission from: (NULL) (193.158.76.205) I've got a problem with the RODBC library while trying to access to an MS-Excel file. The Excel file was originally exportet by a commercial software, so I cannot influence it. The problem is, that the names of the tables include spaces, e.g. "Scan 1","Scan 2" etc. If I use RODBC, I

I am having a problem getting Redmine to run with Oracle (11.2) backend. I get this error (below) because Oracle table names are limited to 30 characters. Does anyone around here know of a fix or workaround? I''m wondering if I can simple change the table name, or if that will break the application. When doing a db migrate to an Oracle db this creates the error below. I''m so

I tried creating a .xlsx file using odbcConnectExcel2007 and adding a worksheet with sqlSave. This seems to work, I am even able to query the worksheet, but when I try opening the file in Excel I get the following message: "Excel cannot open the file 'test.xlx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file

I wanted to share an article I recently wrote on my blog with all of you regarding using SQLite for your web-applications. The blog url is: http://rubyonrailsblog.com and the article is currently posted on the front-page. Your insights and feedback are appreciated and are always welcome. Also if you have a blog, please let me know and feel free to put a link to my blog up on your site. If you do,

I wanted to share an article I recently wrote on my blog with all of you regarding using SQLite for your web-applications. The blog url is: http://rubyonrailsblog.com and the article is currently posted on the front-page. The exact url is located at: http://rubyonrailsblog.com/articles/2006/04/13/consider-sqlite-for-your-web-applications-the-pros-cons-and-when-to-use-it Your insights and feedback

Relative newbie so would welcome comments re structure of a self-referential relationship I''ve got. It''s started off similar to the Person HABTM friends in the Rails recipes books (working fine), but I needed to turn the join table into a full-blown model as I wanted to add attributes to it. Few tricky bits dealing with the new :through structure and understanding how :scope

I have a basic question, being new to EXT3. What are the pros and cons of using an external journal? Also, for a Terabyte-sized system, what should I use as the external journal's size? is there a general rule-of-thumb to follow when choosing the external journal's size? I know these are very basic questions, if they have been already answered in some FAQ, please let me know. Any

I've read that certain operations performed on a matrix (e.g. ribind, cbind) are often much faster compared to operations performed on a data frame. Other then the "bind functions", what are the main operations that are significantly faster on a a matrix? I know that data frames allow for columnnames and rownames, and that each column in a data frame can have different data types.

R has very good GUI packages that I have used - R Commander RCmdr and Rattle rattle . Since I work on multiple packages with constraints of time, I almost always use the GUI rather go through the intricacies of command line . The log of these GUIs shows the relevant R command that was used, so you can actually learn the language also. I have written about the ease of learning R , if you begin

Dear all, I using R version 2.9.0 on Windows XP and want to insert data from a data frame in R into a oracle database via sqlUpdate with the package RODBC. My example is the following: TEST0<-data.frame(NR=c(1,2,600),NAME=c("JK","TR","AR"), DATUM=c("2009-01-01","2010-01-02","2010-06-09")) If I create the table in the database with

I have Samba running without a PDC and I have some questions about the advantages for implementing one with Samba vs. the problems and disadvantages. Perhaps some kind souls can help me determine whether I should do this or not. We have three offices connected by a Checkpoint VPN, plus people "on the road" using their SecureClient tool. We want everyone to be able to get to all the