similar to: sqlFetch (RODBC) question

Displaying 20 results from an estimated 300 matches similar to: "sqlFetch (RODBC) question"

2013 Apr 11
2
(no subject)
Dear all, Is there a quick and easy way of converting utf characters to the \uxxxx form (necessary e.g. for packages)? I mean something working like this: > utf2uxxxx("õäöü") [1] "\u00f5\u00e4\u00f6\u00fc" It is easy to program but perhaps someone already has implemented this. (I couldn't find anything useful from searches incl RSiteSearch). Thanks in advance, Kenn
2011 Mar 25
2
Preserving the class of POSIXt objects
Dear all, I am working with a list of objects each of which contains two POSIXct objects (say, $Start and $End) and a number of different data in addition to that. Now an easy way to extract Start times of all object could be sapply(x, "[", "Start") but this converts them all to numeric, and so does sapply(x, "[[", "Start"). lapply preserves the class but
2002 Dec 19
1
Re: Samba problems with Sco Openserver
----- Original Message ----- From: Adrian Stokes To: John H Terpstra Sent: Wednesday, December 18, 2002 1:43 PM Subject: Samba problems with Sco Openserver Hi John, I emailed that chap you suggested, just got an out of office reply. I think I'm halfway there though, I ran the following command #smbclient -U% -L localhost Added inetrface ip=192.168.x.x bcast=
2011 Mar 23
0
suggestions re trunc.POSIXt
Dear all, I hope this is a right place to post this; r-help might be appropriate but it looks like I'm suggesting a change in base package, so I decided to post here. (+ Apologies if that has been changed recently -- the version I'm using is R.2.12.2 on Windows.) I've noticed an unexpected behavior of trunc.POSIXt: foo <- seq(as.POSIXct( "2009-10-23 22:00:00"),
2013 Apr 11
0
Notes and warnings in building a package ('ms-dos style file name', 'no visible binding' and using .C("bincount", ..., PACKAGE = "base"))
Dear all, While buildign a package (R 2.15.2 on windows XP) I had three warnings/notes -- I would be grateful for any hints on what to do. 1. The first one is probably not really important if I'm not missing something: cygwin warning: MS-DOS style path detected: C:/x/y/z/package_1.0.tar.gz Preferred POSIX equivalent is: /cygdrive/c/x/y/z/package_1.0.tar.gz CYGWIN environment variable
2011 Mar 21
1
Curry with `[.function` ?
Dear all, I sometimes use the following function: Curry <- function(FUN,...) { # by Byron Ellis, https://stat.ethz.ch/pipermail/r-devel/2007-November/047318.html .orig <- list(...) function(...) do.call(FUN,c(.orig,list(...))) } ... and have thought it might be convenient to have a method for [ doing this. As a simple example, > apply(M, 1, mean[trim=0.1]) # hypothetical
2011 Apr 10
4
Password-protect R script files
There was a question in R forum very long time back.. on how to protect R Script files from inadvertent editing by users. There is a way to do this from within R, atleast in Windows XP I have tried this and it certainly works , The method is very different from the OS based folder protection route, however making available such a method in the open forum would only kill the very spirit of R.
2011 Jan 04
5
scoping/non-standard evaluation issue
Dear r-devel list members, On a couple of occasions I've encountered the issue illustrated by the following examples: --------- snip ----------- > mod.1 <- lm(Employed ~ GNP.deflator + GNP + Unemployed + + Armed.Forces + Population + Year, data=longley) > mod.2 <- update(mod.1, . ~ . - Year + Year) > all.equal(mod.1, mod.2) [1] TRUE > > f <-
2007 Oct 12
2
Q-type factor analysis
Hallo! Is there a package in R that does Q-type factor analysis? I know how to do principal component analysis, but haven't found any application of Q-type factor analysis. Thx, Julia -- Psssst! Schon vom neuen GMX MultiMessenger geh?rt? Der kanns mit allen: http://www.gmx.net/de/go/multimessenger
2008 Oct 01
0
Multiple histograms one graphic device & groupings
Hello, I am trying to produce some graphics to visualize my data. I think I want histograms. I have a grouping variable that has 48 different groups. I would like to produce a graphic that contains three of of these groups in the same device (they are time steps). I would like create graphics for about 6 different variables (6 variables X 16 groupings of there = 96 graphics). I am unsure of how
2011 May 04
4
Recursive objects
Hi all, Does anyone have a comprehensive list of recursive-type objects in R? is.recursive defines them as by exclusion: "most types of objects are regarded as recursive, except for vector types, ?NULL? and symbols (as given by ?as.name?)." I think this that means recursive objects are: * lists * pairlists * calls * expressions Did I miss anything? Hadley -- Assistant
2011 Jan 06
2
Global variables
Dear R-users, Is there a way I can prevent global variables to be visible within my functions? Sebastien
2009 Nov 28
1
'Are you sure?' custom dialog not exiting cleanly
The following program does not exit cleanly after pressing ''Yes'' when asked ''Are you sure''? How do I free up the resources after exiting? You can use wxsugar (xrcise) to try out this mini program if you wish to create sample1.rb . Thank you. -Philip =========== asample1.rb ==================================================== require ''wx''
2008 Apr 29
1
Consecutive zeros in a vector
Suppose X is a long vector of integers (typically about 30000 elements). Is there an efficient way to detect whether there are at least N consecutive zeros in X, and if yes, where does this occur? for example, suppose X is: 1 2 3 4 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 4 2 0 1 2 0 0 0 2 2 2 2 2 ... and N is 10. I would like a foo(X, 10) to return something like c(6,19) (start and end positions in X
2018 Mar 22
0
access is denied to the Windows share folder because of the ticket kerberos
The client can not access the Windows Share after authorization on samba DC samba_dc_server: samba 4.7.6 krb5-libs 1.15.2-7 windows client: windows7 windows_file_server: windows server 2008 /var/log/samba/mit_kdc.log мар 22 15:43:49 samba_dc_server krb5kdc[17891](info): commencing operation мар 22 15:43:56 samba_dc_server krb5kdc[17891](info): AS_REQ (6 etypes {18 17 23 24 -135 3}) 10.2.1.12:
2011 Feb 02
2
Help me apply mapply
Hello all I would like to ask your help use mapply. I have a function called findCell that takes two arguments(x,sr) where x is a vector of size two (e.g x<-c(2,3) and sr is a matrix. I would like to call many times the findCell function (thus I need mapply) for different x inputs but always for the same sr. as x is a vector of size two (two cells) I want to pass inside inside the following
2019 Nov 27
2
ELF string table access in backend
An HTML attachment was scrubbed... URL: <http://lists.llvm.org/pipermail/llvm-dev/attachments/20191127/dc214059/attachment-0001.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: 201911271044539_EW9BEWXX Type: application/octet-stream Size: 13168 bytes Desc: not available URL:
2011 Apr 08
5
Avoiding a loop
Friends. I cannot simplify this much, and I think the loop is unavoidable. As a recovering C programmer I want to avoid loops and in cases like this I almost allways can by using an apply function. But I suspect in this case there is nothing I can do. It is a finance example where a price series is compared to a moving average. If the price goes above the average, plus a bit, buy the
2011 Apr 23
4
random typing over text
Dear R, When I'm writing script I probably hit accidently some hot key and then the text in script is being overwritten by subsequent typing. Please what is the hot key or how can I disable it? -- View this message in context: http://r.789695.n4.nabble.com/random-typing-over-text-tp3470428p3470428.html Sent from the R help mailing list archive at Nabble.com.
2013 Apr 02
0
sqlFetch works but sqlQuery doesn't
I've been having some issues with sqlSave, and I think I've found an clue that may identify the problem. In the code at http://pastebin.com/W6UGKep9, I connect to a Netezza instance, make a simple table, and query it. Despite sqlSave succeeding without error, sqlQuery tells me that the table doesn't exist. Also, when I query the database outside of R, I see that the table doesn't