1. Thanks Wol... That worked.

2. Now a new related problem.  The data dictionaries have tons of items with 
dots... like... HK.PART.NBR.  The ColdFusion source code seems to want to use 
the dots for object notation.  Do I have to go into field <8> of all of the 
dictionary items and replace the dot there with say an underscore?

--Bill

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Friday, August 27, 2010 2:23 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] ODBC @ID Alias

 On 27/08/10 18:35, Bill Brutzman wrote:
> Is there a way to create an ODBC synonym for "@ID" ( like just "ID")... 
> dropping the "@" character ?  Thus, an external an ODBC SELECT statement 
> would show the column heading as "ID" instead of "@ID".
>
> The wizard .cfc code generator with the new ColdFusion Builder for ORM gags 
> on the "@" character.
>
> Suggestions would be appreciated.
>
ED DICT FILE @ID
SAVE ID

(then add it to the relevant @list)

Cheers,
Wol
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to