Okay... I'll check in some code that puts double quotes around field and column names that contain a space. Let's see how well it works.
On Wed, Sep 9, 2009 at 11:54 AM, Naftoli Gugenheim <[email protected]>wrote: > > 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 > > > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
