search for: mytestdb

Displaying 5 results from an estimated 5 matches for "mytestdb".

2006 Jan 29
4
Problems with FireRuby and scaffolding
I am trying to generate some scaffolding using "ruby script/generate scaffold order order". It always fails with the message "uninitialized constant CHARACTER_SET". I have an orders table in a Firebird databse called TARPRILOGISTICS.GDB. The database is in a folder named "database" in my rails app root folder. I tried FireRuby 0.4 and 0.4.1. My config file looks
2012 Feb 02
9
sqldf for Very Large Tab Delimited Files
...getting first 10 records Here is the reproducible code that I am trying: # Text data file write.table(iris, "irisNoH.txt", sep = "\t", quote = FALSE, col.names=FALSE,row.names = FALSE) # create an empty database (can skip this step if database already exists) sqldf("attach myTestdbT as new") f1<-file("irisNoH.txt") attr(f1, "file.format") <- list(header=FALSE,sep="\t") # read into table called irisTab in the mytestdb sqlite database read.csv.sql("irisNoH.txt", sql = "create table main.irisTab1 as select * from file"...
2009 Jan 23
0
Appending objects created using filehash package
...o an object, basically requires rewriting the entire object. Sample code: ================================================= # Setting up the database library(filehash) A <- data.frame(a=c("abcde", "fghij", "klmno"), stringsAsFactors=FALSE) dumpDF( A, dbName="myTestDB") envTest <- db2env(db="myTestDB") ls(envTest) with(envTest, a) # Appending to object a, but basically rewriting it... envTest$a <- c(envTest$a, "HELLO", "GOODBYE") with(envTest, a) If anyone has a suggestion on how to append to an object without complete...
2006 Aug 18
1
join update seperation?
I have a legacy DB without access to change the user or group table (must use StoredProcedures to edit those). But I do have access to the usergroup join so I thought the joins would be pretty much like my other rails apps where I do HABTM checkboxes. I''ve created a page that just shows habtm checkboxes for the join and the updates are occuring for the join but I''m
2006 Apr 22
9
one to many question
1. A category has parent categories. 2. A product is in many categories and a category has many products. 3. Products and category both have images in the same image table. ie. a product and / or category could have multiple images.<=== my question is related to this So among other things I presume I have to do the following: class Category < ActiveRecord:Base #...