Read the error message... It looks like you named the query:
qry_getBillingInfo.cfm
Remove the .cfm and it should work...
A '.' is used to specify a variable scope which creates a problem here.
HTH,
Noam
----------
From: Paddy McKay [SMTP:[EMAIL PROTECTED]]
Sent: Friday, 01 September 2000 16:45
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.
