actually, there was a typo on my behalf. the page works as below.
thanks rod and dale. >>> [EMAIL PROTECTED] 31/08/2006 4:19:23 pm >>> <CFQUERY datasource="#DSN#" name="SESSION.SECTOR"> SELECT SB_SECTOR_ID, SB_SECTOR_DESC FROM SB_SECTOR ORDER BY SB_SECTOR_ID </CFQUERY> <cfoutput query="SESSION.SECTOR"> <cfset FORM.EXTRACT_DATE_TO = '01-jan-1990'> <cfset FORM.SB_SECTOR_ID = SB_SECTOR_ID> <!--- Run program for each sector ---> Startting #SB_SECTOR_DESC# <br> <cfflush> <cfinclude template="sbmt215_act.cfm"> Completed #SB_SECTOR_DESC# <br> <cfflush> </cfoutput> Doesn't work ?? I know cfflush likes to cause problems with cookie's, cflocation, etc but I didn't think there was a problem with cfoutput ...?? ----- Original Message ----- From: "Scott Thornton" <[EMAIL PROTECTED]> To: <cfaussie@googlegroups.com> Sent: Thursday, August 31, 2006 4:08 PM Subject: [cfaussie] Multiple calls of the same page Nope, that does not work. The value of the attribute query, which is currently "SESSION.SECTOR", is invalid. >>> [EMAIL PROTECTED] 31/08/2006 3:52:02 pm >>> <CFQUERY datasource="#DSN#" name="SESSION.SECTOR"> ?? ----- Original Message ----- From: "Scott Thornton" <[EMAIL PROTECTED]> To: <cfaussie@googlegroups.com> Sent: Thursday, August 31, 2006 3:44 PM Subject: [cfaussie] Multiple calls of the same page Hi, I want to call a certain page (in a cf schedule) from within a cfoutput query="" so it runs a number of times. This page is an action page that has form info posted to it and runs for quite a long while. Essentially I would want to set some form variables based on the query and include (or by some other method run ) the page. The problem is that once the included page has executed once, the original query no longer exists. (or so it seems) eg <CFQUERY datasource="#DSN#" name="SECTOR"> SELECT SB_SECTOR_ID, SB_SECTOR_DESC FROM SB_SECTOR ORDER BY SB_SECTOR_ID </CFQUERY> <cfoutput query="SECTOR"> <cfset FORM.EXTRACT_DATE_TO = '01-jan-1990'> <cfset FORM.SB_SECTOR_ID = sector.SB_SECTOR_ID> <!--- Run program for each sector ---> Startting #SECTOR.SB_SECTOR_DESC# <br> <cfflush> <cfinclude template="sbmt215_act.cfm"> Completed #SECTOR.SB_SECTOR_DESC# <br> <cfflush> </cfoutput> The error is "Element SB_SECTOR_ID is undefined in SECTOR. " There are only 6 records in the sector query, so I could, hard code it all, but I would prefer not to. Any advice? Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
