[R] R -SQL

[Gesmann, Markus]

Your code looks more like Visual Basic rather than R.
What you want is:

for(j in 1:length(criteria$Title)){

sqlstring <- paste("select q.type,crit.Title, r.Value from criteria crit, reply r,question_reply qr, question q, question_criteria qc, form_question fq where qr.reply=r.ID and qr.question=q.ID and qc.question=q.ID and crit.ID=qc.criteria and fq.question=q.ID and fq.form=4 and crit.Title='", criteria$Title[j], "';", sep="")

graphe_par<-sqlQuery(channel,sqlstring)

}

See ?paste

Regards

Markus

Your SQL statement seems to be wrong. 

-----Original Message-----
From: r-help-bounces at stat.math.ethz.ch [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Navarre Sabine
Sent: 18 May 2005 13:03
To: r-help at stat.math.ethz.ch
Subject: [R] R -SQL


Hello,
 
I've got a problem in a sql query!


for(j in 1:length(criteria$Title))

{
    graphe_par<-sqlQuery(channel,"select q.type,crit.Title, r.Value from criteria crit, reply r,question_reply qr, question q, question_criteria qc, form_question fq where qr.reply=r.ID and qr.question=q.ID and qc.question=q.ID and crit.ID=qc.criteria and fq.question=q.ID and fq.form=4 and crit.Title=" & criteria$Title[j] &";")

............}


> criteria$Title
[1] Content           Logistic          Trainer           Supply            User contribution
Levels: Content Logistic Supply Trainer User contribution


The error is:
Error in "select q.type,crit.Title, r.Value from criteria crit, reply r,question_reply qr, question q, question_criteria qc, form_question fq where qr.reply=r.ID and qr.question=q.ID and qc.question=q.ID and crit.ID=qc.criteria and fq.question=q.ID and fq.form=4 and crit.Title=" &  : 
        operations are possible only for numeric or logical types
In addition: Warning message:
& not meaningful for factors in: Ops.factor("select q.type,crit.Title, r.Value from criteria crit, reply r,question_reply qr, question q, question_criteria qc, form_question fq where qr.reply=r.ID and qr.question=q.ID and qc.question=q.ID and crit.ID=qc.criteria and fq.question=q.ID and fq.form=4 and crit.Title=", 

please help me,

Thanks a lot!

Sabine


		
---------------------------------

ils, photos et vidéos !

	[[alternative HTML version deleted]]

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html





************LNSCNTMCS01***************************************************
The information in this E-Mail and in any attachments is CON...{{dropped}}