subject:"Access db Query error"

Re: Access db Query error

2003-10-17 Thread Jochem van Dieten

Mark Leder said: cfquery name=indexCitations datasource= timeout=900 SELECT * FROM citationsTable /cfquery I now want to move this over to CFMX 6.1, but running just a simple query to return all records throws the following error (after about 15 seconds): Error

RE: Access db Query error

2003-10-17 Thread Mark Leder

Jochem, That simple change to Unicode support worked. Query runs in about 1.5 seconds now. Thanks! Mark -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 5:07 AM To: CF-Talk Subject: Re: Access db Query error Mark Leder said

Access db Query error

2003-10-16 Thread Mark Leder

I presently have a query run against an Access 2000 db in preparation for a Verity CFIndex on CF5.This is 5 fields containing about 17,000 records - runs fine (but slow) on the CF5 box. Here's the query: cfquery name=indexCitations datasource= timeout=900 SELECT * FROM citationsTable /cfquery I