search for: orderid

...he computation of this function is painfully slow: in 1min only about 90 rows are calculated. The computation time taken for a given number of rows increases with the size of the dataset, see the example with my function below: # small dataset: function performs well exampledata<-data.frame(orderID=c(1,1,1,2,2,3,3,3,4),itemPrice=c(10,17,9,12,25,10,1,9,7)) exampledata[1,"orderAmount"]<-exampledata[1,"itemPrice"] system.time(for (i in 2:length(exampledata[,1])) {exampledata[i,"orderAmount"]<-ifelse(exampledata[i,"orderID"]==exampledata[i-1,"o...

Hello, I am trying to import data from an SQLite database to R. Unfortunately, I seem to get wrong data when I try to import very large numbers. For example: I look at the database via SQLiteStudio(v.1.1.3) and I see the following values: OrderID Day TimeToclose 1 2009-11-25 29467907000 2 2009-11-25 29467907000 3 2009-11-25 29467907000 Now I run this R Code: > library("DBI") > library("RSQLite") > > # DB Connection > con <- dbConnect(dbDriver("SQLite"), "C:/Temp/TickDB01.db&...

...in R, I am trying to to use paste function to concatenate strings which has been fetched from database table(postgres database), the following are my code: when i do: > sqlFetch(channel,'transactions') outputs are following(only parts, there are around 200 transactions in total) orderid productname price quantity discount 1 T10248 potato 1.80 10 0.00 2 T10248 sweets 2.00 5 0.00 3 T10249 milk 1.99 9 0.00 4 T10249 apple 2.35 40 0.00 when i do: > paste(sqlFetch(channel,'transactions')) outp...

...ewed up by only looking at adsi.conf, and not asterisk.adsi. Once I saw that, things started falling into place. Are you able to pass arguments to the phone so that for every call there is unique data on the screen. I see that works for caller id with $Call1p and $Call1s, but what If I obtain an OrderID from my customer. Can I display this somehow? John Begin forwarded message: > > yeah, > > Thank you. I screwed up by only looking at adsi.conf, and not > asterisk.adsi. > Once I saw that, things started falling into place. > > Are you able to pass arguments to the pho...

Actually I just remember LNT has a page for viewing the log: http://lnt.llvm.org/log ... OperationalError: (OperationalError) (2006, 'MySQL server has gone away') 'SELECT `NT_Run`.`ID` AS `NT_Run_ID`, `NT_Run`.`MachineID` AS `NT_Run_MachineID`, `NT_Run`.`OrderID` AS `NT_Run_OrderID`, `NT_Run`.`ImportedFrom` AS `NT_Run_ImportedFrom`, `NT_Run`.`StartTime` AS `NT_Run_StartTime`, `NT_Run`.`EndTime` AS `NT_Run_EndTime`, `NT_Run`.`SimpleRunID` AS `NT_Run_SimpleRunID`, `NT_Run`.`Parameters` AS `NT_Run_Parameters` \nFROM `NT_Run` \nWHERE `NT_Run`.`ID` = %s' (6...

Our phone operators work off of an Asterisk queue. They take calls from customers and take orders with our back end systems. What I need to be able to do is tie the orders taken to the specific CDR record that reflects the call from which the order originated. The typical/sample CDR table doesn't have a primary key. I can add an auto-generated PK, but the CDR is not written until the

...for viewing the log: > > > > http://lnt.llvm.org/log > > > > ... > > OperationalError: (OperationalError) (2006, 'MySQL server has gone away') > > 'SELECT `NT_Run`.`ID` AS `NT_Run_ID`, `NT_Run`.`MachineID` AS > > `NT_Run_MachineID`, `NT_Run`.`OrderID` AS `NT_Run_OrderID`, > > `NT_Run`.`ImportedFrom` AS `NT_Run_ImportedFrom`, `NT_Run`.`StartTime` AS > > `NT_Run_StartTime`, `NT_Run`.`EndTime` AS `NT_Run_EndTime`, > > `NT_Run`.`SimpleRunID` AS `NT_Run_SimpleRunID`, `NT_Run`.`Parameters` AS > > `NT_Run_Parameters` \nFROM `NT...

Chris is on vacation this week. Not sure if someone else has access to the logs... - Matthias > On Aug 2, 2017, at 12:45 PM, Tobias Grosser <tobias.grosser at inf.ethz.ch> wrote: > > OK, who is in charge? > > Best, > Tobias > > On Wed, Aug 2, 2017, at 21:45, Matthias Braun via llvm-dev wrote: >> >>> On Aug 2, 2017, at 12:43 PM, Tobias Grosser