Try re-writing your query like this -
select tblBilling.id from tblBilling where tblBilling.siteid = '1019'"
Your scoping each field, so Access 97 may require it in the Where statement
also.
-----Original Message-----
From: Paddy McKay [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 9:45 AM
To: Fusebox
Subject: Error: Unable to register query
Does anyone know what is causing this? I initially thought it was
something to do with Fusebox, but when I call the query template by
itself the error still comes up.
It is a pretty simple query running on an Access97 table, under CF4.5.1
and IIS.
TIA
paddy
-----------------------------------------------
Error Diagnostic Information
Cannot process query
Cannot register the query named qry_getBillingInfo.cfm with ColdFusion.
There are two likely causes of this problem:
You are using a CFQUERY tag with a scoped query name. Query names
cannot be scoped. For example, MyProject.MyQuery is an invalid query
name.
The query was set as the default query for a tag like CFOUTPUT,
CFLOOP, CFMAIL, etc. However, in the body of the tag this query was
modified or
removed. Default queries cannot be modified or removed inside the
bodies of the tags that use them.
SQL = "select tblBilling.id from tblBilling where siteid = '1019'"
Data Source = "SPNLOG"
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (3:1) to (3:60) in
the template file
D:\WebSite\htdocs\Dev\search\admin\usagebilling\qry_GETBILLINGINFO.cfm.
Date/Time: 09/01/00 15:39:24
Browser: Mozilla/4.7 [en] (WinNT; I)
Remote Address: 146.191.101.109
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
