Displaying 3 results from an estimated 3 matches for "sqltablecreate".
2005 Feb 24
2
sqlSave reports invalid regular expression '[^[:alnum]_]+' (PR#7703)
...ot 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...
2000 Mar 08
0
RODBC: follow up
...12, "varchar", 255, 255, NA, NA, 1, NA))
creates a data.frame with "" as column names (except for "tablename" as
third column name)
I don't know whether this is a R bug or expected behaviour. However it
currently creates trouble as the later call of
query <- sqltablecreate(tablename, newname, keys = 0)
fails at
Browse[1]>
debug: if (coldata[i, 11] == 1) {
null <- "NULL"
} else {
null <- "NOT NULL"
}
Browse[1]>
Error in [.data.frame(coldata, i, 11) : undefined columns selected
because newname/coldata misses colnames
debug...
2005 Feb 24
0
sqlSave reports invalid regular expression '[^[:alnum]_]+' (PR#7704)
...ave(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-g...