RE: [ACFUG Discuss] Embedded CF in Javascript

West, Jason Mon, 21 Aug 2006 09:26:28 -0700

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
Sent: Monday, August 21, 2006 11:35
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Embedded CF in _javascript_

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 2^nd and 3^rd 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">

SELECT ID, Category

FROM Business_Cats

WHERE SubCatOf = 0

ORDER BY Category

</cfquery>

<html>

<head>

<!—

<!-- Begin

biz_cat = new Array(

SELECT ID, Category

FROM Business_Cats

WHERE SubCatOf = #ID#

ORDER BY Category

</cfquery>

new Array(

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
Sent: Monday, August 21, 2006 11:08 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Embedded CF in _javascript_

Greg,
Well, we cannot really help Greg without seeing where the query is set code wise.

Teddy

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
Sent: Monday, August 21, 2006 10:37 AM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Embedded CF in _javascript_

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

http://www.carehart.org/blog/

From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Teddy Payne
Sent: Monday, August 21, 2006 10:14 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Embedded CF in _javascript_

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).

<cf_payne />

Blog: http://cfpayne.wordpress.com/
Atlanta CFUG: http://www.acfug.org
-------------------------------------------------------------
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
-------------------------------------------------------------

--
<cf_payne />

Blog: http://cfpayne.wordpress.com/
Atlanta CFUG: http://www.acfug.org
-------------------------------------------------------------
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
-------------------------------------------------------------
-------------------------------------------------------------
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] Embedded CF in Javascript

Error Diagnostic Information

Reply via email to