so it could be... > > P20070506-1, P20070506-2 or P20070506-59 > > what i wish to be able to do is query a database based on the last set > of numbers eg. 1, 2 or 59 in the examples above. >
Looks like a simple ListLast() should do the trick. You'll need to put that entire string in a variable. Then grab the 1,2, or 59 like this: <cfset thetxid = listLast(thevarname, "-")> Then query your db using the txid var. hth, will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
