similar to: Help with SQLsave

Displaying 12 results from an estimated 12 matches similar to: "Help with SQLsave"

2009 Oct 19
1
source and textConnection
Is this warning given on purpose? > myconn<-textConnection("print(11*11)") > source(myconn) [1] 121 Warning message: In source(myconn) : argument 'encoding = "native.enc"' will be ignored Could it be omitted, since the docs state that encoding is only use if the corresponding argument is a file name or url? -- Erich Neuwirth, University of Vienna
2004 Dec 31
1
Help With Configuration From Odbc
Hi. I can't figure this one out. Hope someone can help me. root@pbx:# cat /etc/odbc.ini [Asterisk] Description=PostgreSQL asterisk Driver=PostgreSQL Trace=No TraceFile=/tmp/odbc.log Database=asterisk ServerName=localhost UserName=XXXX Password=XXXX Port=5432 Protocol=7.4 ReadOnly=No RowVersioning=No ShowSystemTables=Yes ShowOidColumn=Yes FakeOidIndex=Yes ConnSettings=
2009 May 21
1
Error in importing table from SQL to R
Hi Friends, I am trying to import a table from SQL server to R(2.9.0), however i am getting errors while running the below codes. Can anyone identify and let me know where did i go wrong??? Thanks in anticipation :) library(RODBC) myconn <- odbcConnect("RDATABASE") myconn RODB Connection 6 Details: case=nochange DSN=RDATABASE Description=Database for R UID=Madana_Babu
2013 Apr 03
1
sqlSave writes, but only for sqlFetch
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/vTAKt4bL<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 the table doesn't exist. Also, when I query the database outside of R, I
2017 Dec 28
3
Help with dates
Hi all, I?m struggling to get the dates in proper format. I have dates as factors and is in the form 02/27/34( 34 means 1934). If I use as.Date with format %d%m%y it gets converted to 2034-02-27. I tried changing the origin in the as.Date command but nothing worked. Any help is appreciated. Thanks, Ramesh
2013 Nov 25
0
Fetching data from MySQL via odbcConnect - Error in as.POSIXlt.character(x, tz, ...) :
Hi! I am trying to retrieve data from a MySQL Database using RODBC with the commands odbcConnect and sqlFetch. There are different data files in the database and in some cases it works without any difficulties. Nevertheless I get an error with some data files. Since I'm not familiar with MySQL I hope to get some ideas here. My code looks as follows: myconn
2017 Dec 28
0
Help with dates
Your dates have an incomplete year information with 34. R assumes that 00-68 are 2000 to 2068 and 69 to 99 are 1969 to 1999. See ?strptime and the details for %y. You can either append ?19? to the start of your year variable to make it completely express the year or check if the date is in the future (assuming all dates should be in the past) and subtract 100 years from the date. > On Dec
2004 Jun 08
1
Meetme2
Hi!! I try to install meetme2....i follow instructions that i found in http://www.areski.net/asterisk-meetme/about.php?s=0 but, when i modify the "Asterisk/apps/Makefile" and i run the "make" command, I have this type of error: [root@obelix apps]# make cc -pipe -fPIC -DUSEMYSQLVM -c -o app_meetme2.o app_meetme2.c app_meetme2.c:31:22: libpq-fe.h: No such file or directory
2018 Mar 25
1
Medical risk package calculation RSI
Hi all, I'm using the medical risk package to determine the risk stratification Index based on the ICD9 codes. Although, I have been successful in using it, I'm unable to interpret the output. here is the sample code # Calculate RSI for each patient ("id") in dataframe cases <- data.frame(id=c(1,1,1,2,2,2,2,2), +
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
2002 Nov 05
3
Adding Printer
We are a very small company and moved from WinTel environment to Linux. Killed the WinTel file/print server and implemented SAMBA om Red Hat 7.2. I have some users that need to print to a RICOH Aficio 4106 printer. When I go through the sequence to add printer ...... it appears to install, but the people cannot print. Can anyone walk me through steps as I am novice...... and I do not want to go
2006 Apr 27
4
pdf render inline .... update ''main'' div
Hi, I want to keep the layout and just to a link_to_remote to update the=20 div id ''main'' Using this in the controller action send_file "public/pdf/my.pdf", :type =3D> ''application/pdf'', = :disposition=20 =3D> ''inline'', :stream =3D> false I get this. The raw pdf code sent replacing the main div with :