Not real familiar with access, and not sure if access has the "ESCAPE"
function or if the escape function will work on table names.
IE:
select * from mytable(1) ESCAPE '(' ESCAPE ')'
----- Original Message -----
From: "Jamie Jackson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[email protected]>
Sent: Tuesday, September 26, 2006 4:34 PM
Subject: Re: Escaping parentheses in table names (querying MS Access DB)
> I don't think this is going to be possible. I think the tables will
> have to be renamed. I hate Access for (among other things) allowing
> such odd, non-interoperable entity names. I was hoping not to have to
> dig into this ugly, inherited DB.
>
> However, I hope I'm wrong, and that someone knows a workaround....
>
> Jamie
>
> On 9/26/06, Jamie Jackson <[EMAIL PROTECTED]> wrote:
> > The table name is "qry 1(1)" (everything between the quotes).
> >
> > SELECT
> > *
> > FROM
> > [qry 1(1)]
> >
> > I tried the above, but it yields:
> >
> > Error Executing Database Query.
> > Undefined function 'FormatNumber' in expression.
> >
> > Any ideas?
> >
> > Thanks,
> > Jamie
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254320
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
