Well that syntax most definitely does, at least from SQL management studio:
DECLARE @foo TABLE ( [my column] int NOT NULL ) INSERT @foo ([my column]) VALUES (1) SELECT * FROM @foo I guess you tried setting dbColumnName? Maybe something else was interfering. Good to hear though that you're moving to sane column names :-) -Ross On Sep 10, 2009, at 6:12 AM, Marcin Jurczuk wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
