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. > > Undefined function 'FormatNumber' in expression. > > > > Any ideas? > > > > Thanks, > > Jamie > > Jim Wright Wrote: SELECT * FROM `qry 1(1)` > > Thanks, but same issue with that syntax. > > Jamie > 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 me on this), * is the wildcard while *in* Access, but from, say CF, you need to use the normal %. 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:254313 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
