<cfset user = "#username#_#ObjectID#"> <cfquery datasource="#request.cfa.objectstore.dsn#" name="GetPlpInstanceID"> Select plpinstanceid from plpinstances where username = '#user#' order by dtexpires; </cfquery>
display this in a cfoutput query and you should get all the ID's based on the user and Object ID Ernie Pena Sr. CF Developer M.D. ANDERSON ----- Original Message ----- From: "jeff tapper" <[EMAIL PROTECTED]> To: "Spectra-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 15, 2002 11:48 AM Subject: Workflow / PLP question I've got a PLP inside an edit handler created as an artifact of a workflow. When the PLP is done, i want to be able to run a CFA_WORKFLOWTASKEND, but need the workflow instance ID in order to run the tag. Anyone have any clever ideas on how to get that? I have the task id, from the URL, can i extrapolate the instance id from that? Jeff Tapper [EMAIL PROTECTED] Radio Free Astoria http://radio.tapper.net ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
