Sorry, still no good. It stops at this line now : "<cf_SelectOffices SelectedOfficeID="#SelectedOfficeID#">"
Removing the double quotes makes no diff. > Andrew - > > In CF when passing in paramaters to a tag they come in through the 'attributes' > scope - so > you're eventual tag should look something like: > (Also added cfqueryparam as well to your query) > > <cfparam name="attributes.SelectedOfficeID" type="numeric"> > > <cfoutput> > <cfquery name="getOfficeLocs" datasource="mydata"> > SELECT YOfficeID AS SelectedOfficeID, OfficeName > FROM YesOffices > WHERE Active = 1 > ORDER BY OfficeName > </cfquery> > <cfquery name="getSelectedOffice" datasource="mydata"> > SELECT YOfficeID AS SelectedOfficeID, OfficeName > FROM YesOffices > WHERE Active = 1 > and Yofficeid= <cfqueryparam > value="#attributes.SelectedOfficeID#" > cfsqltype="CF_SQL_NUMERIC"> > </cfquery> > </cfoutput> > > To get the details out - you will probably need to look into the 'caller' scope as > well - which is > essentially the 'variables' scope of the page that called the module. > > Hope that helps you out. > > Mark > ------------------------------------------------------------------ > [EMAIL PROTECTED] > ICQ: 3094740 > Safe From Bees > [ www.safefrombees.com ] > > > Quoting Andrew Dickinson <[EMAIL PROTECTED]>: > > > My first tag is not going according to plan. > > > > I'm attempting to reuse this code : > > > > <cfoutput> > > <cfquery name="getOfficeLocs" datasource="mydata"> > > SELECT YOfficeID AS SelectedOfficeID, OfficeName > > FROM YesOffices > > WHERE Active = 1 > > ORDER BY OfficeName > > </cfquery> > > <cfquery name="getSelectedOffice" datasource="mydata"> > > SELECT YOfficeID AS SelectedOfficeID, OfficeName > > FROM YesOffices > > WHERE Active = 1 > > and Yofficeid=#SelectedOfficeID# > > </cfquery> > > </cfoutput> > > > > ... which sets up for a dropdown menu. > > > > I've saved this code as SelectOffices.cfm, and called it as > > <cf_selectoffices> - this is as > > the CFMX reference manual suggests. > > > > The problem seems to be the parameter. When I modify the call to > > <cf_selectoffices SelectedOfficeID="#SelectedOfficeID#"> > > it falls over, pointing to an error on this line > > "and Yofficeid=#SelectedOfficeID#" > > > > So I went back to the book and followed the starter example, wihch simply > > creates a file called date.cfm containing today's date, then calls <cf_date> > > from a > > different program. This works. However, when I try to pass a parameter, > > any parameter, using any of the methods in the book, it doesn't work (i.e > > throws an error). > > > > What am I missing here ? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
