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
Jamie Jackson 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?
SELECT * FROM `qry
Any ideas?
Shoot the moron who created such a stupid table name! ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
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?
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?
Jim Wright Wrote: SELECT * FROM `qry 1(1)`
Thanks, but same issue with that syntax.
Jamie
Did you do an grave accent (ascii 96), not a single quote? That works
in a local version of Access.
~|
Introducing the Fusion
On 9/26/06, Jamie Jackson [EMAIL PROTECTED] wrote:
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.
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
: 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
Perhaps you could just create a query in Access with a friendly name
that just selects all from the oddly named table. Then use that query
name in CF.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of
, September 26, 2006 4:50 PM
Subject: Re: Escaping parentheses in table names (querying MS Access DB)
Perhaps you could just create a query in Access with a friendly name
that just selects all from the oddly named table. Then use that query
name in CF
Jim Write Wrote: Did you do an grave accent (ascii 96), not a single
quote? That works in a local version of Access.
Yeah, I used the `. Unfortunately, what works *in* Access doesn't
necessarily work from CF. For instance (it's been a while since I've
used Access from CF, so don't quote
12 matches
Mail list logo