Displaying 20 results from an estimated 10000 matches similar to: "Using a variable for mysql/database Query"
2009 Aug 11
2
Slicing cra**y csv files
Hello,
For not too regular users of R, preparing the data is somehow a burden.
Comming from iMacro in FireFox I get a badly designed csv, which I need to
put into a daily R script.
The data looks like that (e.g.):
22 Results,"35 Results","39 Results","2 Results","7 Results","23
Results","42 Results","36 Results","22
2009 Sep 15
2
Subsetting matrix with values from vector
Hello,
I have a large matrix (data), in which there is a column offerid. The values
are numbers (lets say 1:5)
There is another vector (idnew), which contains some of the offerids and
many more (3:10).
I want a subset of the matrix wiith only those rows, which match the
criteria of the vector.
How can I make it work?
Thanks!
--
View this message in context:
2005 Feb 10
5
Annual cumulative sums from time series
Hello world,
I am actually transferring a course in data management for
students in biology, geography and agriculture
from statistica to R - it works
surprisingly well. If anyone is interested in my scratch/notepad
(in German language), please see
www.hydrology.uni-kiel.de/~schorsch/statistik/statistik_datenauswertung.pdf
(pages 40-52)
The dataset is:
2010 Mar 26
1
MySQL and RODBC - limitations
Hello,
By accident I fell over a problem, which just did not expected...
Via Windows ODBC (package RODBC) I download data from a MySQL 5.1 database.
The amount is so large that the working set memory is going up to around
400MB. Not too large, I think.
Anyhow, one column includes ten digit numbers. Somehow, not all of these
numbers are displayed correctly. At some point all numbers turn to
2009 May 06
2
rmysql query help
R HELP,
I am trying to use an R script to connect to a mysql database. I am
having a problem using a variable in the where clause that contains a
"space" in its value.
If I include the variable inside the quotes of the query - i think it is
searching for the name of the variable in the database and not the value
of the variable.
If I put it outside the quotes, then it complains
2007 Jan 08
2
Simple spectral analysis
Hello world,
I am actually trying to transfer a lecture from Statistica to
R and I ran into problems with spectral analysis, I think I
just don't get it 8-(
(The posting from "FFT, frequs, magnitudes, phases" from 2005
did not enlighten me)
As a starter for the students I have a 10year data set of air
temperature with daily values and I try to
get a periodogram where the annual
2002 Jun 12
1
Error: Failed to initialise locking database
Greetings!
After successfully setting up the printer using my RedHat Linux 7.2 (using command-line interface), and after installing my ethernet card (again, using command-line interface), I've tried to setup my linux server to share the printer with Windows-based machines.
I thought I pretty much did everything right, but when I type a "smbstatus", I get the following:
>Samba
2003 Jul 28
5
DVD Drive wont mount
Hi, I am having trouble using my dvd drive in KDE, as it wont mount, using dvd, cd, cdrw. all I get is the error message saying:
Could not mount device.
The reported error was:
cd9660: /dev/acd0: Invalid argument
Has anyone got a solution for this?
Thanks,
Brian
2012 Oct 13
1
Question about printing
Hello all,
is it possible to print from a linux box to a printer, shared on a
windows 7 box?
In Windows 7 the Administrator account is deactivated without a password
in default.
Have i to enable the account?
Have i to set a password?
Thanks
2012 Sep 14
1
Issues with routing IPv6 to KVM Guests
Hi People,
I have some issues with routing ipv6 to my kvm guests. I use a bridge
interface with bridge-utils like recommended in the most howtos.
Bridge conf: http://fpaste.org/hh9U/
ip -6 route show output: http://fpaste.org/c5Rd/
sysctl.conf: http://fpaste.org/oMjD/
Thanks for your help in advance. If you need more informations just let
me know.
David Hackl
2013 Nov 27
2
CLI speed tester for CentOS?
I'd like to run a CLI broadband speed tester on my CentOS server.
I downloaded "tespeed" from <http://sourceforge.net/projects/tespeed/>.
This ran fine under Fedora-19, but failed under CentOS
with the message "# reject large message",
although from a quick look at the source
it did not seem to be using a large test-file.
Does anyone know of an alternative CLI
2012 Oct 08
1
migrating from Centos 5.8 -> 6.3 LDAP Client Config
Hi,
I run a Centos 5.8 samba server which uses a separate LDAP centos 6.3
server for user and group authentication.
Now we migrate to a new centos 6.3 samba server and I'd like to know how
do 'ldapify' that new server the best way.
I'm a bit confused if I can use the same nss setup like on the current
old server or how and what to configure to go with SSSD?
May be someone can
2012 May 25
1
Installing CIFS on CentOS4
Hello,
I have a CentOS4 install and I am trying to mount a Windows Server 2008
folder. When I use this command:
mount -t cifs //10.1.1.17/Org/MR\ Ops/ test, it only mounts the Org folder.
When I try the same thing on a newer computer (Fedora 15), it mounts all
the way to MR Ops. So I am pretty sure that my cifs file needs to be
updated, but I am having a really hard time doing this. I updated
2014 Jan 22
2
migrate ext3 to ext4
Hi all,
I issued the commands on a single disk system:
with two partitions / is linux sda1 and /home is sda3
yum -y update
yum -y install e4fsprogs
reboot
umount /home
tune2fs -O extents,uninit_bg,dir_index /dev/sda3
e2fsck -yfDC0 /dev/sda3
That worked just fine.
I then had a different system that is software raid.
where / is linux and md0 and /home is md1
yum -y update
yum -y
2011 Jun 22
2
CUPS not rendering documents via Samba
Hi guys, any CUPS / Samba experts out there?
The CUPS printing guide is a horrendous maze of options. I've got
nearly there but I've got
one thing wrong and I don't know where to look.
I set up our two printers (HP K5400s) using the GUI printer tool. Both
print the test page just fine.
I set up the [printers] and [print$] shares and can browse to the
printers from Windows (XP for me)
2012 Jun 06
3
CentOS 5.8 Samba and Windows 7
Hi,
any one has successfully joined a Windows 7 workstation to a samba (3.0.33) domain on CentOS 5.8?
I am wondering if I need to install a newer version (from sernet by example) or if I can keep the old one and try harder...
Thx,
JD
2012 Jan 17
2
Theoretical Firewall Specs?
So, the more I look at various ways to lay out my infrastructure, the more I am thinking about specs for hardware.
Starting with firewalling.
How does one determine the specs for a firewall?
What I mean is:
1. motherboard/CPU - p4? Dual-Core? Intel i3, i5, i7?
2. RAM? 4gb? 8gb? More? 32gb?
3. Obviously GB Nics!
I am bring about 300gb of traffic a month right now and I expect that to
2012 Mar 09
2
iotop :: OSError: Netlink error: Invalid argument (22)
Hi! i have a problem with iotop :
root at alien: ~ # iotop
Traceback (most recent call last):
File "/usr/bin/iotop", line 16, in ?
main()
File "/usr/lib/python2.4/site-packages/iotop/ui.py", line 567, in main
main_loop()
File "/usr/lib/python2.4/site-packages/iotop/ui.py", line 557, in <lambda>
main_loop = lambda: run_iotop(options)
File
2011 Oct 20
4
Backup live system
Though I've worked with enterprise systems, I'm not familiar with FOOS
backup software. Which of those recommended would allow me to backup a
system while users are active on it? If it matters the system uses LVM.
I'd also like to be able to avoid needing the network if possible.
That is, I'd plug in a disk into a USB port and backup the system onto
that... again, while
2012 May 04
2
Problem with ethernet card: r8169.
Hi all.
I have two servers
2.6.18-308.4.1.el5PAE
CentOS release 5.7 (Final)
Both have two external gigabit network cards (installed Planet with
Realtek r8169 chipset).
lspci
04:00.0 Ethernet controller: Realtek Semiconductor Co., Ltd. RTL-8169
Gigabit Ethernet (rev 10)
04:01.0 Ethernet controller: Realtek Semiconductor Co., Ltd. RTL-8169
Gigabit Ethernet (rev 10)
/var/log/messages
May 3