For MS SQL, it's square brackets -- [table].[Company email] -Ross
On Sep 9, 2009, at 12:46 PM, David Pollak 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 > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
