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:219906 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
