Lists

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: James Nugent <email@hidden>
Date: Mon, 26 May 2008 12:33:29 +0100

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: Hugi Þórðarson <email@hidden>


References:  
  >Column names with spaces (From: Hugi Þórðarson <email@hidden>)




Prev by Date:
Navision model

Next by Date:
Re: Column names with spaces

Previous by thread:
Column names with spaces

Next by thread:
Re: Column names with spaces

Index(es):

Date
Thread