Trouble with Drill Down documents

Posted: 02-18-2005, 03:00 PM
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).

Reply With Quote

Responses to "Trouble with Drill Down documents"

ben
Guest
Posts: n/a
 
Re: Trouble with Drill Down documents
Posted: 02-21-2005, 10:52 PM
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).
>
Reply With Quote
 
LinkBack Thread Tools Search this Thread Display Modes
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
paste align to diff sized documents as action Josh Conley Adobe Photoshop 7, CS, CS2 & CS3 2 06-30-2003 06:37 AM