Greg, This might be a stupid question but have
you tried moving the Category query above the DOCTYPE tag? I don’t think
this has to do with the version of the server but rather the way includes are
being called. I only say that because the initial error message you sent out
gave some high line count and I am assuming the Category query is being
included from a library or something to that effect. My suggestions would be
to move the CFML code a round a little and see if this helps the CFML parser
from getting confused. Remember you are regressing back to an older version of
the server so there may be issues with the tag attributes as well. I don’t
have the time to research the attributes but from first glance they seem to be
valid. I don’t remember but on Ver 5 of the CFML server you might have
had to specify the dbtype so as it would not be confused. Been a while. J Jason From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of McTure,
Greg 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 ------------------------------------------------------------- ------------------------------------------------------------- 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
- re[2]: [ACFUG Discuss] Embedded CF... Mischa Uppelschoten ext 10
- RE: re[2]: [ACFUG Discuss] Emb... McTure, Greg