Re: Column names with spaces
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