Displaying 1 result from an estimated 1 matches for "orgashort".
2007 Jun 05
1
multiple plot in odfWeave
...te des projets:
<<carte2, echo = FALSE, results= verbatim, fig = TRUE>>=
lp <- dbSendQuery(con, "SELECT nom FROM projets")
projets <- fetch(lp)
nbr=dim(projets)[1]
for (i in 1:nbr)
{
monprojet=(projets)[i,1]
myquery=paste("SELECT s.longitude, s.latitude, o.orgashort FROM
organisme o JOIN scientist s ON o.codeorga=s.codeorga JOIN partenaire p
ON p.codescientist=s.codescientist JOIN projets ON
projets.codeproj=p.codeproj WHERE projets.nom LIKE \"",monprojet,"\"
ORDER BY s.longitude", sep="")
rs <- dbSendQuery(con, m...