Yes. Doens't work. Good news is that while next update of this "other" system names for columns will be changed for something more "standard".
Thank You all for help :) On Sep 9, 6:51 pm, Ross Mellgren <[email protected]> wrote: > 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 frameworkhttp://liftweb.net > > Beginning Scalahttp://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 -~----------~----~----~----~------~----~------~--~---
