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. I actually did post the code in a reply to
one of the earlier responses but I guess it hasn’t made it to the list so here
it is again: <!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_"
type="text/_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 Greg, On 8/21/06, McTure,
Greg <
[EMAIL PROTECTED]> wrote: The query does exist and specifically it is the very first
piece of code on the page. I've sent the code and the CFLOOP is simply to
loop through the query return of major categories to populate a dependent
secondary drop down with the corresponding sub-categories. Again, this
works without error on three CFMX boxes which is why I suspect it may be a CF5
issue with something in the JavaScipt/CFML mix of code. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Charlie Arehart Also, by " embedded
CFML code in _javascript_" do you mean simply
CFML code that's building _javascript_ in a .cfm template. In that case, it
doesn't really matter if it's creating JS or HTML. The error just reflects a
problem in the code or config. That said, I can't say I've ever seen
"cannot set default query to xxx". I see it's saying it's in a loop.
As Teddy says, seeing the code will be interesting. It's also just saying that
a query named "Category" doesn't exist. Does it? /charlie From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Teddy Payne We would need to see the
code that the error is referring to. Teddy 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 ------------------------------------------------------------- |
- [ACFUG Discuss] Embedded CF in Javascript McTure, Greg
- Re: [ACFUG Discuss] Embedded CF in Javascr... Teddy Payne
- RE: [ACFUG Discuss] Embedded CF in Jav... Charlie Arehart
- RE: [ACFUG Discuss] Embedded CF in... McTure, Greg
- Re: [ACFUG Discuss] Embedded C... Teddy Payne
- RE: [ACFUG Discuss] Embed... McTure, Greg
- Re: [ACFUG Discuss] E... Teddy Payne
- RE: [ACFUG Discuss] E... West, Jason
- re[2]: [ACFUG Discuss] Embedde... Mischa Uppelschoten ext 10
- Re: re[2]: [ACFUG Discuss... Teddy Payne
- RE: [ACFUG Discuss] Embedded C... Gerrey . Mary-Catherine
- RE: [ACFUG Discuss] Embedded CF in Jav... McTure, Greg
- Re: [ACFUG Discuss] Embedded CF in... Teddy Payne
- RE: [ACFUG Discuss] Embedded C... West, Jason
- Re: [ACFUG Discuss] Embed... Teddy Payne
- RE: [ACFUG Discuss] E... West, Jason