search for: dbtable

...sing which data types are being used, I simply query the database and grab the data types (this will work even if the database has columns but is empty), then use this information when populating. In short, I do the following: library(RODBC) dbCon <- odbcConnect(db) tmp <- sqlColumns(dbCon, dbTable) ## this function grabs a bunch of info about the columns) varTypes <- as.character(tmp$TYPE_NAME) names(varTypes) <- as.character(tmp$COLUMN_NAME) sqlSave(dbCon, dataSet, dbTable, append=TRUE, rownames=FALSE, varTypes=varTypes) The "secret ingredient" here is varTypes : this is a...

...) } .mmstructBASE <- setClass("mmstructBASE", representation("VIRTUAL", dbName = "character", dbTable = "character"), prototype(dbName = character(), dbTable = character() ) ) .mmstructDB <- setClass("mmstructDB",...

...GoTalk.php) exten => 111,n,NoOp(Result is : ${callnum}) exten => 111,n,HangUp() My php file is: #!/usr/bin/php <?php $start = '5'; $mysql_host = 'localhost'; $mysql_user = 'username'; $mysql_password = 'password'; $my_database = 'asteriskcdr'; $dbtable = 'cdr'; $from_date = '20091205000000'; $to_date = '20100104235959'; $callnum = '0'; $minutes = '0'; $query_duration = "SELECT SUM(billsec) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AN...

I''m running a benchmark to check database performance. I don''t quite understand the results. The benchmarking code looks like this class DBTable < ActiveRecord::Base ActiveRecord::Base.establish_connection( :adapter => "mysql", :socket => "/var/lib/mysql/mysql.sock", :username => "..user..", :password => "..pwd..", :database => "..db.....

Dear R Experts, I have written a following function :- myfunction<- function(servername,dbname,dbtablename){ library(RODBC) channel <- odbcDriverConnect("driver=SQL Server;server=servername") initdata<- sqlQuery(channel,paste("select * from dbname .. dbtablename")) return(dim(initdata)) } I have written this function which has input parameters like servername ,dbname and...

Hi everybody, How can we add new contexts in asterisk realtime module? All I could figure out after googling is that a new context HAS to be declared in extensions.conf with 'switch => Realtime/@<databasetable>' under the context name declaration. This works fine as long as we are adding extensions only to this one context, but doesn't give the freedom to add new contexts for

Hi, Just get started with Rails and I''m trying to read ahead and find out whether Active Record supports auto-creation of database tables for you? Is this supported, or is the concept that you write your own database DDL to do this? Thanks -- Posted via http://www.ruby-forum.com/.

I've had 50+ people download the web components, and other than reports of compile issues, I have not heard if this collection has worked for anyone. I do plan to keep updating the * applications and the web pages, but I have almost meet all of our internal requirements and wonder if anyone else is finding it usefull. My focus has been and will likely stay on the user interface, since I have

...ndex for each important variable). I assume this is faster and more efficient than programming something on my own - why reinventing the wheel? For this I would use VIRTUAL classes like: .mmstructBASE <- setClass('mmstructBASE', representation( dbName = "character", dbTable = "character")) .mmstructDB <- setClass('mmstructDB', representation( conn = "SQLiteConnection"), contains = c("mmstructBASE")) .mmstruct <- setClass('mmstruct', representation( name = "character", index = "arr...

Hi all... I am a new bie of ruby rails. i was working with some task to get a database table to be exported in to an XMLFile. I need to write a raketask for that. Can some one please help me with some good stuff having with you regarding the rake task file written to do that dbtable to xml file file conversions. Please help me with some sample code or links Thanks to all in advance -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk...

Hola Javier, si no estoy entendiendo mal, lo q deseo hacer no se trata de configurar los parametros SQL, sino solo de colocar un vector en el argumento VarTypes de la funcion sqlSave. El manual especifica esa opcion, pero no da ningun ejemplo de como usarla. *varTypes an optional named character vector giving the DBMSs datatypes to be used for* *some (or all) of the columns if a table is to be

I'm afraid I am at a loss. If the three files, app_cbmysql.c, app_meetme2.c and Makefile all exist in ../apps then a patch -p1 from the ../asterisk directory should work. The -p1 tells patch to ignore the first directory in the path to the file in the patch, -p2 ignores two directories. Another option is to just edit the apps-meetme-cbmysql.txt and split it into three patchs and apply