A lot of dbs also support "double quoted" names. I think MS SQL can too (may be a setting). Is there for sure a db that supports spaces in names but not double-quoting them? If worst comes to worst you could delegate more things to the Driver (maybe makes sense anyway)...
But mapping a view to the table or view with spaces should definitely be a usable workaround. ------------------------------------- David Pollak<[email protected]> wrote: There appears to be no standard SQL for this. Is there a way to create a view in your database that maps from the spaced table to something more SQL standard? On Wed, Sep 9, 2009 at 9:51 AM, Xavi Ramirez <[email protected]> wrote: > > I believe it's something like this: > > select * from [table with spaces] > where [column spaces] = 18 > > > On Wed, Sep 9, 2009 at 12:46 PM, David > Pollak<[email protected]> wrote: > > > > > > On Wed, Sep 9, 2009 at 9:21 AM, Derek Chen-Becker <[email protected] > > > > wrote: > >> > >> I don't think that Mapper will handle that correctly unless the JDBC > >> drivers do some strange magic on the prepared statements. > > > > Yeah... that's an issue. What's the SQL syntax for accessing > tables/columns > > that have spaces in their names? I can update Mapper to do the right > thing. > > > >> > >> On Wed, Sep 9, 2009 at 5:34 AM, Marcin Jurczuk <[email protected]> > wrote: > >>> > >>> One solution I found is to create object with name without spaces and > >>> override dbColumnName. > >>> I don't know however (right now I don't have access to DB) does db > >>> driver will handle such column names.. > >>> > >>> > >>> On Sep 9, 10:23 am, Marcin Jurczuk <[email protected]> wrote: > >>> > Hello everybody, > >>> > > >>> > I have strange problem. We have legacy database (MS SQL) where some > of > >>> > colums contains spaces in their names like "Company email". There is > a > >>> > plan to create some web interface to this DB with lift framework. I > >>> > tryed initial setup but is there a way to create DataMapper schema > >>> > with columns with spaces ? > >>> > > >>> > object Company email extends ...doesn't work :( > >>> > > >>> > Can You suggest some solution ? > >>> > I can't change column name - there are another apps using this > >>> > database. > >>> > > >>> > Regards, > >>> > >> > >> > >> > > > > > > > > -- > > Lift, the simply functional web framework http://liftweb.net > > Beginning Scala http://www.apress.com/book/view/1430219890 > > Follow me: http://twitter.com/dpp > > Git some: http://github.com/dpp > > > > > > > > > > > -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 Follow me: http://twitter.com/dpp Git some: http://github.com/dpp --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---
