Nice one Tom, cheers :-) DBA's not in today but will sit down with them and discuss what you've said... plus I'll look like I know a wee bit about it now :-)
> On Thursday 29 May 2003 12:40 pm, David Collie (itndac) wrote: > > > <cfquery name="qCM_GetQuestionAnswers" > > datasource="#APPLICATION.sIF_DSN#"> > > SELECT .....PARENTANSWER > > try parentanwser(1) > > > I'm not sure how I can get parent answer to return a (say) > list that I > > can use in the query using the code below... and it's my > ignorance not > > your code :-) > > You'll need command line access to Oracle (sqlplus or > something) to create the > procedure. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
