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. Here isn't the place to get really into PLSql - have a chat with ya DBA, it's fairly easy to get your head around :-) -- Tom C "Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
