Umm...take ".cfm" out of the query name :o)
Hope that helps
Paddy McKay wrote:
> 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.
--
Bryan Stevenson
Electric Canvas Technologies
Inter/Intranet Development
www.ecanvas.com
[EMAIL PROTECTED]
(250) 920-8830
-------------------------------------------
Allaire Alliance Partner
www.allaire.com
------------------------------------------------------------------------------
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.
