Mark Van De Vyver wrote: > My apologies, > > I'm using R v2.2.1 via the JGR Editor GUI, RMySQL v0.5.7 under windows > XP with latest patches. > > MySQL is "server version: 4.1.12" > I'm pretty sure it's running on a linux box.
It turns out that this may be a MySQL limit: http://bugs.mysql.com/bug.php?id=4117 > > The dimension of template is >2000, I know the error kicks in at 3000, > but haven't iterated to find the exact point - if it would help I can > do this. > > Regards > Mark > > On 3/24/06, David James <[EMAIL PROTECTED]> wrote: >> Hi, >> >> Mark Van De Vyver wrote: >>> Dear R-users, >>> First, thank you to the developers for the very useful R-library RMySQL. >>> >>> While using this library a recieved an error message: >>> >>> RS-DBI driver: (could not run statement: Too many columns) >>> >>> The statement that generated the error was: >>> >>> dbWriteTable(dbcon, "simdataseries", template, overwrite = TRUE, >>> row.names = FALSE ) >>> >>> I am assuming this is a RMySQL rather than MySQL limit. >> We need more information, e.g., what's dim(template), what version >> of MySQL you're using, etc. >> >>> If that is the case I was wondering just what this limit is and if it >>> is possible to raise it? >>> >>> Thanks again for all the hard work. >>> >>> Sincerely >>> Mark >>> >>> -- >>> Mark Van De Vyver, PhD >>> -------------------------------------------------- >>> My research is available from my SSRN Author page: >>> http://ssrn.com/author=36577 >>> -------------------------------------------------- >>> Finance Discipline >>> School of Business >>> The University of Sydney >>> Sydney NSW 2006 >>> Australia >>> >>> Telephone: +61 2 9351-6452 >>> Fax: +61 2 9351-6461 >>> >>> >>> -- >>> Mark Van De Vyver, PhD >>> -------------------------------------------------- >>> My research is available from my SSRN Author page: >>> http://ssrn.com/author=36577 >>> -------------------------------------------------- >>> Finance Discipline >>> School of Business >>> The University of Sydney >>> Sydney NSW 2006 >>> Australia >>> >>> Telephone: +61 2 9351-6452 >>> Fax: +61 2 9351-6461 >>> >>> ______________________________________________ >>> [email protected] mailing list >>> https://stat.ethz.ch/mailman/listinfo/r-help >>> PLEASE do read the posting guide! >>> http://www.R-project.org/posting-guide.html >> -- >> David >> > > > -- > Mark Van De Vyver, PhD > -------------------------------------------------- > My research is available from my SSRN Author page: > http://ssrn.com/author=36577 > -------------------------------------------------- > Finance Discipline > School of Business > The University of Sydney > Sydney NSW 2006 > Australia > > Telephone: +61 2 9351-6452 > Fax: +61 2 9351-6461 > > ______________________________________________ > [email protected] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html -- Jeffrey Horner Computer Systems Analyst School of Medicine 615-322-8606 Department of Biostatistics Vanderbilt University ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
