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