I'll second the recommendation for ODBC only dictionaries. I would even
suggest you create a separate account with pointers to the data and keep
all your ODBC dictionaries there.
Wols Lists wrote:
On 27/08/10 21:55, Bill Brutzman wrote:
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?
What sort of dict items have you got? To me field 8 is sql data type
(PI-style D or I). But standard advice when using ODBC is to create
separate dictionaries specifically for ODBC, where you can use IDs
without dots. The other thing you can do (which is also a big pain, but
should be easy to automate...) is
ED DICT FILE HK.PART.NBR
FILE HK_PART_NBR
boring, but if the dots break ColdFusion, necessary. ime UV can cope,
but as you say, other stuff isn't expecting it ... it just clutters your
dictionary :-(
Cheers,
Wol
--Bill
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Wols Lists
Sent: Friday, August 27, 2010 2:23 PM
To: [email protected]
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
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
