Trouble with Drill Down documents
Posted: 02-18-2005, 03:00 PM
includes Data-Entry and Drill-Down forms. Databases are created in Access and,
up until a couple of weeks ago, always worked fine with Drill-Downs generated
by CF5 Studio and Homesite. Those forms done currently in CF5 Wizards for
regular data-entry still work okay. Now, however, once new drill-down
documents are created, running them on localhost via Dreamweaver, I get error
messages having to do with the query. A sample error message is attached but,
it's always the same kind of message regardless of what the Wizard-created.
Nonsense, I said...if they always worked fine before, they still should. To
make a long story short, I did total uninstalls of MS Office (2000) as well as
all ColdFusion programs and servers and reinstalled them, thinking that maybe
corrupted files were involved somewhere in the process. To reinforce that
conclusion, doing newly constructed drill-downs with the CF Wizard on some of
my older Access databases (generated in the same software from Office 2000 but,
before the reinstallation), they all work fine when viewed via the local host
in DW and also, on-line at the host server. I did update MDAC which is now
version 2.8. Other programs may need updating but, I am not sure which ones
might be suspects. If you can shed any light on this topic, it would be most
appreciated. Thank you very much.
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression '2fishlog.identifier'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (11:1) to (11:50).



Linear Mode


Posts: n/a