From ripley at stats.ox.ac.uk  Thu Feb 24 19:06:49 2005
From: ripley at stats.ox.ac.uk (Prof Brian Ripley)
Date: Thu Feb 24 19:07:00 2005
Subject: [Rd] sqlSave reports invalid regular expression '[^[:alnum]_]+'
	(PR#7703)
In-Reply-To: <20050224173753.7056BBA61@slim.kubism.ku.dk>
References: <20050224173753.7056BBA61@slim.kubism.ku.dk>
Message-ID: <Pine.LNX.4.61.0502241801440.14702@gannet.stats>

Do not use R-bugs for reports on compatibility of obselete versiond of 
packages with unreleased versions of R!

You did not give the RODBC version no.  The current version, 1.1-3, is 
compatible with R-devel.  1.1-2 was not (alongside a dozen or so CRAN 
packages).

The only bugs here are in the report.

On Thu, 24 Feb 2005 david.whiting@ncl.ac.uk wrote:

> Full_Name: David Whiting
> Version: 2.1.0 Under development (unstable)
> OS: linux
> Submission from: (NULL) (82.39.106.169)
>
>
> I have just upgraded from a previous version (2.0.0?) and found some of my code
> that used okay to run now gives an error. The function being called is
> sqlSave(). I am pretty sure (but not 100% certain) that the data frame I am
> trying to save has not changed. I am 100% sure that the ODBC connection
> information for MySQL has not changed and I have not updated MySQL.
>
>> sqlSave(lh, data, "survey")
> Error in gsub(pattern, replacement, x, ignore.case, extended, fixed) :
> 	invalid regular expression '[^[:alnum]_]+'
>> traceback()
> 4: gsub("[^[:alnum]_]+", "", colnames)
> 3: mangleColNames(names(colspecs))
> 2: sqltablecreate(tablename, colspecs = colspecs, keys = keys)
> 1: sqlSave(lh, data, "survey")
>
>> str(data)
> `data.frame':	192 obs. of  171 variables:
> [...]
> (I can send the whole structure if that will help)
>
>> version
>         _
> platform i686-pc-linux-gnu
> arch     i686
> os       linux-gnu
> system   i686, linux-gnu
> status   Under development (unstable)
> major    2
> minor    1.0
> year     2005
> month    02
> day      24
> language R
>>
>
> ______________________________________________
> R-devel@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
>
>

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


[Rd] sqlSave reports invalid regular expression '[^[:alnum]_]+' (PR#7703)
Prof Brian Ripley