>> > 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
What version of CF are you using? I just did a test in my local install of CF7, and the ` syntax worked fine (with both the Access driver and the ODBC Socket). Are you sure that you are working with a table here? Looking back at your previous message, the error "Undefined function 'FormatNumber' in expression." seems more like something you would see from a query. I'm betting that this is a query that has a field using the vba formatnumber function. That function is available to Access, but it doesn't seem to be available through ODBC or JDBC. I just tested this by creating a view that uses the FormatNumber function, and sure enough, I get that error when I try to pull data through CF. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:254326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
