• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Column names with spaces
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Column names with spaces


  • Subject: Re: Column names with spaces
  • From: Hugi Þórðarson <email@hidden>
  • Date: Mon, 26 May 2008 11:58:00 +0000

Well, I'll be... A butt ugly solution - and it works like a charm - thanks! :-D

- h

// Hugi Thordarson
// http://hugi.karlmenn.is/




On 26.5.2008, at 11:33, James Nugent wrote:

We have handled this issue in previous cases by creating DB-views on the tables with more intelligent column names, but that's a somewhat messy solution when dealing with a complex system. So - is there any way to force WO to quote the column names in generated SQL? (or perhaps escape the space in the column name).

I haven't tested this theory at all, but in SQL Server's SQL dialect you can surround a field name with square brackets to quote it - can you use that as your mapped column name in the EO Modeler?



James

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: Column names with spaces
      • From: James Nugent <email@hidden>
References: 
 >Column names with spaces (From: Hugi Þórðarson <email@hidden>)
 >Re: Column names with spaces (From: James Nugent <email@hidden>)

  • Prev by Date: Re: Column names with spaces
  • Next by Date: Re: Column names with spaces
  • Previous by thread: Re: Column names with spaces
  • Next by thread: Re: Column names with spaces
  • Index(es):
    • Date
    • Thread