On Fri, 18 Aug 2006, Philippe Grosjean wrote: > You should put your SQL query in a variable, and use this variable in > your call. Something like: > > MyQuery <- "bla bla bla" > MyQuery <- paste(MyQuery, "more bla bla") > # .... > doMyRequest(MyQuery)
Indeed. For the record, R has an limit of 1024 chars on input lines (from way back) and it cannot be altered. > > Best, > > Philippe Grosjean > > > > Eric Fegraus wrote: > > Hello, > > > > > > I'm using R 2.3.1 on Windows. > > > > I'm generating some very long SQL statements. I do this by using > > paste() which will contain many strings and variables. I'm getting an > > error when the the total line length is longer than about 1013 > > characters. For example, it works with the line containing 1013 > > characters and not when it is 1059. > > > > I've looked into adjusting the options(width) and a handful of other > > settings. I have a feeling there is some other setting i'm missing > > that i can adjust. > > > > Any ideas? > > > > Thanks! > > > > ______________________________________________ > > 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 > > and provide commented, minimal, self-contained, reproducible code. > > > > > > ______________________________________________ > 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 > and provide commented, minimal, self-contained, reproducible code. > -- Brian D. Ripley, [EMAIL PROTECTED] 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 and provide commented, minimal, self-contained, reproducible code.