and brackets).
If you want a patch for the first part, please let me know.
bye
Thoralf
-Ursprüngliche Nachricht-
Von: Greg Monroe [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 11. April 2008 15:16
An: Apache Torque Users List
Betreff: RE: Column names with spaces
OK, short version
Thoralf Rickert wrote:
Hi,
Of course the list of problems with mssql doesn't stop...
I've got now a xml schema from the existing database. Some lovely boy decided years ago that it
would be nice to use spaces inside the column names of the database scheme. For example: Time
after
I would use the torque-generator to migrate the database to a new schema
where column names with spaces don't exist. Then, I would use that
database instead. Takes approximately 10 minutes to do.
--
Leo Przybylski
Application Systems Analyst, Senior
Department of Sponsored Projects Services
Hi,
Of course the list of problems with mssql doesn't stop...
I've got now a xml schema from the existing database. Some lovely boy decided
years ago that it would be nice to use spaces inside the column names of the
database scheme. For example: Time after. This is not a problem if you use
the column
names
of the database scheme. For example: Time after. This is not a problem
if
you use the special syntax [Time after] in a select. But I don't have
this
kind of access with Torque (prove me wrong, if not). If I try to make a
Criteria, Torque quits this selection with
Malformed column
'
Subject: Column names with spaces
Hi,
Of course the list of problems with mssql doesn't stop...
I've got now a xml schema from the existing database. Some lovely
boy
decided years ago that it would be nice to use spaces inside the
column
names of the database scheme. For example: Time after
: Greg Monroe [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 11. April 2008 15:16
An: Apache Torque Users List
Betreff: RE: Column names with spaces
OK, short version: If you can't change the existing schema,
use a view to get valid names.
Longer version:
Actually, the [ syntax is not the only