[R] R -SQL

From: Navarre Sabine <navarre_sabine_at_yahoo.fr>
Date: Wed 18 May 2005 - 22:03:12 EST


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@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 Received on Wed May 18 22:08:00 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:31:50 EST