• 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: David Avendasora <email@hidden>
  • Date: Mon, 26 May 2008 07:58:37 -0400

Another thing to keep in mind, is that you will _need_ to use Wonder (at least ERExtensions) because MSSQL Server doesn't support deferred constraints, so you need to make sure that all inserts and deletes are done in the proper sequence, which is something that EOF does not do by default.

Chuck Hill also has a PlugIn for SQLServer (ERXMicrosoftPlugIn). It isn't included in the Wonder downloads, I'm not sure why, but I'm using it.

Dave

On May 26, 2008, at 7:21 AM, Hugi Þórðarson wrote:

Good morning folks.

I am working on a project where I need to talk to a legacy MSSQL2000 database - and almost all of the column names have spaces in them. Has anyone tried tackling that?

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).

Any ideas are appreciated.

Cheers,
- Hugi

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




_______________________________________________ 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



_______________________________________________ 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
References: 
 >Column names with spaces (From: Hugi Þórðarson <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: Navision model
  • Index(es):
    • Date
    • Thread