if i remove the join on the lkp_ticket_types table then the variable is passed through correctly.
works in cfmx 6.1 dies in cfmx 7.1 On 10/3/05, Adrian Lynch <[EMAIL PROTECTED]> wrote: > Just to be clear, when you say 'value', you do mean in the cfqueryparam? Not > the result from the query? > > Ade > > -----Original Message----- > From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED] > Sent: 03 October 2005 17:07 > To: CF-Talk > Subject: Re: missing argument in a function > > > yes. if the joins are in the query the value is empty. if i remove the > joins the value is valid. > > On 10/3/05, Adrian Lynch <[EMAIL PROTECTED]> wrote: > > Are you saying that: > > > > <cfqueryparam cfsqltype="cf_sql_integer" value="#Ticket_ID#" /> > > > > is either passing in a blank value or the right value depending on the SQL > > statement above it? > > > > Ade > > > > -----Original Message----- > > From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED] > > Sent: 03 October 2005 16:54 > > To: CF-Talk > > Subject: missing argument in a function > > > > > > i have a function that takes a ticket_id as an argument. the function > > runs a query and returns it. i have found that > > > > if the query runs like this: > > > > INNER JOIN lkp_Ticket_Types ON tbl_Tickets.Type_ID = > > lkp_Ticket_Types.Type_ID > > INNER JOIN lkp_Ticket_Status ON > tbl_Tickets.Status_ID = > > lkp_Ticket_Status.Status_ID > > INNER JOIN lkp_Ticket_Severity ON > tbl_Tickets.Severity_ID = > > lkp_Ticket_Severity.Severity_ID > > INNER JOIN tbl_Projects ON tbl_Tickets.Project_ID > = > > tbl_Projects.Project_ID > > LEFT OUTER JOIN lkp_Releases ON > tbl_Tickets.Release_ID = > > lkp_Releases.Release_ID > > WHERE tbl_Tickets.Ticket_ID = <cfqueryparam > > cfsqltype="cf_sql_integer" value="#Ticket_ID#" /> > > > > #ticket_id# is blank. BUT > > > > if i removed all the joined tables and just do a query on the /main/ > > table the where clause is valid (#ticket_id#) holds the proper value. > > > > any ideas what is/could be causing this? anyone seen anything like this > > before? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219909 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54