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]]
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}}
You have not told us what package you are using (and I think this is a
repeat of a post also missing that crucial information).
However, the main problem appears to be that you think & operates on
character strings. You have not told us your intentions, which might have
been
paste("select ... crit.Title=", criteria$Title[j], ";",
sep="")
On Wed, 18 May 2005, Navarre Sabine wrote:
> 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=",
--
Brian D. Ripley, ripley at stats.ox.ac.uk
Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel: +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UK Fax: +44 1865 272595