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