Did you try renaming the query named “Category”?
I’m not sure about this but it could just be a reserved word in CF5 but
not in CFMX. Dusty From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of McTure,
Greg Here are the parts of my code that the
error is referring to. Be mindful that this functionality and code works
nicely as intended on all three CFMX machines but not on the lone CF5 machine. The code is simply for dependent select
drop-downs. The first drop down displays the major categories form the
database and the 2nd and 3rd drop down equally displays
the sub categories of the category selected in the first drop down. <!DOCTYPE HTML PUBLIC "-//W3C//DTD
HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <cfquery name="Category"
datasource="EPLCommunity">
SELECT ID, Category
FROM Business_Cats
WHERE SubCatOf = 0
ORDER BY Category </cfquery> <html> <head> <meta
http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <SCRIPT
LANGUAGE="_javascript_"> <!-- Begin biz_cat = new Array( <cfloop query="Category"
startrow="1" endrow="#Category.RecordCount#"> <cfquery name="SubCategory"
datasource="EPLCommunity">
SELECT ID, Category
FROM Business_Cats
WHERE SubCatOf = #ID#
ORDER BY Category </cfquery> new Array( <CFLOOP query="SubCategory"
startrow="1" endrow="#SubCategory.RecordCount#"> <CFOUTPUT> new
Array("#SubCategory.Category#", #SubCategory.ID#)<CFIF SubCategory.CurrentRow
LT SubCategory.RecordCount>,</CFIF> </CFOUTPUT> </CFLOOP> )<CFIF Category.CurrentRow LT
Category.RecordCount>,</CFIF> </CFLOOP> ); function fillSelectFromArray(selectCtrl,
itemArray, goodPrompt, badPrompt, defaultItem) { var i, j; var prompt; // empty existing items for (i = selectCtrl.options.length; i
>= 0; i--) { selectCtrl.options[i] = null; } prompt = (itemArray != null) ? goodPrompt
: badPrompt; if (prompt == null) { j = 0; } else { selectCtrl.options[0] = new
Option(prompt); j = 1; } if (itemArray != null) { // add new items for (i = 0; i < itemArray.length; i++)
{ selectCtrl.options[j] = new
Option(itemArray[i][0]); if (itemArray[i][1] != null) { selectCtrl.options[j].value =
itemArray[i][1]; } j++; } // select first item (prompt) for sub list selectCtrl.options[0].selected = true; } } // End --> </script> From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Teddy
Payne We would need to see the
code that the error is referring to. On 8/21/06, McTure,
Greg <[EMAIL PROTECTED]
> wrote: This
is a general question to see if anyone has ran into issues with embedded CFML
code in _javascript_ with a page working in CFMX and not in CF5? The code I
have works as intended in CFMX but I get the following error on CF5? Any
suggestions that anyone may have on the cause and/or resolution of this will be
greatly appreciated. Thanks in advance. Error
Diagnostic Information
Cannot
set default query to CATEGORY A query
by this name is not available at this time The error
occurred while processing an element with a general identifier of (CFLOOP),
occupying document position (257:1) to (257:76).
------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink ------------------------------------------------------------- |
- Re: [ACFUG Discuss] C... Teddy Payne
- re[2]: [ACFUG Discuss... Mischa Uppelschoten ext 10
- RE: [ACFUG Discuss] C... Dusty Hale
- Re: [ACFUG Discuss] C... Teddy Payne
- RE: [ACFUG Discuss] C... Dusty Hale
- re[2]: [ACFUG Discuss... Mischa Uppelschoten ext 10
- Re: re[2]: [ACFUG Dis... Steven Ross
- RE: re[2]: [ACFUG Dis... Dusty Hale
- RE: re[2]: [ACFUG Dis... Dusty Hale
- RE: re[2]: [ACFUG Dis... Dusty Hale
- RE: [ACFUG Discuss] Embedded CF in Jav... Dusty Hale
- RE: [ACFUG Discuss] Embedded CF in Javascript Dusty Hale
- Re: [ACFUG Discuss] Embedded CF in Javascr... Teddy Payne
- RE: [ACFUG Discuss] Embedded CF in Jav... Dusty Hale
- RE: [ACFUG Discuss] Embedded CF in Javascr... Charlie Arehart
- RE: [ACFUG Discuss] Embedded CF in Jav... Dusty Hale