Trouble with Drill Down documents

[Slowtroll]

I have regularly used CF5 Wizards to build most of my simple forms. This
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).

[ben]

Without a sample query it is difficult to say, but I'm almost sure
variables (and query names) need to start with a character, not a number
like '2fishlog'.

Slowtroll wrote:

> I have regularly used CF5 Wizards to build most of my simple forms. This
> 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).
>