Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Column names with spaces

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Column names with spaces

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

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


Follow-Ups:

Re: Column names with spaces
From: David Avendasora <email@hidden>
Re: Column names with spaces
From: James Nugent <email@hidden>


Prev by Date:
Re: WOLongResponesePage Problem

Next by Date:
Navision model

Previous by thread:
JSConfirmPanel Question or am I using the wrong thing?

Next by thread:
Re: Column names with spaces

Index(es):

Date
Thread