Re: [R] R -SQL

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Wed 18 May 2005 - 22:37:21 EST

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@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

______________________________________________
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:45:00 2005

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